I had logged onto my SQL Server database, selected a table, then hit the "data" tab to se its contents when it just crashed. Attached is the dump.
Crash when trying to read a table on SQL Server
Same issue here. The table contains GUID columns. Tried to reduce the columns, rows, and result is below (bugreport, table CREATE and data (one row!) in attachments.
This bug has been nagging me since about 9.4. Right now I have to resort to SQL Server Management Studio which is quite a nuisance...
I'd really appreciate if you could look into this.
@tonymarston: please update to HeidiSQL 10.1, you are running an old version.
@nickles: your issue is different. Probably that's issue #496. You could have a look there and compare the reproduction recipe.
I am running version 10.1.0.5479 and still hitting the same error. See attached bug report.
The crash report looks like in issue #423. I just set that to the roadmap for the next release. You could star that issue and probably check when I committed a solution.
It has not gone for me. Here is some test data:
CREATE TABLE "party_identification" ( "party_id" DECIMAL(38,0) NOT NULL, "identity_type_id" NVARCHAR(16) NOT NULL, "id_value" NVARCHAR(32) NOT NULL, PRIMARY KEY ("party_id", "identity_type_id") ); INSERT INTO party_identification (party_id, identity_type_id, id_value) VALUES (10101000000000000000000000000030, 'ALTERNATIVE', 'foobar');
Ok, then issue #423 still seems not solved. Relevant part of your bugreport is as follows:
exception class : EOleException exception message : Multiple-step operation generated errors. Check each status value. main thread ($4b04): 00aa4222 heidisql.exe Data.Win.ADODB TCustomADODataSet.GetFieldData 00a52da0 heidisql.exe Data.DB TField.GetData 00a5de32 heidisql.exe Data.DB TFMTBCDField.GetValue 00a5db80 heidisql.exe Data.DB TFMTBCDField.GetAsString 00a52879 heidisql.exe Data.DB TField.GetAsAnsiString 00b0119d heidisql.exe dbconnection 6276 +18 TAdoDBQuery.Col 00dd4e36 heidisql.exe Main 9130 +31 TMainForm.AnyGridGetText
But you could be so nice and try the new MSOLEDBSQL option in HeidiSQL's session manager's "Library" dropdown, to see if that makes a difference.
I use SQLOLEDB, but this generates the message "Security Issue: Using SQLOLEDB ADO provider with insecure TLS 1.0. You should install Microsoft OLE DB Driver from https://www.microsoft.com/en-us/download/confirmation.aspx?id=56730" I have installed this, but the message still appears.
I have tried MSOLEDBSQL, but this generates a "Login timeout expired" message.
I am using version 10.2.0.5707. A bug report is attached.
Yes, these should be supported by HeidiSQL in MS SQL as well.
Let's post further stuff in issue #423 .
Please login to leave a reply, or register at first.