monheim Posted May 24, 2017 Share Posted May 24, 2017 Hi everyone. Dear friends, I use Database MS SQL Server and ADOConnection/ADOQuery in my project. According manual and recomendations I create ADOConnection on MainModule (so one connection for each session) and use it in frames and forms and also in main form. Main form contains two UniDbGrids and after session started all works fine. But after I click some records, positioning on Grids my session freezes... Or became work very slow and freezes... Freezes only current session, after refreshing all works but repeat the same behavior after performing same actions. I found some errors in Connection log I think raise such behavior... Failed Sequence Recovery: SeqId: 206, Event: select Sequence Error Timeout : TDiff:10015, Event: select, Expected: 205, Received: 208 Searching the forum I found similar messages from others but couldn't found decision for me. I verified database connection and queries, it's works properly. I suppose the reason is in UniDbGrid. It displays data from ADOQuery (ADOQuery - DataSource - UniDbGrid). I think may be it provokes hanging database connection. It fetching records and connection is already open dusing session. In RAD Studio event log I see many threads created during this hanging. Screen is masked in this time. Tested on Trial 1.0.0.1384 RC and ask to test on Complete Professional 1.0.0.1384 RC, result is the same... Great Thanks You for attention! Link to comment Share on other sites More sharing options...
monheim Posted May 24, 2017 Author Share Posted May 24, 2017 Also test with local ClientDataSet now. Without connection to any Database and have the same result. The reason is in UniDbGrid... Need your help, strongly need to fix this, thanks! Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted May 24, 2017 Administrators Share Posted May 24, 2017 Probably you are using a cracked edition downloaded from a 3rd party site. Please try again with latest trial build available in unigui.com. Link to comment Share on other sites More sharing options...
monheim Posted May 24, 2017 Author Share Posted May 24, 2017 Thank You, all works fine with latest trial version. My previous installed version was from unofficial site for Delphi... Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now