ODBC to MS-Access View?

From: 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

« previous php.general (#57769) next »