ID: 10181
User Update by: [EMAIL PROTECTED]
Status: Open
Bug Type: ODBC related
Description: odbc_result causes Unexpected network read error
Sorry about the incorrect library names. The details are:
the openlink odbc driver is oplodbc.so.1.0.0
the iodbc driver manager is libiodbc.so.2.0.12 as packaged with the openlink odbc sdk.
This morning I got the newest version 3.0.4 working of libiodbc. The driver is still
the same oplodbc.so.1.0.0 and libiodbc now has version libiodbc.so.2.1.3.
I still have the same problem!!
NB
It took me a while to figure out the odbc_connect has changed: Before I had to use:
$dsn = "DSN=qaddb";
if ($conn_id = odbc_connect("$dsn","","")) {
...
Now this has to be:
$dsn = "qaddb";
if ($conn_id = odbc_connect("$dsn","","")) {
...
Previous Comments:
---------------------------------------------------------------------------
[2001-05-01 14:50:13] [EMAIL PROTECTED]
This is with the odbclib 1.0.0 from the ODBC SDK and libiodbc 2.0.12 which is included
with it. I am trying to get the libiodc 2.1.3 working but did not succeed yet.
Frans
---------------------------------------------------------------------------
[2001-04-09 10:25:00] [EMAIL PROTECTED]
is this the latest version of OpenLink?
---------------------------------------------------------------------------
[2001-04-05 06:37:50] [EMAIL PROTECTED]
Configuration bulld with
'./configure' '--with-openlink=/opt' '--sysconfdir=/etc'
'--with-apxs=/var/lib/apache/sbin/apxs'
Problem also occures when using --with-iodbc
The database I connect to is a Progress 7.3E15 database. Using the odbctest program
all works fine: i.e. it does not seem to be a problem with the openlink or iodbc code.
This is the code that results in the error
<HTML>
<HEAD>
<TITLE>Query ps_mstr</TITLE>
</HEAD>
<BODY>
<?php
$part = '9450001';
putenv("LD_LIBRARY_PATH=/opt/odbcsdk/lib");
putenv("ODBCINI=/etc/odbc.ini");
$dsn = "DSN=qaddb";
$sql = "select ps_comp from ps_mstr where ps_par = '$part'";
echo "<P>Query is $sql</P>n";
if ($conn_id = odbc_connect("$dsn","","")) {
echo "<P>Database connection succeeded</P>n";
if ($result = odbc_do($conn_id, "$sql")) {
echo "<P>Query succesfully submitted</P>n";
/*
odbc_result_all($result);
*/
while (odbc_fetch_row($result)) {
$comp = odbc_result($result, 1);
echo "<P>$comp</P>n";
}
odbc_free_result($result);
} else {
echo "<P>Problem submitting query</P>n";
}
odbc_close($conn_id);
} else {
}
?>
Using lynx as a browser, I get the following errors:
Alert!: Unexpected network read error; connection aborted.
The code works fine if I give $part the value "STRATOS". It seems that the code breaks
when the query looks for records with key values that start with a number _and_ when
more than one row is being returned.
odbc_result_all also gives strange. The output with odbc_result_all and $part =
9450001 looks like:
ps_comp
Openlink_DSN=qaddb___2
Openlink_DSN=qaddb___2
Openlink_DSN=qaddb___2
Openlink_DSN=qaddb___2
Openlink_DSN=qaddb___2
The php.ini file is the same as php.ini-dist expect for output buffering being
enabled.
Hope this helps
TIA
Frans Schneider
work: [EMAIL PROTECTED]
home: [EMAIL PROTECTED]
---------------------------------------------------------------------------
Full Bug description available at: http://bugs.php.net/?id=10181
--
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]