[PHP-DB] 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: [PHP-DB] Connecting to MS Access Database using PHP via ODBC.
Sounds like a permission problem. Make sure the IIS user (IUSR_maschine 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
[PHP-DB] Connecting to MS Access DB in PHP, on Linux, Apache
Anyone got any good websites or resources on how to connect to an access database and perform sql querrys etc, in Linux running apache? or if anyone has the connection strings required thanks in advance !! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Connecting to MS Access DB in PHP, on Linux, Apache
Sure!!! Take a look on: http://www.weberdev.com http://odbtp.sourceforge.net/ My personal suggest is to use odbtp whith pear DB interface. Regards, Luis Morales rob wrote: Anyone got any good websites or resources on how to connect to an access database and perform sql querrys etc, in Linux running apache? or if anyone has the connection strings required thanks in advance !! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Connecting to MS Access
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: ?php //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 //disconnect from the database odbc_close($connectionstring); //line 26 above ? The error message I get is: Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver]General error Not enough information to connect to this DSN with SQLConnect. Use SQLDriverConnect., SQL state S1000 in SQLConnect in C:\inetpub\wwwroot\PHP\data_tap.php on line 14 Warning: odbc_do(): supplied argument is not a valid ODBC-Link resource in C:\inetpub\wwwroot\PHP\data_tap.php on line 20 Warning: odbc_result_all(): supplied argument is not a valid ODBC result resource in C:\inetpub\wwwroot\PHP\data_tap.php on line 23 Warning: odbc_close(): supplied argument is not a valid ODBC-Link resource in C:\inetpub\wwwroot\PHP\data_tap.php on line 26 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Connecting to MS Access
I've duplicated your problem. I know I've had this working before, I'll let you know if I can figure it out. :-) Ryan -Original Message- From: Bill Hudspeth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 10:22 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Connecting to MS Access 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: ?php //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 //disconnect from the database odbc_close($connectionstring); //line 26 above ? The error message I get is: Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver]General error Not enough information to connect to this DSN with SQLConnect. Use SQLDriverConnect., SQL state S1000 in SQLConnect in C:\inetpub\wwwroot\PHP\data_tap.php on line 14 Warning: odbc_do(): supplied argument is not a valid ODBC-Link resource in C:\inetpub\wwwroot\PHP\data_tap.php on line 20 Warning: odbc_result_all(): supplied argument is not a valid ODBC result resource in C:\inetpub\wwwroot\PHP\data_tap.php on line 23 Warning: odbc_close(): supplied argument is not a valid ODBC-Link resource in C:\inetpub\wwwroot\PHP\data_tap.php on line 26 -- 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: [PHP-DB] Connecting to MS Access
It is the error message you get when you haven't selected the database file for your DSN. Go to your DSN, click configure, and click the SELECT button on the dsn. :-) Ryan -Original Message- From: Ryan Jameson (USA) Sent: Wednesday, June 12, 2002 1:09 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Connecting to MS Access I've duplicated your problem. I know I've had this working before, I'll let you know if I can figure it out. :-) Ryan -Original Message- From: Bill Hudspeth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 10:22 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Connecting to MS Access 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: ?php //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 //disconnect from the database odbc_close($connectionstring); //line 26 above ? The error message I get is: Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver]General error Not enough information to connect to this DSN with SQLConnect. Use SQLDriverConnect., SQL state S1000 in SQLConnect in C:\inetpub\wwwroot\PHP\data_tap.php on line 14 Warning: odbc_do(): supplied argument is not a valid ODBC-Link resource in C:\inetpub\wwwroot\PHP\data_tap.php on line 20 Warning: odbc_result_all(): supplied argument is not a valid ODBC result resource in C:\inetpub\wwwroot\PHP\data_tap.php on line 23 Warning: odbc_close(): supplied argument is not a valid ODBC-Link resource in C:\inetpub\wwwroot\PHP\data_tap.php on line 26 -- 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php