[Qt-interest] QTDS SQL Driver no longer functions correctly under Qt 4.6.0

[Mark Brand]

>>> I have downloaded and installed v4.6 of the LGPL Libraries for Windows 
>>> (VS 2008) along with the Visual Studio Add-in v1.1.2. (on Vista x64)
>>>
>>> Since I use a (remote) SQL Server Database I built the QTDS Driver using 
>>> the Intel v11.1.054 Compiler, and I can successfully build and run the 
>>> Qt project using the Intel Compiler.
>>>
>>> On start up the application opens a connection to the SQL Database 
>>> however whenever I try to execute a query against it I get:
>>>
>>> QTDS: Attempt to initiate a new SQL Server operation with results pending.
>>>
>>> How this can be I do not know as the code worked (unchanged) under v5.4 
>>> so this leads me to suspect the 4.6 QTDS code. I've been scratching my 
>>> head over this one for hours and I can see nothing wrong with my code.
>>>
>>> Even if I stop the application from opening the database at start up and 
>>> opening just prior to executing a QSqlQuery I still get the same error!
>>>
>>> Is anyone aware of this 'issue' as I'm at a total loss.
>>>
>>>   
>>>       
>> QTDS is going to be deprecated and unsupported, please consider moving 
>> over to ODBC.
>> Personally, I'm not getting those errors on my test machines when 
>> running the autotest system, and very little has been done to the tds 
>> driver lately, so I'm not sure what could be causing this.
>>
>>     
> Thanks for the 'heads-up' on that and by coincidence I had moved to ODBC 
> to allow me to continue my development, which vindicated my original 
> post in that everything worked as expected, with only a couple of line 
> changes. Weird.
>
>   

Hi,

For what it's worth, the Qt build that comes with mingw-cross-env has a
working QTDS driver, although it has not had a lot of testing. It's
based on FreeTDS.

http://www.nongnu.org/mingw-cross-env/

-Mark