Openlink -> Ms Access Helpful Hint! ( Use SQL_CUR_USE_ODBC )
| From: | Sigurd Magnusson | Date: | Thu, 02 Nov 2000 10:44:24 +0000 |
| Subject: | Openlink -> Ms Access Helpful Hint! ( Use SQL_CUR_USE_ODBC ) | ||
| Groups: | php.db php.windows | ||
| Request: | Send a blank email to php-db+get-4126@lists.php.net to get a copy of this message | ||
Just a helpful hint - I've noticed people wondering about this !
If you are using Openlink to connect to a
Microsoft Access Database and you receieve the error
"Warning: SQL error: [OpenLink][ODBC][Driver]Driver not capable, SQL state
S1C00 in SQLExecDirect"
or
"Warning: No tuples available at this result index in blah.php on line
123456789"
Then use specify a cursor when you connect, as shown below:
$conn_id=odbc_connect("$dsn","","", SQL_CUR_USE_ODBC );
All will work smoothly now :)
Siggy