#9044 [Fbk]: Compiling with latest Openlink ODBC fails with PHP4

ID: 9044 Updated by: ahill@php.net Reported By: antiphobo@paradise.net.nz Status: Feedback Bug Type: Compile Failure Operating System: Redhat Linux (Cobalt RAQ2) PHP Version: All PHP4 (402, 404sp1 atleast) New Comment: Yes, OpenLink drivers are glibc sensitive - ensure you are using the correct version please. I've had no problems doing several builds of iODBC with PHP4, including the latest 4.2.3. Previous Comments: ------------------------------------------------------------------------ [2002-10-16 12:06:10] kalowsky@php.net You need to give more detailed information on what exactly the errors are. OpenLink works just fine on the three test platforms I'm using, and has worked fine since 4.1 release. You should really though being using the --with-iodbc flag, as --with-openlink is deprecated. ------------------------------------------------------------------------ [2002-10-16 10:26:36] adg@designers.cl sorry i'm late... (1 year) ... I think teh problem could be the glibc version... I have installed php4.2.2(also 4.2.1 and 4.2.3) + apache(1.3.27 and the now httpd release at this time 2.0.43) in the Red Hat 7.3 version, and everithing works fine (except for a problem in the Openlink lite version driver for SQL-Server whe you make a odbc_exec() call), but when i've tryed to install the same configuration in the redhat 7.2 throws the same make-error taht you comment... try to update to rh 7.3 (maybe 8.0), or update glibc or the lib used to compile... Sorry if i'm wrong... Regards Adriano ------------------------------------------------------------------------ [2001-02-06 21:52:36] antiphobo@paradise.net.nz Copied contents of /ext/odbc/ of PHP404sp1 and tried compiling this with PHP403sp1 ... Compile fine; but Driver Not Capable error continues. ------------------------------------------------------------------------ [2001-02-03 14:49:56] antiphobo@paradise.net.nz Allegedly PHP404sp1 fixes this Openlink problem ... but see bug id http://bugs.php.net/?id=9088&edit=1 for why i couldnt get PHP404sp1 to work with apache :( ------------------------------------------------------------------------ [2001-02-01 17:44:06] antiphobo@paradise.net.nz Compiling Openlink4 with PHP 403sp1 and Apache 1.3.12 using the custom iodbc.h file I have included WORKS "FINE": as in - it compiles without errors - has warning: `SQL_LEN_DATA_AT_EXEC' redefined - produces a fully PHP-functional apache webserver I still cannot manage to properly communicate to talbles using Openlink4, however, I recieve: SQL error: [OpenLink][ODBC][Driver]Syntax error or access, SQL state 37000 in SQLExecDirect for complex selects such as "SELECT TOP 10 RECORD_NR, StatusField, ExtendedStatusField, PICTURE, SURNAME, FIRSTNAME, FORM, DOB, DESTINATION, EXPIRY FROM (SELECT TOP 10 * FROM WELLGIRLS ORDER BY RECORD_NR ASC,RECORD_NR ASC) ORDER BY RECORD_NR DESC,RECORD_NR DESC" and for simple selects "SELECT * FROM TABLENAME", i get Warning: SQL error: [OpenLink][ODBC][Driver]Driver not capable, SQL state S1C00 in SQLExecDirect in /home/sites/home/web/current/Admin/admin_odbcsetup.php on line 125 The battle continues ... - Siggy ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/9044 -- Edit this bug report at http://bugs.php.net/?id=9044&edit=1