[freetds] having more than one active SQL statement
Lowden, James K
LowdenJK at bernstein.com
Fri May 21 14:14:16 EDT 2004
> From: freetds-bounces at lists.ibiblio.org
> [mailto:freetds-bounces at lists.ibiblio.org]On Behalf Of Kevin Hirst
> Sent: May 21, 2004 11:24 AM
> I have recently encountered a problem coding for unixODBC and
> FreeTDS that I can only seem to have one active statement at
> a time on a single connection. I am told this is a
> limitation on TDS, but I know that I have used ADO on Windows
> before and had many statements active on one connection to
> SQL Server 2000.
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.
> Is this a farce? Is there something going on in ADO that I am unaware of?
It would seem so. ADO is populating a container for you. You get the convenience of the container, at the price of waiting for the last row before you can use the first one.
> The basic problem is that SQLExecDirect() fails with error 0
> and no error message on the second SELECT statement that I
> execute on it. Do I need to open a new connection for every
> statement that I want to be active at once?
That's a problem. :-( Error message handling in the FreeTDS ODBC driver sometimes fails to convey server messages to the client. It's being worked on.
The information contained in this transmission may contain privileged and confidential information and is intended only for the use of the person(s) named above. If you are not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender immediately by reply e-mail and destroy all copies of the original message. Please note that we do not accept account orders and/or instructions by e-mail, and therefore will not be responsible for carrying out such orders and/or instructions.
If you, as the intended recipient of this message, the purpose of which is to inform and update our clients, prospects and consultants of developments relating to our services and products, would not like to receive further e-mail correspondence from the sender, please "reply" to the sender indicating your wishes. In the U.S.: 1345 Avenue of the Americas, New York, NY 10105.
More information about the FreeTDS