ErikEJ / SqlCeToolbox

SQLite & SQL Server Compact Toolbox extension for Visual Studio, SSMS (and stand alone)
Other
847 stars 174 forks source link

Visual Studio crashes when using SQLite and SQL Server Compact Toolbox after update #974

Closed sultanaalyami closed 11 months ago

sultanaalyami commented 1 year ago

Describe what is not working as expected.

After connecting to a local SQLite database using SQLite and SQL Server Compact Toolbox, Visual Studio crashed. Each subsequent attempt to restart resulted in it closing automatically after a few seconds. Additionally, after a recent update, the tool remains connected to the database even after removing the connection from the connection window. Adjusting the toolbox settings related to database retrieval causes Visual Studio to crash again.

Steps to reproduce

  1. Connect to a local SQLite database using SQLite and SQL Server Compact Toolbox.
  2. Observe Visual Studio crashing and closing automatically after a few seconds.
  3. Install the update Visual Studio 2022 version 17.7.6.
  4. Use the toolbox post-update and notice that the tool remains connected to the database even after removing the connection.
  5. Access the toolbox settings and adjust the database retrieval options.
  6. Observe Visual Studio crashing again.

Further technical details

Additional Information:

The update released on Oct 24th, 2023 for Visual Studio 2022 version 17.7.6 mentions fixing issues related to adding a new SQLite connection, which might be related to the observed issue.

ErikEJ commented 1 year ago

@sultanaalyami maybe you have some corrupted Server Explorer connections?

ErikEJ commented 1 year ago

@sultanaalyami

I am unable to reproduce.

How do you determine that the toolbox remains connected?

What do you mean by: "Adjusting the toolbox settings related to database retrieval causes Visual Studio to crash again." ?

ErikEJ commented 11 months ago

Closing as follow up questions were not answered @sultanaalyami