From:             [EMAIL PROTECTED]
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:

PHP Development Mailing List <>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to