[PHP-DEV] PHP 4.0 Bug #10181 Updated: odbc_result causes Unexpected network read error
ID: 10181
User Update by: [EMAIL PROTECTED]
Old-Status: Feedback
Status: Open
Bug Type: ODBC related
Description: odbc_result causes Unexpected network read error
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
Previous Comments:
---
[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
TITLEQuery 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 PQuery is $sql/Pn;
if ($conn_id = odbc_connect($dsn,,)) {
echo PDatabase connection succeeded/Pn;
if ($result = odbc_do($conn_id, $sql)) {
echo PQuery succesfully submitted/Pn;
/*
odbc_result_all($result);
*/
while (odbc_fetch_row($result)) {
$comp = odbc_result($result, 1);
echo P$comp/Pn;
}
odbc_free_result($result);
} else {
echo PProblem submitting query/Pn;
}
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]
[PHP-DEV] PHP 4.0 Bug #10181 Updated: odbc_result causes Unexpected network read error
ID: 10181
Updated by: kalowsky
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Feedback
Bug Type: ODBC related
Assigned To:
Comments:
is this the latest version of OpenLink?
Previous Comments:
---
[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
TITLEQuery 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 "PQuery is $sql/Pn";
if ($conn_id = odbc_connect("$dsn","","")) {
echo "PDatabase connection succeeded/Pn";
if ($result = odbc_do($conn_id, "$sql")) {
echo "PQuery succesfully submitted/Pn";
/*
odbc_result_all($result);
*/
while (odbc_fetch_row($result)) {
$comp = odbc_result($result, 1);
echo "P$comp/Pn";
}
odbc_free_result($result);
} else {
echo "PProblem submitting query/Pn";
}
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]
---
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=10181edit=2
--
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]
