PHP 4.0 Bug #7653 Updated: openlink - query error
| From: | kalowsky@php.net | Date: | Wed, 17 Jan 2001 14:39:26 +0000 |
| Subject: | PHP 4.0 Bug #7653 Updated: openlink - query error | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-44372@lists.php.net to get a copy of this message | ||
ID: 7653
Updated by: kalowsky
Reported By: breughel@nekonet.co.jp
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] breughel@nekonet.co.jp
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