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
