I am running PHP and Apache and have a problem connecting to an Ms Access database
I cannot connect to my database. I am using an Apache Server with PHP. Now as far as I can see these work fine apart from some dll files in PHP. I have also set up an ODBC connection to my database, but when I try and run the PHP code I get errors. This is the PHP code I am using. The ODBC is called link1 and the database db1. <?php $db = ODBC_Connect("link1", "",""); $res = ODBC_Exec($db, "SELECT Employee.Name FROM Employee;"); while (ODBC_Fetch_Row($res)) { echo "<TR><TD>".ODBC_Result($res, 'fieldname')."</TD></TR>"; } ODBC_Free_Result($res); ?> These are the errors that it returns X-Powered-By: PHP/4.0.6 Content-type: text/html Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data., SQL state S1000 in SQLConnect in o:\program files\apache group\apache\htdocs\name1.php on line 2 Warning: Supplied argument is not a valid ODBC-Link resource in o:\program files\apache group\apache\htdocs\name1.php on line 3 Warning: Supplied argument is not a valid ODBC result resource in o:\program files\apache group\apache\htdocs\name1.php on line 4 Warning: Supplied argument is not a valid ODBC result resource in o:\program files\apache group\apache\htdocs\name1.php on line 7 Any help on where to go would be great. Thanks a million Ronan _________________________________________________________________ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php