[Qt-interest] Using MARS from ODBC driver with QtSql

[Nicolas Steichen]

Ok, my mistake... the database was under SQL Server 2000...
Now it has been moved to SQL Server 2005 it works perfectly.

Nicolas Steichen a écrit :
> Hi all,
>
> I use QtSql module to connect to an SQL Server 2005 database with the 
> QODBC plugin.
>
> Is there any reason why I could not be able to use MARS (Multiple Active 
> Result Set) introduced by SQL Server 2005 to maintain and manipulate 
> multiple active statements (i.e. QSqlQuery objects) on a connection ?
>
> When executing the second query on the same connection I get the ODBC 
> error "[SQL Native Client]Connection is busy with results for another 
> command". I followed the Microsoft instructions provided here 
> (http://msdn.microsoft.com/en-us/library/ms131686.aspx) for the 
> connection string, but I still get the error.
>
> Any idea ?
>
> Thanks,
> Nicolas
>
> <http://msdn.microsoft.com/en-us/library/ms131686.aspx>
> _______________________________________________
> Qt-interest mailing list
> Qt-interest at trolltech.com
> http://lists.trolltech.com/mailman/listinfo/qt-interest
>
>
>