note 61859 deleted from function.odbc-connect by betz
| From: | betz@php.net | Date: | Tue, 14 Feb 2006 02:42:28 +0000 |
| Subject: | note 61859 deleted from function.odbc-connect by betz | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-103659@lists.php.net to get a copy of this message | ||
Note Submitter: ladams02 at frostburg dot edu
----
What would be the correct syntax if I'm trying to access a DB that is in the same directory as
my PHP script?
The Following:
$connection = odbc_connect("DRIVER={Microsoft Access Driver (*.mdb)};
DBQ='E:\users\ladams02\courses\cosc345\tts\data.mdb'", "USER",
"PASS");
$sql = "select * from pokerTTS";
$res = odbc_exec($connection, $sql);
Returns:
Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Microsoft Access
Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process
0x834 Thread 0x854 DBC 0xc529e4 Jet'., SQL state S1000 in SQLConnect in
e:\users\ladams02\courses\cosc345\tts\ttsOutput.php on line 194
... among several other errors. Any ideas??