distal-attribute
distal-attribute
distal-attribute
distal-attribute

SQL Server: Crash after hibernation

kalvaro posted 1 year ago in General
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 posted 1 year ago
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 posted 1 year ago
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 posted 1 year ago
Yes, that's it, basically.

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