6.2 Crash Visual Studio & Freezes Notepad++

I'm on Windows 7 x64 and Visual Studio 2010 SP1. UAC is turned off and my user is an Administrator. SQL Assist was installed using the Professional option. I only want to use it with SSMS, not Visual Studio or anything else.

I let the SQL Assist update automatically, now Visual Studio starts with the error "The 'Visual Studio Component Model Host Package' package did not load correctly." It freezes, then crashes if I open a solution. If I start Notepad++, it uses a bunch of RAM and CPU, but the GUI never appears.

I tried un-checking Visual Studio and Notepad++ in the SQL Assist config. This allows Notepad++ to start, but Visual Studio does the exact same thing.

I uninstall SQL Assist everything works. When I reinstall, the same thing happens again.

Is this is a new install or you have had previous version of SQL Assistant installed before this one?

Please check in the registry if you have
HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\10.0\AddIns\SqlAssist.CSmsAddin
and
HKEY_CLASSES_ROOT\CLSID\{754CF073-05B2-4E97-880D-1D88D8D514BE}
keys, they could be from the old install, if you see them, delete them

Additionally, if you see files in %USERPROFILE%\Local Settings\Application Data\Microsoft\VisualStudio\10.0\Extensions\SoftTree Technologies\SqlAssist.vs\1.0\, delete them too.

That should fix the issue.

	Quote:
	Is this is a new install or you have had previous version of SQL Assistant installed before this one?

Read my entire post.

Quote:

Please check in the registry if you have
HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\10.0\AddIns\SqlAssist.CSmsAddin
and
HKEY_CLASSES_ROOT\CLSID\{754CF073-05B2-4E97-880D-1D88D8D514BE}
keys, they could be from the old install, if you see them, delete them

Additionally, if you see files in %USERPROFILE%\Local Settings\Application Data\Microsoft\VisualStudio\10.0\Extensions\SoftTree Technologies\SqlAssist.vs\1.0\, delete them too.

They don't exist.

	Quote:
	That should fix the issue.

It did not.

I found a solution. I installed SQL Assist with the the Visual Studio Addin checked, even though I don't want it.

Your installer is telling Visual Studio to load the Addin, even if you don't choose to install it.

HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\10.0\ExtensionManager\EnabledExtensions
u can find an entry with a lot of question mark: ??????????????????
If you remove it, all start working fine :)

You are correct. That registry value entry is left from the previous version of SQL Assistant 6.1. It was used for the VS add-on registration, I 'm not sure why you have lots of question marks in there. Anyway, version 6.2 uses a different mechanism for loading the add-on and that registry value appears to be in the way. Thank you for reporting that.

To be exact, the registry values that need to be deleted are

HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\10.0\ExtensionManager\EnabledExtensions\SqlAssist.vs..3d117742-b761-4b83-86ce-ca2aa58a8660,1.0
and
HKEY_LOCAL_MACHINE\Software\Microsoft\VisualStudio\10.0\ExtensionManager\EnabledExtensions\SqlAssist.vs..3d117742-b761-4b83-86ce-ca2aa58a8660,1.0

Last edited by SysOp on Mon Aug 27, 2012 1:15 pm; edited 1 time in total

	SysOp wrote:
	You are correct. That registry value entry is left from the previous version of SQL Assistant 6.1. It was used for the VS add-on registration, I 'm not sure why you have lots of question marks in there. Anyway, version 6.2 uses a different mechanism for loading the add-on and that registry value appears to be in the way. Thank you for reporting that.

I think he meant that it puts in the path to the dll as the value but instead of the username it shows ??? like:

c:\documents and settings\???????????\LocalSettings\...

I saw this same problem with 6.2 (no previous installation of 6.1 as this is a new machine). I may have originally installed with VS integration, but then later tried to disable it due to these issues. That's when I found this post and saw the registry value above. Problem solved.

Glad it worked for you.

PS. My 2 cents... the main reason for all these issues is Microsoft changing add-on registration methods and interfaces in every VS major version making life of other software publishers miserable.

This particular issue just seriously cost our team. A few of us use SQL Assist and we installed the most recent version in the last few days, and this started causing Visual Studio (our main tool here) to crash with cryptic error messages about extensions. I was able to find this thread and fix my issue within an hour, but a co-worker spent hours trying to deal with this and even uninstalled and reinstalled VS, which takes quite some time.

This needs to be resolved directly in the application. Anyone with Visual Studio will not be able to use Visual Studio if they install 6.2.112, and their only recourse will be to contact STT. But that is only if they are able to deduce that the SQLAssist upgrade was what caused the issue.

Very sorry for the caused inconvenience.

SQL Assistant version 6.3 will have a forward-compatibility fix to address that Visual Studio issue.

I'm on Windows 7 x64 and Visual Studio 2010 SP1. UAC is turned off and my user is an Administrator. SQL Assist was installed using the Professional option. I only want to use it with SSMS, not Visual Studio or anything else.

I let the SQL Assist update automatically, now Visual Studio starts with the error
"The 'Visual Studio Component Model Host Package' package did not load correctly." It freezes, then crashes if I open a solution. If I start Notepad++, it uses a bunch of RAM and CPU, but the GUI never appears.

I tried un-checking Visual Studio and Notepad++ in the SQL Assist config. This allows Notepad++ to start, but Visual Studio does the exact same thing.

I uninstall SQL Assist everything works. When I reinstall, the same thing happens again.

Hi. Sorry for late replay, your post have been overlooked by accident. Please start VS in Run as Administrator mode and check if you get the same error (do not confuse Run as Administrator, with Administrator user account)