Can't get SQL Prompt 3.6 Registered w\ VS2008

nhmarkco

Hi,

Red Gate is installed on \ on my Vista PC. I have tried
"SatelliteDllPath"="D:\\Program Files\\Red Gate\\SQL Prompt 3" + reboot and "SatelliteDllPath"="D:\\Program Files\\Red Gate\\SQL Prompt 3\1033" (to point SatelliteDllPath to the path of SqlPromptTopMenuDecoration.dll) + reboot; and I have reset "LoadBehavior"=dword:00000001 both times. I always get the same error: "Class not registered, Error number: 80040154" when VS2008 starts.

"regsvr32 SqlPromptTopMenuDecoration.dll" didn't work either, Error 'The module "SqlPromptTopMenuDecoration.dll" was loaded but the entry-poinnt DllRegisterServer was not found.'

Viewing SqlPromptTopMenuDecoration.dll with a lister I see the directory
d:\work\sql prompt\v 3.6.0\build\release\1033\SqlPromptTopMenuDecoration.pdb embedded. What is that about?



SQL Prompt 3.6 is working great with both VS2005 and SSMS. What steps am i missing it getting it to work with VS2008?


from "**Getting SQL Prompt 3.6 to work in Visual Studio 2008**" post by Lionel


HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\9.0\PreloadAddInState]
"RedGate.SQLPrompt.VSUI.Connect"=dword:00000001

[HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\9.0\AddIns\RedGate.SQLPrompt.VSUI.Connect]
"FriendlyName"="SQL Prompt 3.6"
"Description"="SQL Prompt 3.6 Adds Intellisense features to Visual Studio"
"LoadBehavior"=dword:00000001
"CommandPreload"=dword:00000001
"SatelliteDllName"="SqlPromptTopMenuDecoration.dll"
"SatelliteDllPath"="D:\\Program Files\\Red Gate\\SQL Prompt 3"

Lionel

Set the SatelliteDllPath to "D:\\Program Files\\Red Gate\\SQL Prompt 3" and then run

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\regasm -codebase "D:\Program Files\Red Gate\SQL Prompt 3\RedGate.SQLPrompt.VSUI.dll"

Not sure why it wasn't working for you but that should fix it

Lionel

nhmarkco

Thanks very much, that did it!

RBeaubien

Windows Vista x64
I am using the following settings with the same 80040154 error:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\9.0\PreloadAddInState]
"RedGate.SQLPrompt.VSUI.Connect"=dword:00000001

[HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\9.0\AddIns\RedGate.SQLPrompt.VSUI.Connect]
"FriendlyName"="SQL Prompt 3.6"
"Description"="SQL Prompt 3.6 Adds Intellisense features to Visual Studio"
"LoadBehavior"=dword:00000001
"CommandPreload"=dword:00000001
"SatelliteDllName"="SqlPromptTopMenuDecoration.dll"
"SatelliteDllPath"="C:\\Program Files (x86)\\Red Gate\\SQL Prompt 3"

I also executed:
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\regasm -codebase "D:\Program Files (x86)\Red Gate\SQL Prompt 3\RedGate.SQLPrompt.VSUI.dll

Tom Harris

Hi there,

we should have a private release working with VS.NET 2008 early January 2008. Please check back with support@redgate.com in the New Year.

Thanks,

Tom Harris

gknierim

I got it working just fine in VS2008.

Be sure to change the path above to:
C:\Program Files.... instead of \Program Files...

Tom Harris

Hi there,

we now have a private release of SQL Prompt 3.7 that work with Visual Studio .NET 2008. Please email support@redgate.com for details on where to download the installer from.

Thanks, Tom

Tom Harris, Red Gate Software