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

[Nicolas Steichen]

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>