[freetds] Multiple result sets?

Bernt Andreas Drange Bernt.Andreas.Drange at imr.no
Wed Sep 10 10:23:13 EDT 2003


I have a problem in a php script, I am trying to work with two result
sets on the same database connection. 

What happens when I try to execute the second query, is that I get an
error message: 

DB Error: unknown error <br> select distinct status as xxid,status as
xxname from fasilitetsbehov [nativecode=00000 ]

(It is PEAR DB that generates the "unknown error" message. 

A search on google revealed that nativecode=000000 is actually a success
message, as you all probably know. This confuses me. 

I wonder, is this a FreeTDS problem? Or is it unixODBC, Pear DB or PHP
that is the cause? 

Hope some of you guys have a tip on how to resolve this problem, as it
causes a great deal of pain for me.. 

I'm running RedHat 9 with PHP 4.3, unixODBC and all installed from RPMs,
and FreeTDS 0.60. 


Regards, 
Bernt




More information about the FreeTDS mailing list