Connecting to MS Access Database using PHP via ODBC.

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: Connecting to MS Access Database using

Sounds like a permission problem. Make sure the IIS user (IUSR_ 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

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"" , 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.

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