Re: Connecting to MS Access Database using PHP via ODBC.

Hello, Mr Frank is right. This is permission problem. I faced same problem to run Oracle and MS Access in Windows 2003. Microsoft has changed user privileges in Windows 2003. For example, I run a PHP program connect to oracle in Windows XP but it isn't run in Windows 2003. When I changed oracle installation directory's user privileges in Windows 2003, I was running php and oracle together. :) -- Haydar TUNA Republic Of Turkey - Ministry of National Education Education Technology Department Ankara / TURKEY Web: http://www.haydartuna.net ""ABCOM Support"" <support@abcom.co.uk>, haber iletisinde þunlarý yazdý:1E.6A.24282.3B339F54@pb1.pair.com... > 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.