freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: Conley Bone <cbone AT newroadstelecom.com>
- To: freetds AT lists.ibiblio.org
- Subject: [freetds] Multiple queries
- Date: Thu, 05 Oct 2006 11:22:54 -0500
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
-
[freetds] Multiple queries,
Conley Bone, 10/05/2006
-
Re: [freetds] Multiple queries,
Daniel Kasak, 10/10/2006
-
Re: [freetds] Multiple queries,
Conley Bone, 10/10/2006
-
Re: [freetds] Multiple queries,
Daniel Kasak, 10/10/2006
- Re: [freetds] Multiple queries, Conley Bone, 10/11/2006
-
Re: [freetds] Multiple queries,
Daniel Kasak, 10/10/2006
-
Re: [freetds] Multiple queries,
Conley Bone, 10/10/2006
-
Re: [freetds] Multiple queries,
Daniel Kasak, 10/10/2006
Archive powered by MHonArc 2.6.24.