[PHP-DB] Connecting to MS Access Database using PHP via ODBC.

2007-03-15 Thread ABCOM Support 
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. 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Connecting to MS Access Database using PHP via ODBC.

2007-03-15 Thread Frank M. Kromann 
Sounds like a permission problem. Make sure the IIS user (IUSR_maschine
name) has access to the share.

- Frank

 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. 
 
 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php