php-windows Digest 20 Jun 2005 21:33:38 -0000 Issue 2701
Topics (messages 26123 through 26123):
Access connection
26123 by: Matt Murphy
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[email protected]
----------------------------------------------------------------------
--- Begin 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
--- End Message ---
