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
$rs->Close();
$db->Close();
echo "Ran code sucessfully";
?>