I copied this right of a tutorial. Created a DSN. And I am recieving the following errors. Can someone please help me debug this.
Error:
Warning: SQL error: , SQL state 00000 in SQLConnect in C:\PHP\ADODB\drivers\adodb-odbc.inc.php on line 166
Code:
<?
include('C://PHP//ADODB//adodb.inc.php'); # load code common to ADOdb
$conn = &ADONewConnection('access'); # create a connection
$conn->PConnect('rbc'); # connect to MS-Access, northwind DSN
$recordSet = &$conn->Execute('select * from Event');
if (!$recordSet)
print $conn->ErrorMsg();
else
while (!$recordSet->EOF) {
print $recordSet->fields[0].' '.$recordSet->fields[1].'<BR>';
$recordSet->MoveNext();
}
$recordSet->Close(); # optional
$conn->Close(); # optional
?>
