ok ben real halp this time i promise

$db = new COM("ADODB.Connection")
or die("Could not start ADO");
$db->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\inetpub\wwwroot\accessDB\testDB.mdb;")
or die("Could not open connection");

errors out on "could not open connection". newest version of php, win2k advanced server, com is set up with the right permissions, the folder and db have the right permissions.

OK update, it "SEEMS" to be connecting, but I get no results from my query. and yes there is data in the table.

<?php

$db = new COM("ADODB.Connection")
or die("Could not start ADO");
$db->Open("testDB");
or die("Could not open connection");

$rs = $db->execute("SELECT * FROM news")
or die("Query Failed");

while (!$rs->EOF) {
$user = $rs->Fields('user');
print $user->value;
}

$rs->close();
$db->close();

?>

I hate to tell ya but i dont know ADODB.

i thought you knew everything. you've just ruined my whole belief system

crazytrain81,

life is full of disapointments

ha ha ha

dude buy A BOOK from amazon please and learn .

Sorry americand, i should've put a disclaimer *** *** ***** here who don't pick up on sarcasm.


*edit: please refrain from insults*