FreeTDS Development Group

["ZIGLIO Frediano" <Frediano.Ziglio AT vodafone.com>]

> 
> please read this:
> 
> Hi there,
>               Unfortunately multiple active statements
> is an ODBC driver 
> facility and not under the control of unixODBC.
> UnixODBC will allow 
> multiple active connections only if the underlying
> ODBC driver supports 
> them. In the case of freetds I am not sure that SQL
> server itself allows 
> multiple active statement per connection. This is a
> question you would 
> have to ask the freetds team.
> 
> Regards
> 
> Jimmy Haddock
> Support Consultant
> Easysoft Ltd
> 

SQL Server do NOT allow multiple active statement per connection.
If you want to use multiple active statements using a single connection
you can simulate it using cursors; however cursors are not still
supported... Bill Thompson is working on them so I think cursors will be
the main new feature of 0.63 (yes, I know, we are still working on 0.62
:) )...

freddy77