SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Beta 13 unhandled exception SSMS 20.2

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Beta 13 unhandled exception SSMS 20.2
Author Message
Mindflux



Joined: 25 May 2013
Posts: 846
Country: United States

Post Beta 13 unhandled exception SSMS 20.2 Reply with quote
When Launching SSMS 20.2 (July 9, 2024)


Context: Loading of Object Explorer add-in SqlAssist.Ssms2024 failed.
System.IO.FileNotFoundException: Could not load file or assembly 'SqlAssist.Ssms2024' or one of its dependencies. The system cannot find the file specified.
File name: 'SqlAssist.Ssms2024'
at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean forIntrospection)
at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.Load(String assemblyString)
at SqlAssist.SSMS_IDE.Init(DTE application)

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].



SQL Server Management Studio 20.2.30.0
SQL Server Management Objects (SMO) 17.100.40.0+f57178c95d4376485d3f597f2b829bbd6f80fd6f
Microsoft T-SQL Parser 17.2.3.1+46115224c373754fdd41516eaae1386cabc4819e.46115224c373754fdd41516eaae1386cabc4819e
Microsoft Analysis Services Client Tools 20.0.3.0
Microsoft Data SqlClient (MDS) 5.1.5
Microsoft SQL Server Data-Tier Application Framework (DacFX) 162.3.566.1+89d89fe935702c8836ebaf6a03cf61b85118f847.89d89fe935702c8836ebaf6a03cf61b85118f847
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.22631
Wed Jul 10, 2024 11:10 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7948

Post Reply with quote
Do you see SqlAssist.Ssms2024.dll in C:\Program Files (x86)\SQL Assistant 13\bin folder?
Wed Jul 10, 2024 11:32 am View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 846
Country: United States

Post Reply with quote
No such file exists.
Wed Jul 10, 2024 11:34 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7948

Post Reply with quote
That's weird. Please download a copy from here https://www.softtreetech.com/sqlassist/diag/SqlAssist.SSMS2014.dll . After downloading copy it to C:\Program Files (x86)\SQL Assistant 13\bin, and then using the Options dialog, disable and re-enable SQL Assistant's add-on for SSMS to complete the installation.


Last edited by SysOp on Wed Jul 10, 2024 5:41 pm; edited 1 time in total
Wed Jul 10, 2024 4:40 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 846
Country: United States

Post Reply with quote
Thanks. I can also confirm that my Beta 13 install on my home laptop also doesn't have this file.

Also the link you provided does not work for the dll.
Wed Jul 10, 2024 4:52 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7948

Post Reply with quote
I edited the previous post and added spaces between the link and the dot ending the sentence. Please try one more time.
Wed Jul 10, 2024 5:42 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 846
Country: United States

Post Reply with quote
SysOp wrote:
I edited the previous post and added spaces between the link and the dot ending the sentence. Please try one more time.


Okay the link worked, but I have an exception on SqlAssist.SSMS2024.dll, not 2014 as you linked to.
Wed Jul 10, 2024 5:49 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 846
Country: United States

Post Reply with quote
Still looking for a remedy on this one.
Thu Jul 18, 2024 8:45 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7948

Post Reply with quote
Does unregistering/re-registering the addon using Options dialog make a difference?
Fri Jul 19, 2024 8:27 am View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 846
Country: United States

Post Reply with quote
SysOp wrote:
Does unregistering/re-registering the addon using Options dialog make a difference?


I never got the right DLL file. You linked a SSMS2014 dll, and the error is for SSMS2024.dll
Fri Jul 19, 2024 8:28 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7948

Post Reply with quote
Could you please re-download the beta installation, and install it again? It has the correct file.
Fri Jul 19, 2024 1:56 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 846
Country: United States

Post Reply with quote
SysOp wrote:
Could you please re-download the beta installation, and install it again? It has the correct file.


That does appear to have fixed it. Thank you.
Fri Jul 19, 2024 2:03 pm 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.