Check the file permissions on the .mdb file. Make sure it is readable by

Bye, John

Paul Lalli <[EMAIL PROTECTED]> wrote in message
> Hello,
> 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:
> <HTML>
> <HEAD>
> <TITLE>Access connection</TITLE>
> <BODY>
> <?php
>     #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
> 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
> out?
> Thank you,
> Paul Lalli

PHP Database Mailing List (
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