ID: 7653 Updated by: kalowsky Reported By: [EMAIL PROTECTED] Status: Open Bug Type: ODBC related Assigned To: Comments: Please try the latest PHP build as both of these issues have been (I believe) delt with in it. Previous Comments: --------------------------------------------------------------------------- [2000-11-05 21:50:19] [EMAIL PROTECTED] Hi, I tried to install php-4.0.3pl1 with openlink and pdflib support. It seems that it can connect to the server but can't query it. Before the compilation, I modified something in php_odbc.c. I changed SQLINTEGER len; to SDWORD len; to successfully compile and install it. The pdflib on the other hand is working well. ############OUTPUT############# connected to DSN: DSN=NIP Warning: SQL error: [OpenLink][ODBC][Driver]General error, SQL state S1000 in SQLExecDirect in /usr/local/apache/htdocs/openlink.php on line 16 can not execute 'SELECT * FROM NIP.toa.NIP113' closing connection Resource id #1 ##########SCRIPT############ <html> <head><title>Sample Output</title></head> <body> <? putenv("LD_LIBRARY_PATH=/usr/local/openlink/odbcsdk/lib"); putenv("ODBCINSTINI=/usr/local/openlink/bin/odbcinst.ini"); putenv("ODBCINI=/usr/local/openlink/bin/odbc.ini"); $dsn="DSN=NIP"; $user="toa"; $password=""; $sql="SELECT * FROM NIP.toa.NIP113"; // directly execute mode if ($conn_id=odbc_connect("$dsn","","")){ echo "connected to DSN: $dsn<br>"; if($result=odbc_do($conn_id, $sql)) { echo "executing '$sql'<br>"; echo "Results: <br>"; odbc_result_all($result,"border=1"); } ?> </body> </html> ############CONFIGURE############# ./configure --with-apxs=/usr/sbin/apxs --with-gd --with-pdflib=/usr/local --with-config-file-path=/usr/local/apache --with-zlib-dir=/usr --with-ttf=/usr/local/include --with-jpeg-dir=/usr --with-tiff-dir=/usr --with-system-regex=yes --enable-debug=no --enable-track-vars --with-openlink=/usr/local/openlink #############php.ini############## I just copied the php.ini-dist and never touched it. --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=7653 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]