[freetds] Multiple queries
Conley Bone
cbone at newroadstelecom.com
Tue Oct 10 09:20:15 EDT 2006
Daniel Kasak wrote:
>Conley Bone wrote:
>
>
>
>>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?
>>
>>
>>
>
>This has been the biggest thawn in my paw with the FreeTDS driver since
>I started using it. I'm using SQL Server 7. What I do is do an explicit
>$sth->finish after *everything*. I also open many database connections -
>ie don't open 2 recordsets simultaneously from the 1 connection.
>Obviously this strategy doesn't scale up particularly well, but it's
>fine on our LAN.
>
>
>
Hmmm...
I didn't have a problem with 7. My problems started when I moved to 2000.
More information about the FreeTDS
mailing list