I'm trying to connect up w/ an Access database one of our db administrators
set up.

The Access file has an "adp" extension...the data is housed in a view,
(essentially a read-only dump of some MS SQL Server tables).

I've set up the file as a System DSN in ODBC (WinNT)

When I issue the following command:

  $conn_id = odbc_connect($db, $username, $password) or die();

I get the following error:

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 C:\Inetpub\wwwroot/seating/sharondb.php on line

Any ideas? I am supplying the correct username and password...


Chip Hankley

PHP General 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