Access connection
| From: | Matt Murphy | Date: | Mon, 20 Jun 2005 21:33:52 +0000 |
| Subject: | Access connection | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-26123@lists.php.net to get a copy of this message | ||
All,
I'm moving a LAMP site to windows and I'm having one small hurdle. I'm
trying to connect to an access db that's used by our UPS software, so I
can access status of shipments. I'm using an odbc connection, and
amazingly, while it works under linux, it does not under windows! I've
set the odbc config in the control panel to what I think should be
correct, but I'm getting this error:
Warning: odbc_connect(): 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:\www\html\portal\ups_tracking.php on line 126
Line 126 is: $myDB = odbc_connect('UPSDB','','');
Thanks!
Matt