RE: [PHP-DB] How to access a MS Access DB
| From: | Beverly Steiner | 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