Error message instead of the list of connections

[PeterAdam]

There is a red highlighted text in the SQLite/SQL Server Compact Toolbox after starting Visual Studio 2017 Community. It says Due to high risk of deadlock you cannot call GetService from a background thread in an AsyncPackage derived class. You should ...

Right click -> add connections from solution makes all my connections to appear, not just from the current solution (including SSCE connections)

Steps to reproduce

Start VS 2017 Community.

Further technical details

Toolbox/Power Tools version: (found in About dialog - blue questionmark icon): Version 4.8.743.0 - more than 900 000 downloads

Database engine: (SQlite, SQL Compact or SQL Server): SQLite

SQL Server Compact 4.0 in GAC - Yes - 4.0.8482.1 SQL Server Compact 4.0 DbProvider - Yes SQL Server Compact 4.0 Simple DDEX provider - Yes SQL Server Compact 3.5 in GAC - Yes - 3.5.8080.0 SQL Server Compact 3.5 DbProvider - Yes Sync Framework 2.1 SqlCe 3.5 provider - No SQLite ADO.NET Provider used: 3.31.1 SQLite EF6 DbProvider in GAC - Yes System.Data.SQLite DDEX provider - No SQLite Simple DDEX provider - Yes

Visual Studio or SSMS version: (e.g. Visual Studio 2017 15.3, SSMS 17.3): 2017 Community 15.9.47

[ErikEJ]

Are you able to try VS 2022 Community?

[PeterAdam]

I have installed it to a VS 2022 Community on a W11 Insider Preview, the message is the same Edit: Installed from inside VS, not the "daily" build.

[ErikEJ]

It is not the same message.

Your SQL Compact install is broken- please remove and re-install.

[PeterAdam]

You are right. Do I have to install it? I would use Sqlite functionality only. SqlCE sadly out of support for more than a year.

Az Android Outlookhttps://aka.ms/ghei36 letöltése

Üdvözlettel, Ádám Péter

---

From: Erik Ejlskov Jensen @.> Sent: Friday, April 22, 2022 6:49:13 AM To: ErikEJ/SqlCeToolbox @.> Cc: PeterAdam @.>; Author @.> Subject: Re: [ErikEJ/SqlCeToolbox] Error message instead of the list of connections (Issue #934)

It is not the same message.

Your SQL Compact install is broken- please remove and re-install.

— Reply to this email directly, view it on GitHubhttps://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FErikEJ%2FSqlCeToolbox%2Fissues%2F934%23issuecomment-1106003051&data=05%7C01%7C%7Cf79951cfc51447a7e23408da241b7336%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637861997602888328%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=atnnErEvOE3f%2BCUo99ZeJ%2FqYsxRA8Dtf4Wzh7iQIOqU%3D&reserved=0, or unsubscribehttps://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAB57FWLA5PF7NG6L36HDVSLVGIVUTANCNFSM5T5LVYEA&data=05%7C01%7C%7Cf79951cfc51447a7e23408da241b7336%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637861997602888328%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=rtt2Cob2TdaDrUPB0MPA8S3JjzXzqGywuHjktNfDEoo%3D&reserved=0. You are receiving this because you authored the thread.Message ID: @.***>

[ErikEJ]

You can also just remove it.

But Toolbox breaks if you have a broken SQL CE install.

[PeterAdam]

I have installed SQLCE 4.0 but found out the problem was the missing 64 bit SQLCE 3.5 SP2:

I don't know what installed the 32 bit SQLCE 3.5 SP2.

To answer the question, yes, the toolbox is working without error message on VS 2022 CE. I will try to open databases with it.

[ErikEJ]

Perfect!