SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
11.5 - bug with Visual studio 2019

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
11.5 - bug with Visual studio 2019
Author Message
ezhovea



Joined: 07 Jul 2016
Posts: 6
Country: Russian Federation

Post 11.5 - bug with Visual studio 2019 Reply with quote
Dears,
When I first time open the T-SQL editor (just a plain editor for SSDT scripts) in Visual Studio I receive two pop-up window with exceptions:
First one:
----------------------------
SQL Assistant - Error
---------------------------
ServiceCache class not found in Microsoft.SqlServer.Express.VSIntegration
---------------------------
ОК
---------------------------
Second one immediately after the first:
---------------------------
SQL Assistant - Error
---------------------------
ScriptType type not found in Microsoft.SqlServer.Express.VSIntegration
---------------------------
ОК
---------------------------

After that everything works fine, but after MSVS restart is occures again.


11.5.362 prof
VisualStudio.16.Release/16.9.4+31205.134
Microsoft .NET Framework Version 4.8.04084
Installed Version: Professional
SQL Server Data Tools 16.0.62103.10080

BR, Evgeniy
Tue May 11, 2021 4:00 am View user's profile Send private message
ezhovea



Joined: 07 Jul 2016
Posts: 6
Country: Russian Federation

Post Re: 11.5 - bug with Visual studio 2019 Reply with quote
ezhovea wrote:
Dears,
When I first time open the T-SQL editor (just a plain editor for SSDT scripts) in Visual Studio I receive two pop-up window with exceptions:


Please, check my post from Mar 30, 2020
https://www.softtreetech.com/support/phpBB2/viewtopic.php?t=25449&highlight=
The issue is the same :(
Tue May 11, 2021 4:09 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7414

Post Reply with quote
Does it work for you when you open SQL files using File/Open menu? When opening procedure code from SQL Server Object Explorer or Database Explorer?
Tue May 11, 2021 9:50 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7414

Post Reply with quote
We managed to reproduce this issue. The issue is specific to one particular editor type in VS which is different from everything else. That editor is invoked from Tools / SQL Server / New Query... menu, it internally has a dependency on Microsoft.SqlServer.Express.VSIntegration component from SQL Server Express, which we currently don't expect/support in VS IDE. We will have it supported in the next version 12.0.

As a workaround for now, please use File / Open menu to open existing or new SQL file, or to edit existing procedures in the database, you can open them from the VS Database Explorer. We support both of them.
Thu May 13, 2021 10:03 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.