I'm just beginning experimenting with MS Access and PHP. I found all the
tutorials online that explain how to create a DSN for my existing Access
database, and went through the procedure fine. The DSN I chose is
"prototype" and the database does not have a username or password. I then
created a very simple script:

<TITLE>Access connection</TITLE>
    #Open a connection to an access database
    $connection = odbc_connect("prototype","","");
    if ($connection){
        echo "Connection established<br>\n";
    } else {
        echo "Connection NOT established<br>\n";

When running this file, I get the following output:

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 D:\www\Lalli\php\access.php on line 7
Connection NOT established

The server is running MS WinNT 4.0 SP6, with PHP 4.0. Can anyone help me

Thank you,
Paul Lalli

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to