ODBC to MS-Access View?
| From: | Hankley, Chip | Date: | Fri, 13 Jul 2001 17:51:15 +0000 |
| Subject: | ODBC to MS-Access View? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-57769@lists.php.net to get a copy of this message | ||
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
36
Any ideas? I am supplying the correct username and password...
Thanks
Chip Hankley