Home > Archive > PHP DB > March 2007 > Connecting to MS Access Database using PHP via ODBC.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Connecting to MS Access Database using PHP via ODBC.
|
|
| ABCOM Support 2007-03-15, 7:59 am |
| 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.
| |
| Haydar TUNA 2007-03-18, 4:01 am |
| 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.
|
|
|
|
|