PHP 4.0 Bug #9065: Openlink4 connections worthless under Redhat

From: antiphobo@paradise.net.nz Operating system: Redhat Linux (MIPS) PHP version: 4.0.3pl1 PHP Bug Type: ODBC related Bug description: Openlink4 connections worthless under Redhat When I connect from Linux Redhat (COBALT RAQ2) PHP403sp1/Apache1.3.12 to a database on Win2000 using Openlink version *4*: (PHP './configure' '--with-openlink=/usr/local/openlink' '--with-mysql' '--with-apache=../apache_1.3.12' '--enable-track-vars' ) Openlink(Linux) -> AccessDB(Win2k): Connects to database, SQL queries fail with "Not Capable" error (see below). Retreiving list of tables fails with odbc_tables(); (complains that odbc_tables($con, "%"); doesn't have the correct number of parameters. Openlink(Linux) -> MyODBC(W2K) -> MySQL(W2K) Connects to database, SELECTs return columns, but not rows. Retriving list of tables "fails" (as can only see columns, such as TableName, TableType, but no data) -- When I connect from Win2000 PHP403sp1/IIS5 to database on Win2000 using Openlink: Openlink -> Access: Works okay, except cannot retrieve TYPE of field. (This is of little concern.). Openlink -> MyODBC -> MySQL: as above. When doing not using Openlink at all and connecting directly to Access all on the same W2k Machine, everything works perfectly. Errors Under Linux: SELECT * FROM TABLE produces: SQL error: [OpenLink][ODBC][Driver]Driver not capable, SQL state S1C00 in SQLExecDirect I am using odbc_connect() and odbc_exec(). (not prepare() ). Have tested differenet cursor types with odbc_connect; nothing helps. Using ODBCTEST (the testing utility with Openlink software), everything works fine - i have access to all tables, databases, can perform complex SELECT and other queries without any hassle. Thus, this is a problem not specific to Access, because I can connect to Access from Win2000 PHP/Openlink It is not really a problem with openlink, because ODBCTEST works fine. Thus it means it is to do with the Openlink and PHP403sp1 cooperating (on redhat). I tried compiling PHP404 with Openlink4, but it failed (possibly due to Apache1.3.17). -- Edit Bug report at: http://bugs.php.net/?id=9065&edit=1