I'm having some difficulties with openlink driver to MS Access database(97). Anyone have some fresh ideas what should I do.
PHP generates error: Warning: SQL error: [OpenLink][ODBC][Driver]Driver not capable, SQL state S1C00 in SQLExecDirect in test.php on line 23
Database: is located at NT server server.
Openlink client: is at Linux machine.
PHP version: 4.3.2
I'm using Openlink's Multi-Tier Universal Data Access Driver ver.5.0
When I'm testing the connection with Openlinks's simple ISQL tool, I get the result by query, but with PHP it fails. Using SQL_CURSOR doesn't help at all.
here is some of the simple test file:
putenv("LD_LIBRARY_PATH=/usr/local/palvelin/openlink/client/lib/");
putenv("ODBCINSTINI=/usr/local/palvelin/openlink/client/bin/odbcinst.ini");
putenv("ODBCINI=/usr/local/palvelin/openlink/client/bin/odbc.ini");
$dsn="hiekka2";
$user="";
$password="";
$sql="SELECT id FROM Taineet";
if ($conn_id=odbc_connect("$dsn","","",SQL_CUR_USE_ODBC)){
echo "connected to DSN: $dsn";
if($result=odbc_do($conn_id, sql))
.
.
.
