search

TaoK / PoorMansTSqlFormatter

A small free .Net and JS library (with demo UI, command-line bulk formatter, SSMS/VS add-in, notepad++ plugin, winmerge plugin, and demo webpage) for reformatting and coloring T-SQL code to the user's preferences.
http://www.architectshack.com/PoorMansTSqlFormatter.ashx
GNU Affero General Public License v3.0
947 stars 266 forks source link

error when opening ssms after install #255

Open rudvfaden opened 4 years ago

rudvfaden commented 4 years ago

I get the following error when i install the extension.

billede

I am using ssms 18.4

The error from the log is this

CreateInstance failed for package [FormatterPackage]Source: &apos;mscorlib&apos; Description: Filen eller assemblyen &apos;Microsoft.VisualStudio.Shell.12.0, Version=14.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a&apos; eller en af dens afh&#x00E6;ngigheder kunne ikke indl&#x00E6;ses. Den angivne fil blev ikke fundet.&#x000D;&#x000A;System.IO.FileNotFoundException: Filen eller assemblyen &apos;Microsoft.VisualStudio.Shell.12.0, Version=14.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a&apos; eller en af dens afh&#x00E6;ngigheder kunne ikke indl&#x00E6;ses. Den angivne fil blev ikke fundet.&#x000D;&#x000A;File name: &apos;Microsoft.VisualStudio.Shell.12.0, Version=14.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a&apos;&#x000D;&#x000A; at System.Reflection.RuntimeAssembly.GetType(RuntimeAssembly assembly, String name, Boolean throwOnError, Boolean ignoreCase, ObjectHandleOnStack type)&#x000D;&#x000A; at System.Reflection.RuntimeAssembly.GetType(String name, Boolean throwOnError, Boolean ignoreCase)&#x000D;&#x000A; at System.Activator.CreateInstanceFromInternal(String assemblyFile, String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, Evidence securityInfo)&#x000D;&#x000A; at System.AppDomain.CreateInstanceFrom(String assemblyFile, String typeName)&#x000D;&#x000A;&#x000D;&#x000A;WRN: Logf&#x00F8;ring af assemblybinding er deaktiveret.&#x000D;&#x000A;Logf&#x00F8;ring af assemblybindingsfejl aktiveres ved at angive registreringsdatabasev&#x00E6;rdien [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) til 1.&#x000D;&#x000A;Bem&#x00E6;rk! Ydeevnen forringes ved logf&#x00F8;ring af assemblybindingsfejl.&#x000D;&#x000A;Denne funktion deaktiveres ved at fjerne registreringsdatabasev&#x00E6;rdien [HKLM\Software\Microsoft\Fusion!EnableLog].&#x000D;&#x000A;</

anand984 commented 4 years ago

facing the same issue. Do not know how to resolve it. Using SSMS 18.5.

WyattBest commented 4 years ago

Probably a duplicate of issue #234. The solution is to install Visual Studio 2015 Isolated Shell. https://aka.ms/VS2015/IsoShell/en-US

Kcrafting commented 4 years ago

@WyattBest your solution worked for me,thanks

Visor57 commented 3 years ago

@WyattBest Works for me too, thanks.

MiguelCecilio commented 3 years ago

@WyattBest, works for me too!

hyspacex commented 3 years ago

@WyattBest Thanks! This works.