Connecting to MS Access Database using PHP via ODBC.
| From: | ABCOM Support | Date: | Thu, 15 Mar 2007 11:53:18 +0000 |
| Subject: | Connecting to MS Access Database using PHP via ODBC. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-43285@lists.php.net to get a copy of this message | ||
Hello,
Im using PHP to connect to a Microsoft Access database which is not stored
on the machine where IIS is installed. It's located on a different file
server on the network.
I have mapped a network drive to where the database is stored and have used
it when creating the System DSN.
The problem is the the php script cannot connect. If I move a copy of the
database over to the server where IIS is installed and update the System DSN
to point to that it all works fine.
I was made aware that you could have the database on a different machine and
it would work, but this doesnt seem to be the case.
Can anyone shed some light on this?
Many thanks.