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

Exception occurs on Layout after upgrade

davegdaveg Posts: 3
edited September 4, 2008 7:07AM in SQL Prompt Previous Versions
have just upgraded to SQL Prompt Pro from Standard. When trying to use the Layout SQL menu option, the following exception occurs:

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 , b , c& )
at RedGate.SQLPrompt.CommonUI.Refactor.Refactor.a(EditorWindowBase , c& , b[] )
at RedGate.SQLPrompt.CommonUI.Refactor.Refactor.a.Run()
at RedGate.SQLPrompt.CommonUI.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.LayOutSql(EditorWindowBase editor, SqlPromptOptions options)
at b.Execute()
at RedGate.SQLPrompt.CommonVS.Commands.VSCommandControler.Exec(String CmdName, vsCommandExecOption ExecuteOption, Object& VariantIn, Object& VariantOut, Boolean& Handled)


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi dave,

    I think that we have seen this problem before... 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:
    regsvr32 "%commonprogramfiles%\microsoft shared\msenv\textmgrp.dll"
    This should fix the problem.
  • Options
    Perfect Brian, all fixed.

Sign In or Register to comment.