studio_two
Posts: 27
|
| Posted: 06/28/2007, 7:54 AM |
|
Hello,
I am trying connect to an ODBC MS Access database file stored on a different server to the one I am running apache / php on. Both are Microsoft Windows Servers on the same network.
I originally created a copy of my ".mdb" file on the apache server (for testing purposes) and this works fine.
However, as soon as I change my ODBC Driver to point to the other server, I get the dreaded "Database error: Link-ID == false, odbc_pconnect failed" error.
I thought this might be a a permissions issue - but making the share available to "everyone" (and even adding the domain password into the odbc driver) did not help.
Can anyone help please?
TIA,
Stephen
|
 |
 |
studio_two
Posts: 27
|
| Posted: 06/29/2007, 12:03 AM |
|
The title of the post should obviously read "ODBC / MS Access hosted on another MS Windows Server"
TIA,
Stephen
|
|
|
|
studio_two
Posts: 27
|
| Posted: 06/29/2007, 12:50 AM |
|
I finally resolved this - after realising that the ODBC driver was using a "Drive Letter" to attach to the other server.
As soon as I switched to the full path "\\myserver\msaccess\mydatabase.mdb", the connection began working. Presumably, the local system account (used by apache) cannot use "drive letters" to access other servers.
Finally, I also had to give the apache server permissions to the database folder on the other server.
Stephen
|
|
|
|
|
