[freetds] having more than one active SQL statement
Drange, Bernt Andreas
bernt.andreas.drange at imr.no
Tue May 25 05:20:16 EDT 2004
On Fri, 2004-05-21 at 20:14, Lowden, James K wrote:
> http://www.freetds.org/faq.html#pending
>
> Now that the ODBC driver is pretty functional, it's gaining adherents who haven't used a TDS server before. Your question used to come up about once a year, but now it seems like it's more like once a month, so I added it to the FAQ. If that doesn't answer your question, please say so.
>
If you use PHP, you will still run into this problem even if you create
a new connection. The reason is that PHP is so nice that it will re-use
the first connection if you connect again with the same parameters.
I found a post from Daniel Fazekas in the archives that saved my day:
http://lists.ibiblio.org/pipermail/freetds/2003q3/013915.html
Here he gives two options on how to get around this. I would suggest
that you put a warning into the FAQ about this connection caching, it
may be a problem in more languages than PHP!
> Regards,
>
> --jkl
>
Cheers,
Bernt!
--
Drange, Bernt Andreas <bernt.andreas.drange at imr.no>
Havforskningsinstituttet/Institute of Marine Research
More information about the FreeTDS
mailing list