Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL Error (0): Operation is not allowed when the object is closed #615

Closed
igitur opened this issue Apr 16, 2019 · 4 comments

Comments

Projects
None yet
2 participants
@igitur
Copy link
Contributor

commented Apr 16, 2019

Steps to reproduce this issue

  • Open HeidiSQL
  • Connect to a database from the session manager
  • Browse to a table and select the Data tab to view the table's contents
  • Close the selected database connection from the menu bar.
  • Open a different database on a different server from the session manager
  • Browse to a table and select the Data tab to view the table's contents

Current behavior

An error occurs:

image

Expected behavior

No error occurs

Possible solution

Obviously the connection management is slightly flawed.

Environment

  • HeidiSQL version:
    10.1.0.5532
  • Database system and version:
    MS SQL 2016
  • Operating system:
    Windows 7 64b
@igitur

This comment has been minimized.

Copy link
Contributor Author

commented Jun 24, 2019

@ansgarbecker Can you replicate this?

@ansgarbecker

This comment has been minimized.

Copy link
Collaborator

commented Jun 24, 2019

Yes, I can reproduce a crash, although the exact place is a different one:

008cb1c7 heidisql.exe dbconnection    6910  +3 TDBQuery.Modified
00ab0253 heidisql.exe Main            8460 +10 TMainForm.DBtreeFocusChanged
0075e0f2 heidisql.exe VirtualTrees   19854  +2 TBaseVirtualTree.DoFocusChange
00754c3b heidisql.exe VirtualTrees   14574  +5 TBaseVirtualTree.SetFocusedNode
007e1243 heidisql.exe apphelpers      1636  +5 SelectNode
00aabcf0 heidisql.exe Main            7049 +12 TMainForm.SetActiveDatabase
00a9ecfa heidisql.exe Main            3977 +30 TMainForm.InitConnection
009a0e9e heidisql.exe connections      358  +8 Tconnform.btnOpenClick
@ansgarbecker

This comment has been minimized.

Copy link
Collaborator

commented Jun 24, 2019

I just fixed some potential causes for this issue. Not sure where exactly that happens for you, but I don't get an exception any longer with the new build.

@ansgarbecker ansgarbecker added this to the v10.3 milestone Jun 24, 2019

@igitur

This comment has been minimized.

Copy link
Contributor Author

commented Jun 25, 2019

Thanks. So far it's looking solved. I'll keep monitoring.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.