RE: [PHP-DB] ODBC

No, that won't work. You need to create a system DSN. Here's what I did to create one. My PC is running Windows XP Professional and I am using Apache 1.3.27. * opened up the control panel * double-clicked Administrative Tools * double-clicked Data Sources (ODBC) * clicked on the System DSN tab * clicked Add... * selected Microsoft Access Driver (*.mdb) from the list * clicked Finish * typed mctadb in Data Source Name * clicked on Select... * selected the MS Access database I wanted to connect to and clicked OK * clicked on Advance... * typed in a Login name then clicked OK * clicked OK in the next 2 windows I could use some help as well. I get connected to the database but get an error when I try to execute a SQL statement on it. The error message I get is: Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in c:\program files\apache group\apache\htdocs\test2.php on line 30 cannot prepare result Does anyone know what might be missing? Here's the code from test2.php: $connection = odbc_connect("mctadb", "admin", "") || die("cannot open database"); $sql = "SELECT * FROM Meeting"; $result = odbc_exec($connection, $sql) || die("cannot prepare result"); ---------------------- Beverly Steiner steiner277@charter.net -----Original Message----- From: Kiswa [mailto:Kiswa@telia.com] Sent: Friday, March 07, 2003 3:24 PM To: php-db@lists.php.net Subject: [PHP-DB] ODBC Hi. Is their anyway to connect to a Access Db using only the filesystem like $connect = odbc_connect("\Db\Webdb.mdb", "nobody", "nobody"); thus pointing directly to the file not using drivers??? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php