RE: [PHP-DB] How to access a MS Access DB

From: Date: Mon, 03 Mar 2003 21:11:12 +0000
Subject: RE: [PHP-DB] How to access a MS Access DB
Groups: php.db 
Request: Send a blank email to php-db+get-26069@lists.php.net to get a copy of this message
Hello, I'm new to this list and saw a past discussion in mid-Feb. about how to access an MS Access DB. I have Apache and PHP installed on my PC running XP Professional. I created a system DSN and got past the odbc_connect but it died in the odbc_prepare statement. Error message: Warning: odbc_prepare(): supplied argument is not a valid ODBC-Link resource in c:\perl\htdocs\test2.php on line 20 cannot prepare result Here's my code (w/username and password changed): $connection = odbc_connect("mctadb", "username", "password") || die("cannot open database"); $sql = "SELECT MeeetingTitle, MeetingDate FROM meeting;"; $sql_result = odbc_prepare($connection, $sql) || die("cannot prepare result"); Any help would be greatly appreciated, Beverly Steiner steiner277@charter.net

« previous php.db (#26069) next »