Troubles with TMSQuery when blocking is not setted

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 52
Joined: Mon 24 Mar 2008 13:22

Troubles with TMSQuery when blocking is not setted

Post by Alexander_73 » Mon 25 Aug 2008 12:25

MS SQL Server 2005.
If property TMSQuery.Options.NonBlocking=true, table reopening or scrolling causes random different errors, beginning from "... must release handles of lines" to "Access violation in module sqloledb.dl...".
Step-by-step trace of an error code do not appear, only when a program works. Setting NonBlocking=false removes all exceptions. Whats is this?

Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Wed 27 Aug 2008 12:07

I could not reproduce the problem.
Please send me a complete small sample at dmitryg*devart*com to demonstrate it, including script to create and fill table.

Also supply me the following information:
- the exact version of SDAC. You can see it in the About sheet of TMSConnection Editor;
- the exact version of your IDE.

Post Reply