[PHP-DB] Problems with ODBC connectivity

2002-10-29 Thread Bill Hudspeth
I have developed a PHP application that accesses a Microsoft Access database through ODBC. The application works well using PHP version 4.1. I have recently installed the newest version of PHP (4.2.3) on another machine running NT4, and IIS 4. Again, I am using an ODBC connection, and have given

[PHP-DB] Multiple outer joins submitted via ODBC driver to MS Access??

2002-08-29 Thread Bill Hudspeth
I am using PHP 4.1 with the ODBC driver on MS Windows 2000, running IIS. I am trying to submit a SQL statement with multiple outer joins to a MS Access database. Does anyone know the syntax for creating such MULTIPLE outer joins? As it is, my current SQL statement drops rows for which certain

[PHP-DB] Connecting to MS Access

2002-06-12 Thread Bill Hudspeth
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: