[freetds] having more than one active SQL statement

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Fri May 21 11:45:53 EDT 2004


> 
> 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.  Is this a farce?  Is there something going 
> on in ADO that I am unaware of?
> 
> 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?
> 

Hi Kevin,

TDS protocol do not support two active recordset. There are only two
workaround:
- server side cursors, still not supported by FreeTDS
- use multiple connections

Code should an error...

freddy77



More information about the FreeTDS mailing list