What are the challenges you face when working across database platforms? Take the survey

SQL Prompt 4 doesn't work after install.

aseniukaseniuk Posts: 22
edited October 29, 2009 5:36AM in SQL Prompt Previous Versions
I recently had to do an rebuild of my workstation and after I finished building it I added SQL Prompt a few days ago and it hasn't worked in Visual Studio Team System 2008 nor SQL 2008 Management Studio.

Here is the error I get.
System.ApplicationException: Exception within progress task ---> System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.TextManager.Interop.IVsTextView'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{BB23A14B-7C61-469A-9890-A95648CED5E6}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).
   at Microsoft.VisualStudio.TextManager.Interop.IVsTextView.GetSelection(Int32& piAnchorLine, Int32& piAnchorCol, Int32& piEndLine, Int32& piEndCol)
   at RedGate.SQLPrompt.CommonVS.Editor.VSEditorWindow.get_Selection()
   at RedGate.SQLPrompt.CommonUI.Refactor.Refactor.a(EditorWindowBase , Func`2 , Errors& )
   at RedGate.SQLPrompt.CommonUI.Refactor.Refactor.a(EditorWindowBase , Errors& , Func`2[] )
   at RedGate.SQLPrompt.CommonUI.Refactor.Refactor.a.Run()
   at RedGate.SqlPrompt.Engine.Progress.TaskAggregator.Run()
   at RedGate.SQLPrompt.CommonUI.Forms.ProgressDialogue.a()
   --- End of inner exception stack trace ---
   at RedGate.SQLPrompt.CommonUI.Forms.ProgressDialogue.ShowProgress(ITaskRunner task)
   at RedGate.SQLPrompt.CommonUI.Refactor.Refactor.a(a )
   at RedGate.SQLPrompt.CommonUI.Refactor.Refactor.LayOutSql(LayoutOptions layoutOptions, EditorWindowBase editor)
   at b.Execute()
   at a.Execute()
   at RedGate.SQLPrompt.CommonVS.Commands.VSCommandControler.EnvDTE.IDTCommandTarget.Exec(String CmdName, vsCommandExecOption ExecuteOption, Object& VariantIn, Object& VariantOut, Boolean& Handled)

Not sure what it is or if it didn't install correctly. Any help is appreciated.

Version Information:
Microsoft Visual Studio 2008 9.0.30729.1 SP
Microsoft SQL Server Management Studio 10.0.1600.22 (080709-1414)
Microsoft Analysis Services Client Tools 2007.0100.1600.022 (080709-1414)
Microsoft Data Access Components (MDAC) 6.0.6000.16386 (vista_rtm.061101-2205)
Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 8.0.6001.18828
Microsoft .NET Framework 2.0.50727.3603
Operating System 6.0.6000
Database Analyst
Alberta Justice and Solicitor General


  • Options
    Anu DAnu D Posts: 876 Silver 3
    Many thanks for your post and apologies for the error.

    For some unknown reason, SQL Server Management Studio installations have been unravelling and deleting the interface that Prompt and Refactor need to get access to the query window.
    Running this from a Command Prompt should fix it:
    Code: regsvr32 "%commonprogramfiles%\microsoft shared\msenv\textmgrp.dll"

    Kindly let us know if this fixed the problem.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Options
    Fixed, Thanks for that.
    Perhaps that might be a good sticky note.
    Database Analyst
    Alberta Justice and Solicitor General
  • Options
    Anu DAnu D Posts: 876 Silver 3
    Thanks for letting us know.

    I will do the needful.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.