note 9415 added to odbc_connect
| From: | phobo_AT_paradise dot net dot nz at php2 dot chek dot com | Date: | Thu, 02 Nov 2000 11:01:05 +0000 |
| Subject: | note 9415 added to odbc_connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-7288@lists.php.net to get a copy of this message | ||
If using Openlink to connect to a Microsoft Access database, you will most likely fine tha
odbd_connect() works fine, but discover that ANY query will produce odd results; with SELECT queries
failing with "[OpenLink][ODBC][Driver]Driver not capable, SQL state
S1C00 in SQLExecDirect in xxxx.php on line xx" and INSERT / DELETE queries warning "No
tuples available at this result index".
In this case, use the SQL_CUR_USE_ODBC cursor!
This had me stumped for quite some time; because it was the odbc_exec() which was seemingly at
fault... :)
Siggy
http://www.php.net/manual/function.odbc-connect.php