DSN less PHP to Access connection error

danindublin

I've been trying to connect to a simple access database using php (access was not my idea) but keep falling over at Execute(). Is there any way to get the output of why this is falling over? I have adodb installed on my server and test.mdb is sitting on the c:\ drive.

Any help is greatly appreciated!

D

<?php
include("adodb.inc.php");
$database_type = "access";
$db = NewADOConnection("$database_type");
$dsn = "Driver={Microsoft Access Driver (*.mdb)};Dbq=c:\\test.mdb;Uid=;Pwd=;";
$db->Connect($dsn);
$sql = "SELECT * FROM tbl1";
$rs = &$db->Execute($sql); //Fall at this point
if (!$rs) {
print $db->ErrorMsg();
}
else
echo "Ran code sucessfully";
?>

Seth Brundle

have a look at the block of code in this: http://www.experts-exchange.com/Web/Web_Languages/PHP/PHP_Databases/Q_20973403.html
Should if(!$rs)
be
if (!$rs->EOF)

Don't forget to close your recordset and connection