SQL Server: Crash after hibernation

kalvaro's profile image kalvaro posted 11 years ago in General Permalink
If I hibernate my computer while HeidiSQL is open against SQL Server, I normally get this exception report on startup:

date/time         : 2013-05-29, 09:01:03, 672ms
operating system  : Windows 7 x64 Service Pack 1 build 7601
system language   : Spanish
system up time    : 8 days 23 hours
program up time   : 23 hours 57 minutes
processors        : 2x AMD Athlon(tm) 64 X2 Dual Core Processor 4000+
physical memory   : 1801/4096 MB (free/total)
free disk space   : (C:) 75,88 GB (D:) 85,03 GB
display mode      : 1280x1024, 32 bit
process id        : $a80
allocated memory  : 60,71 MB
executable        : heidisql.exe
exec. date/time   : 2013-05-27 09:52
version           : 8.0.0.4401
compiled with     : Delphi XE
madExcept version : 3.0m beta 1
callstack crc     : $46fc53bf, $28f953a1, $28f953a1
exception number  : 1
exception class   : EOleException
exception message : La operación no está permitida si el objeto está cerrado.
main thread ($688):
00709528 heidisql.exe ADODB                 TCustomADODataSet.GetRecordCount
0072f00d heidisql.exe dbconnection 3998 +27 TAdoDBQuery.SetRecNo
007fee21 heidisql.exe Main         8231  +5 TMainForm.AnyGridBeforeCellPaint
00621c01 heidisql.exe VirtualTrees          TBaseVirtualTree.DoBeforeCellPaint
006298a5 heidisql.exe VirtualTrees          TBaseVirtualTree.PrepareCell
00631666 heidisql.exe VirtualTrees          TBaseVirtualTree.PaintTree
00628803 heidisql.exe VirtualTrees          TBaseVirtualTree.Paint
004f34bf heidisql.exe Controls              TCustomControl.PaintWindow
004edc19 heidisql.exe Controls              TWinControl.PaintHandler
004ee3f8 heidisql.exe Controls              TWinControl.WMPaint
004f3459 heidisql.exe Controls              TCustomControl.WMPaint
0061f425 heidisql.exe VirtualTrees          TBaseVirtualTree.WMPaint
004e919c heidisql.exe Controls              TControl.WndProc
004eda60 heidisql.exe Controls              TWinControl.WndProc
0062b554 heidisql.exe VirtualTrees          TBaseVirtualTree.WndProc
004ed100 heidisql.exe Controls              TWinControl.MainWndProc
004ab958 heidisql.exe Classes               StdWndProc
776a0107 ntdll.dll                          KiUserCallbackDispatcher
76867885 USER32.dll                         DispatchMessageW
00575ffb heidisql.exe Forms                 TApplication.ProcessMessage
0057603e heidisql.exe Forms                 TApplication.HandleMessage
00576369 heidisql.exe Forms                 TApplication.Run
00819be2 heidisql.exe heidisql       74 +22 initialization
76c133a8 kernel32.dll                       BaseThreadInitThunk
ansgar's profile image ansgar posted 11 years ago Permalink
I guess "La operación no está permitida si el objeto está cerrado." means something like "Operation not allowed on a closed object". Yes, I can confirm that. Means, you had some result grid, or the data tab left opened, and HeidiSQL now tries to get text values from the fields in it. In MySQL this is not a problem obviously, only in MSSQL mode, speak: OleDB provider does not allow to work on a dataset which is bound to a closed server connection. I guess I need to auto-remove such result grids when the connection has (implicitly) been closed.
kalvaro's profile image kalvaro posted 11 years ago Permalink
Yeah, sorry, I forgot to translate the message. That's the exact meaning.

So, due to OleDB limitations, it's necessary to discard or refetch data grids?
ansgar's profile image ansgar posted 11 years ago Permalink
Yes, that's it, basically.

Please login to leave a reply, or register at first.