[freetds] Multiple queries

Conley Bone cbone at newroadstelecom.com
Thu Oct 5 12:22:54 EDT 2006


I am using freetds 0.63 to access an MSSQL 2000 DB from a Perl script 
running on Linux.
I have been using Freetds in this scenario for several years with no 
problems until we upgraded the DB from 97 to 2000.
I have a bunch of scripts that have multiple queries.  My normal 
procedure is to open the connection, prepare the queries, execute them, 
then loop through the results as I need them.
This worked fine with SQL97, but doesn't work in SQL2000.  Only the 
first query is prepared, and I get an error on any subsequent query 
preparations unless I finish the first one before I prepare the next one.
Any ideas?

-- 

Conley Bone
Newroads Telecom
300 Towson Ave.
Fort Smith, AR  72901
479-494-0300 ext. 229
http://www.newroadstelecom.com



More information about the FreeTDS mailing list