PHP + Access via odbc problem

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
hswolfs
Forum Newbie
Posts: 1
Joined: Wed Mar 12, 2008 6:08 am

PHP + Access via odbc problem

Post 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!
Post Reply