Can't get SQL Prompt 3.6 Registered w\ VS2008

nhmarkconhmarkco Posts: 3
edited January 15, 2008 5:50AM in SQL Prompt Previous Versions
Hi,

Red Gate is installed on D:\ 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"

Comments

  • 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
    Software Engineer
    Red Gate Software
  • Thanks very much, that did it!
  • RBeaubienRBeaubien Posts: 26 Bronze 2
    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
    - Robert Beaubien
    - Kool Software
  • 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
  • I got it working just fine in VS2008.

    Be sure to change the path above to:
    C:\Program Files.... instead of D:\Program Files...
  • 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
Sign In or Register to comment.