Update to BizTalk SchemaViewer tool

Monday, March 14, 2005 8:00:00 AM (GMT Standard Time, UTC+00:00)

I've posted an update to my SchemaViewer tool (which shows you the schemas you have deployed into the BizTalk management database and also allows you to generate a CS or VB.NET project using the XSD.exe code generator). I've been very slow in doing this, thanks to Marvin Smit (Web Services and BizTalk instructor at DevelopMentor) - it no longer uses the Infragistics controls (which makes the project much simpler) and also means you don't have to have a design time license for those controls for the code to be useful - so I've also posted the code. Thanks again Marvin.

BizTalk Comments [3]

Thursday, May 26, 2005 6:19:54 PM (GMT Daylight Time, UTC+01:00)

I launched the Schema Viewer tool, and the screen appears. I left the server as (local) and clicked the Load/Refresh Biztalk Registered Schemas button, and I got the following error:
System.InvalidOperationException: ExecuteReader requires an open and available Connection. The connection's current state is Closed.
at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean executing)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at Microsoft.BizTalk.ExplorerOM.Schema.get_XmlContent()
at BTSCodeGenerator.BTSXSDCodeGen.GetSchemas() in C:\tools\biztalk\SchemaViewer\BTSCodeGenerator\CodeGenerator.cs:line 66
at SchemaViewer.Form1.Button_Load_Click(Object sender, EventArgs e) in c:\tools\biztalk\schemaviewer\schemaviewer\form1.cs:line 283
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

When I changed the name to the fully qualified DB name in the BizTalk Explorer window(SQLServerName.BizTalkMgmtDb), I got this error:

System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
at Microsoft.BizTalk.ExplorerOM.BtsCatalogExplorer.set_ConnectionString(String value)
at BTSCodeGenerator.BTSXSDCodeGen..ctor(String btsConn, String path, Boolean generateAsVb) in C:\tools\biztalk\SchemaViewer\BTSCodeGenerator\CodeGenerator.cs:line 42
at BTSCodeGenerator.BTSXSDCodeGen..ctor(String btsConn, String path) in C:\tools\biztalk\SchemaViewer\BTSCodeGenerator\CodeGenerator.cs:line 33
at SchemaViewer.Form1.CreateGen() in c:\tools\biztalk\schemaviewer\schemaviewer\form1.cs:line 295
at SchemaViewer.Form1.Button_Load_Click(Object sender, EventArgs e) in c:\tools\biztalk\schemaviewer\schemaviewer\form1.cs:line 281
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Can you tell me what I am doing wrong? I verified that BizTalk and SQl Server are running.

Nathan | nweddle2AT NOSPAMyahoo dot com

Wednesday, November 23, 2005 6:31:41 AM (GMT Standard Time, UTC+00:00)

Health is the thing that makes you feel that now is the best time of the year. Health is the requisite after
morality.

phentermine | tomAT NOSPAMvkl dot net

Wednesday, November 23, 2005 7:32:05 AM (GMT Standard Time, UTC+00:00)

There are three things that last: faith, hope and love, and the greatest of these is love

web design | web_desAT NOSPAMworldweb dot net

All comments require the approval of the site owner before being displayed.