PHP + Access via odbc problem
Posted: Wed Mar 12, 2008 6:13 am
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!
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!