The query handle is not valid

[Carol_P_(Guest)]

Hello,____Sometimes when running a report from the OCX our users see the following error when connecting to SQL Server (but never when connecting to Access). The error seems to affect single PCs on a network and to disappear after a while (usually weeks)____"DB Access: The connection, statement, or query handle you provided is not valid"____It seems to happen more frequently for reports with complex SQL statements.____I was advised to add this to RSW.INI file __[DATABASE] __USEQECONNECT=1____But that does not help____Thanks__Carol

[kfleming]

I too have seen this from time to time. Somewhere the ODBC connection must be experiencing some kind of hiccup in a pointer that causes it to become confused. Unfortunately I do not know of any setting in R&R or in the ODBC data source configuration to change that would impact this problem.____Kathleen__R&R Support

[Carol_P_(Guest)]

Hello,____I am getting complaints from clients re this message which seems to be becoming more frequent. Is there nothing that can be done about it? Will it be addressed in a future release? ____Regards__Carol

[Anne_Phillips]

We have another client with this problem on a new Vista machine with some but not all of our reports. ____(NB We have other clients on Vista who don^t have this problem using the same set of reports)____Are you looking into these problems and when will you have an answer as it^s getting very urgent now.

[Carol_P_(Guest)]

Hello,____Is there any news on a possible fix for this error?____Thanks__Carol

[kfleming]

We are working on an update release that should be available some time in June.______Kathleen__R&R Support

[Carol_P_(Guest)]

Hello,____any news on the release date for the new version?____Regards__Carol

[kfleming]

It is still in the works. No announced release date as of now.____Kathleen__R&R Support

[Lynn_Coggshall_(Guest)]

Hi Kathleen,__Any news on this issue. I^m having this problem at a new install, but none of my machines are working. I^ll try some of the suggestions I^ve read here, but would like to know if the patch is out yet.____Thanks,__Lynn

[kfleming]

Lynn-____Send me an email and I can give you a preview copy of the most recent builds.____Kathleen__R&R Support__livesupport@livewarepub.com