SQL Prompt 4 doesn't work after install.

aseniuk

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

Anu D

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.

aseniuk

Fixed, Thanks for that.
Perhaps that might be a good sticky note.

Anu D

Thanks for letting us know.

I will do the needful.