Page 1 of 1

PHP + Access via odbc problem

Posted: Wed Mar 12, 2008 6:13 am
by hswolfs
Hi all,

I have the following problem :

I have to make a connection to an access database via PHP. The only problem is that this access-db isn't located on the same server (both Windows 2003) than the IIS is running on.

This is what I've done so far :
I created a network-drive to the folder that's hosting the db
Used that network-drive to create a System-DSN on the IIS-server
Gave IUSR_servername account full control rights over the share, the network-drive and the database itself

If I try to make the connection however, I only get a white screen (tried FF and IE) so no error at all.

If I copy the database to the IIS-server and update the System-DSN, everything works so this makes me conclude that the code is ok but something with network-rights is being a major pain in the butt.

Any idea why this isn't working? MySQL is not an option unfortunately :(

Thanks in advance!