Skip to Content.
Sympa Menu

freetds - [freetds] Warning: odbc_fetch_row(): 6 is not a valid ODBC result resource in /var/www/localhost/htdocs/customer.microprecision.com/invlist.php on line 81

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Ran September <ran.september AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Warning: odbc_fetch_row(): 6 is not a valid ODBC result resource in /var/www/localhost/htdocs/customer.microprecision.com/invlist.php on line 81
  • Date: Mon, 23 Feb 2009 17:17:26 -0800

I'm not sure if my problem is still under in this mailing list well
sorry if it's not, but here goes...

i don't know where i went wrong, my script seems alright and i'm
pretty sure that i prevented the "Multiple active statement" thing (at
least that's what i believed)

$conn=odbc_connect($db_host,$db_user,$db_pass);
$sql="SELECT * FROM invoice where customer = '$custid' AND
INVOICE.WO_CUSTOM2 != 'MPTE'";
$rs=odbc_exec($conn,$sql);
if (!$rs)
{exit("Error in SQL");} (---------------------->>> the connection
worked! <<<---------------------------)
?>

odbc_binmode($rs, ODBC_BINMODE_PASSTHRU);
odbc_longreadlen($rs, 100384); /* Allow 16kb thru */
while (odbc_fetch_row($rs)) (--------------------->>> this
is where the error pointed at <<<------------------)
{
$bigger_than_4096_var = odbc_result($rs, 1);
unset ($certlink);
unset ($docstr);
$job_number=odbc_result($rs,"job_number");
$open_date=odbc_result($rs,"open_date");
$status=odbc_result($rs,"wo_custom6");
if($status == ''){
$status = "UNPAID";
}
$customer=odbc_result($rs,"customer");
$po_number=odbc_result($rs,"po_number");


and also, using freetds, can it load pdf files? if yes, is there a
limit from loading big files? because it worked on windows i mean when
the time that i didn't have to use freetds driver.

// Get most recent cert number.
odbc_close($conn);
$conn2=odbc_connect($db_host2,$db_user2,$db_pass2,SQL_CUR_USE_ODBC);
(----------->>> another server alias and a different user and password
<<<------------)
$sql2="select job_number from invoice_docs2 where job_number =
'$job_number'";
$rs2=odbc_exec($conn2,$sql2);
if (!$rs2){
exit("Error in SQL");
$pdf=odbc_result($rs2,"estimate_pdf");
}else{
$certlink = "<a href='inv.php?num=".$job_number."'
target='_blank'>$job_number</a>";
}$var = odbc_result($rs2,1);

//Find associated docs.
odbc_close($conn2);

$conn4=odbc_connect($db_host,$db_user,$db_pass,SQL_CUR_USE_ODBC);
//$sql4="SELECT file_name, event_num FROM eventdocs
where event_num
= '".odbc_result($rs2,1)."'";
$sql4="SELECT file_name, event_num FROM eventdocs
where event_num = '$var'";
$rs4=odbc_exec($conn4,$sql4);
$edocnum = odbc_result($rs4,"event_num");
$edocfile = odbc_result($rs4,"file_name");
if (stristr($edocfile,"mpc.microprecision"))
{$docstr = "<a href ='$edocfile' target=_blank><img
src='images/archived.gif' width='20' height='20' border='0'
align='absmiddle' /></a>";}
elseif ($edocnum != '')
{$docstr = "<a href='doc.php?num=$edocnum'
target=_blank><img
src='images/doc.gif' width='20' height='20' border='0'
align='absmiddle' /></a>";}

File loading damaged and couldn't load at all.

Thank you in advence! appreciate the help.
--
R




Archive powered by MHonArc 2.6.24.

Top of Page