[PHP-DB] 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"" <[EMAIL PROTECTED]>, haber iletisinde þunlarý yazdý:[EMAIL PROTECTED] > 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-DB] Re: Connecting to MS Access
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says...
> I am having problems connecting to an Access database. I am using Windows
> 2000, IIS 4, Access 2000, and PHP 4.2.1. I have created a system DSN using
> the Access (.mdb) driver, and have a username and password. What's going
> on?? Thanks, Bill
>
>
>
> The code I have used is as follows:
>
>
>
>
>
>
>
>
>
>
> //connect to database
>
> $connectionstring = odbc_connect("meteoritecatalog", "username",
> "password");
>
> //line 14 is immediately above
>
>
>
> //SQL Query
>
> $query = "SELECT sample, type FROM sample";
>
>
>
> //execute query
>
> $queryexe = odbc_do($connectionstring, $query);
>
> //line 20 above
>
>
>
> //output results to standard output
>
> odbc_result_all($queryexe, "BORDER=1");
>
> //line 23 above
Well, never used ODBC and Access, but shouldn't there be something
somewhere that defines the host on which the DSN may be found?
--
David Robley
Temporary Kiwi!
Quod subigo farinam
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
