From: [EMAIL PROTECTED]
Operating system: win 2000
PHP version: 4.2.0
PHP Bug Type: ODBC related
Bug description: Multiple odbc connections failing
I would like to apologize, for I have uninstalled 4.2 from my server and
went back to 4.1, and now I do not have the complete error messages.
Server: Windows 2000 IIS
SQL server 2k
PHP ver 4.2
odbc
Problem: Old scripts that ran fine on version 4.1.2 now give error
messages stating that the odbc connection is in use "SQLstate S1000
waiting for result from previous hstmnt"
We have scoured the INI, tried the old ini as well. same results. I put
4.1.2 back on, issue is gone.
I am running into this issue when looping through the Db and running a
subloop inside based off results from the first loop. I do this with
functions inside a loop as well as actually running a new while loop
inside of the first one. I have tried altering my code, making sure i have
closed all db connections (which i never do) and free allodbc results from
memory.
sample codes:
here are the defined functions:
function countapproved ($project_id){
$time = date ("H:i");
$date = date("m/d/y");
$cto_f = odbc_connect("emp1","","")
or die("Error Connecting To CDBMS.");
$cnt_rec = ("select count (*) from [cto_main] where emp_pro
='$project_id' and date = '$date' and pref_time < '$time' and
cto_status_id <> '2' and cto_status_id <> '3' and (shift_time >
'$time')");
$ex_cr = odbc_exec($cto_f,$cnt_rec);
$count = odbc_result($ex_cr, 1);
return $count;
}
function countgranted ($project_id){
$time = date ("H:i");
$date = date("m/d/y");
$cto_f = odbc_connect("emp1","","")
or die("Error Connecting To CDBMS.");
$cnt_rec = ("select count (*) from [cto_main] where emp_pro
='$project_id' and date = '$date' and cto_status_id = '2'");
$ex_cr = odbc_exec($cto_f,$cnt_rec);
$count = odbc_result($ex_cr, 1);
return $count;
}
function countsignedout ($project_id){
$time = date ("H:i");
$date = date("m/d/y");
$cto_f = odbc_connect("emp1","","")
or die("Error Connecting To CDBMS.");
$cnt_rec = ("select count (*) from [cto_main] where (emp_pro
='$project_id') and (date = '$date') and cto_status_id = '3'");
$ex_cr = odbc_exec($cto_f,$cnt_rec);
$count = odbc_result($ex_cr, 1);
return $count;
}
function countpending ($project_id){
$time = date ("H:i");
$date = date("m/d/y");
$cto_f = odbc_connect("emp1","","")
or die("Error Connecting To CDBMS.");
$cnt_rec = ("select count (*) from [cto_main] where emp_pro
='$project_id' and date = '$date' and pref_time > '$time' and
cto_status_id <> '2' and cto_status_id <> '3' and (shift_time >
'$time')");
$ex_cr = odbc_exec($cto_f,$cnt_rec);
$count = odbc_result($ex_cr, 1);
return $count;
}
running inside this loop:
$get_cto_pro= ("SELECT *, project.project_name FROM cto_project INNER
JOIN project ON cto_project.cto_project_id = project.project_id order by
project_name");
$ex_cp = odbc_exec($cto,$get_cto_pro);
$row = 0;
while( odbc_fetch_row( $ex_cp ) ) {
$row++;
$p_name= odbc_result( $ex_cp,
'project_name' );
$project_id= odbc_result( $ex_cp,
'cto_project_id' );
$total_appr = countapproved
($project_id);
$total_granted = countgranted
($project_id);
$total_s_o = countsignedout
($project_id);
$total_pend = countpending
($project_id);
$total = $total_appr + $total_granted
+ $total_s_o + $total_pend;
print ("<tr><td><a
href=\"queue.php?p_name=$p_name&project_id=$project_id\">$p_name</td><td
bgcolor=ffffff><center>$total</center></td><td
bgcolor=ffffff><center>$total_appr</center></td><td
bgcolor=ffffff><center>$total_pend</center></td><td
bgcolor=ffffff><center>$total_granted</center></td><td
bgcolor=ffffff><center>$total_s_o</center></td></tr>");
I may just be doing something wrong, but I have had very good performance
untill now. Any feedback would be appreciative.
Thanks.
Jarod Ferguson
--
Edit bug report at http://bugs.php.net/?id=16777&edit=1
--
Fixed in CVS: http://bugs.php.net/fix.php?id=16777&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=16777&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=16777&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=16777&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=16777&r=support
Expected behavior: http://bugs.php.net/fix.php?id=16777&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=16777&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=16777&r=submittedtwice
