My Blog is Moving!!!

I have been blogging on BlogSpot for over a year now. I am moving my blog to MSN Spaces because it has several additional features such as Categories, 30mb of space for pictures, and is more customizable.

-j

.NET 247 : Problem with NameValueCollection from ConfigurationSettings.AppSettings on microsoft.public.dotnet.framework.aspnet

.NET 247 : Problem with NameValueCollection from ConfigurationSettings.AppSettings on microsoft.public.dotnet.framework.aspnet

I ran into this error using .config values from BizTalk Orchestration expressions. This article gave a quick fix.

-j

BizTalk ChalkTalk : Troubleshooting Common Problems in a BizTalk Server 2004 Platform Installation

BizTalk ChalkTalk : Troubleshooting Common Problems in a BizTalk Server 2004 Platform Installation

A fellow Innovative Architect was running into problems installing BizTalk 2004 on Windows XP. This article may be useful in troubleshooting what is going on. The best part is that it covers what software different services in BizTalk are dependent upon. This is important in relation to Windows XP installations because SharePoint will not run on Windows XP. This means that BAS and HWS cannot be installed on Windows XP.

-j

Google Groups : microsoft.public.biztalk.general

Google Groups : microsoft.public.biztalk.general

This news post describes a very similar format that I have to follow to commicate with Freddie Mac's Desktop Underwriter system. It looks like I will be writing a custom adapter to handle this (ugh!).

I may be using this:
GotDotNet User Sample: Biztalk Server Adapter Framework 1.1 with VB.NET support FINAL

This link may be useful to me in this process as well:
http://www.dixie.sk/blog/post/1/16

More to come...

-j

You cannot use a pass-through pipeline to receive a file in an orchestration in BizTalk Server 2004

You cannot use a pass-through pipeline to receive a file in an orchestration in BizTalk Server 2004

This is an interesting issue. It doesn't make sense to use the xml receive pipeline to receive a flat-file, but there it is...

-j

Handling Default Namespaces

Handling Default Namespaces

This article was useful to me in figuring out how to use default namespaces in xslt stylesheets.

-j

MCSD for Microsoft .NET Certification Requirements

MCSD for Microsoft .NET Certification Requirements

Innovative Architects gives bonuses and gets Microsoft Partner points for employee certifications. I want to keep track of this page because it is likely to be the track I would take to Microsoft Certification.

-j

Visual Studio 2005: Technical Resources for Visual Studio 2005

Visual Studio 2005: Technical Resources for Visual Studio 2005

I loaded a virtual pc with VS2005 Beta 2. I'll be coming back to this site to get some guided tours of new features.

I watched this webcast and was impressed with it:

Whidbey WebCast

-j

Matt's Musings on Messaging - Send XML to a SQL stored procedure (RELOADED)

Matt's Musings on Messaging - Send XML to a SQL stored procedure (RELOADED)

This sample looks promising. I need to do some fairly complex CRUD operations on a table to keep track of attributes related to a business transaction. Instead of separating create/update/delete statements into separate ports, I want to do it all at once using an xml fragment that I will parse in a stored procedure.

I would use an update-gram, but the only output generated is a "success" message. I want the flexibility of returning the table data post-update back to biztalk. This requirement is not supported in an update-gram.

-j

XSD Object Code Generator

XSD Object Code Generator

This tool generates a MUCH better class representation of an .xsd schema. The output is a lot easier to consume than the output generated by the default xsd.exe tool that ships with .NET. I wish that the project I am currently working on had used this tool instead of xsd.exe to generate the classes being used.

XML - Prefix problem with XML/XSL

XML - Prefix problem with XML/XSL

I was running into a little bit of a snaffu with using custom xslt in a BizTalk map. All I had to do was reference the appropriate namespace in the map and voila! If only I had discovered that three or four hours ago! :o(

-j

XSL Transformations

XSL Transformations

This is a really good resource for xsl transformations. One of the useful things to me is the section about using xsl:element and xsl:attribute when transforming from xml to xml.

http://www.ibiblio.org/xml/books/bible2/chapters/ch17.html#d1e6328

I had an interesting case where I needed to transform an "extensible" database model into a more usable xml structure.

This is the original output of a SQL Server stored proc using For Xml Auto:

<root>
<transaction transactionid="1">
<vendor vendordescription="DU">
<status statusdescription="Created">
<transactionattribute attributeid="1" attributekey="TestAttribute1"
attributevalue="TestValue1" attributedatatype="String">
<transactionattribute attributeid="2" attributekey="TestAttribute2"
attributevalue="TestValue2" attributedatatype="String">
</transactionattribute>
</transactionattribute>
</status>
</vendor>
</transaction>
</root>

I needed the output to be in a format somewhat like this:

<transactions>
<transaction>
<transactionid>1</transactionid>
<vendorname>DU</vendorname>
<status>Created</status>
<testattribute1>TestValue1</testattribute1>
<testattribute2>TestValue2</testattribute2>
</transaction>
</transactions>

So, to accomplish this I created this xsl transformation script:

<?xml version="1.0" encoding="ISO-8859-1" ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes" omit-xml-declaration="no" />
<xsl:template match="/">
<Transactions>
<Transaction>
<xsl:element name="TransactionID">
<xsl:value-of select="//Transaction/@TransactionID" />
</xsl:element>
<xsl:element name="VendorName">
<xsl:value-of select="//Vendor/@VendorDescription" />
</xsl:element>
<xsl:element name="Status">
<xsl:value-of select="//Status/@StatusDescription" />
</xsl:element>
<xsl:for-each select="//TransactionAttribute">
<xsl:element name="{@AttributeKey}">
<xsl:value-of select="@AttributeValue" />
</xsl:element>
</xsl:for-each>
</Transaction>
</Transactions>
</xsl:template>
</xsl:stylesheet>

App.Config for BizTalk 2004

App.Config for BizTalk 2004

Basic info. about using .config data in Biztalk 2004.

BizTalk 2004 Flat File Schema Tutorial 1

BizTalk 2004 Flat File Schema Tutorial 1

This is a good overview of creating schema for flat-file parsing.

Constructing BizTalk 2004 XML Messages (In an Orchestration) - Choices

Constructing BizTalk 2004 XML Messages (In an Orchestration) - Choices

Finally, I found an example of constructing a message and assigning property values to it in BizTalk 2004 Orchestrations. Example number three in this link is what I will be using.

BizTalk Server Orchestration - message has not been initialized in construct statement

BizTalk Server Orchestration - message has not been initialized in construct statement

This may sound very basic...but...

When using the MessageAssignment orchestration shape, if the message you are using has not been instantiated by a map or a port then you must manually instantiate the message:

Message_Type = new System.Xml.XmlDocument();
//Now that the message has been instantiated it can be used.
Message_Type.[PropertyName] = "Property Value";

Mark Schmidt's Abode : Creating Multiple Input Maps for BizTalk Server 2004

I may use this to compose multipart mime documents.

...Update:
I discovered an issue with this post. I was only able to get the BizTalk Mapper to launch when the schemas used in the example were in the same project as the orchestration. There may be another solution, but I don't have time to look for one! I think the reason for the problem is the namespacing used in the schemas I downloaded in the example. -j

...Update 2:
This method only works if the target namespace of all the input maps is defined. If the namespaces are not defined then the map generated only carries across the source schema for the first message. -j

Threat Modeling Web Applications

Since security concerns often take a back seat to speed of delivery, I thought this article was interesting. It shows a simple model for elaborating upon security concerns for web-based applications.

Re: [xsl] how to remove xmlns attributes in html out put via copy-of

Yippie friggin doo da! I found this xsl script that strips namespaces and prefixes out of an xml document. This is going to be very useful in some Biztalk 2004 transformations that I doing.

W3Schools Online Web Tutorials

Now that I am doing BizTalk work, I will need a better understanding of XPath, advanced Xml, and XSL. So...

Different Types of BizTalk Schemas

I used this article to generate xsd's from dtd's provided by a client that had to be conformed to. Xsd's are a much easier format to work with without a doubt!

Meeting by Wire - Your NetMeeting Information Source

This site is useful in getting netmeeting up and running and answering related questions.

BizTalk 2004 Naming Conventions

Innovative Architects uses these naming conventions for BizTalk 2004 Artifacts.

XML Namespaces, Prefixes, and elementFormDefault

This is a decent document on xml namespace usage.

The Enterprise Single Sign-On Service and associated BizTalk Server 2004 services fail after you install Windows XP Service Pack 2 (SP2)

I used method number one to enable RPC Endpoint Mapper client calls attempting to get Biztalk 2004 to configure correctly.

You may receive a "Failed to load configuration data for feature: RulesEngine" error message when you run the configframework.exe command to configure BizTalk Server 2004

I tried this to no avail when I was getting this message while configuring Biztalk 2004

BizTalk ChalkTalk : The QuickStart Guide to Installing & Configuring BizTalk Server 2004 for Windows Server 2003

Guide for installing Biztalk 2004

Administration for the Microsoft Outlook E-mail Security Update

More outlook security stuff...

Microsoft Office Assistance: Outlook Administrator Pack

This is the configuration tool to modify exchange so security messages in outlook no longer appear.

Vertical Text in HTML

This may be useful for UI purposes in the future...Only works in IE

XML and SOAP Serialization

Here is a simple example of serializing an object to an xml file.

How To Retrieve Values from DataRows That Are Marked "Deleted" by Using Visual Basic .NET

How to access a File Transfer Protocol site by using Visual Basic .NET

I wrapped this code in a COM interface to be used by VB6 stuff that still hangs around insidiously.

GotDotNet User Sample: FTP Client in .NET

This C# project appears to be a useful sockets wrapper that implements basic ftp functionality.

VB Helper: HowTo: Start another program using Shell and wait until it finishes

MSDN XPath Reference

ShellExecute

This is an example of using the Windows API to shell out to a program and wait for the handle to be released.

Visual Basic: Adventures in Visual Basic .NET: A Simple Business Rules Manager

This might be a useful architecture to handle business rules in a common way.

Programmingtutorials.com - Free Online Programming Tutorials

A bunch of links to vb.net tutorials as well as others.

VBCommenter PowerToy

LibCheck

Assembly comparison tool.

Take advantage of COM+ object pooling

We discovered this method:

Dim _dataView As DataView = New DataView(_table, String.Empty, "CartonId Asc", DataViewRowState.CurrentRows)
Dim _rowView As DataRowView() = _dataView.FindRows(_cartonId)

To be more efficient than this method:

Dim _rows() as DataRow

_rows = _table.Select("criteria")

Apparently, the first method creates an in-memory index which is "seeked" through with the find method whereas the second method must perform a table scan.

IIS Tips Tricks & Resources - Forum - IIS 6 (Windows Server 2003) Questions & Answers - invalid credentials and mysql issues

We were having a problem where our webservice was crashing. It looks like the culprit was the printer driver for our printer.

Sample Printer Delivery Extension

This is the boilerplate code that Shawn Wildermuth used to write our SRS webservice.

PRB: Incorrect Entries in the Csapp.ini File Cause "s_securehostname Not Found in Admin Database" Error

This fixed an error we had on a staging deployment of the Hatchery application. The csapp.ini file should be in the root of the web application directory.

Use a field in Page footers

SQL Reporting Services
We used this work-around to get dynamic content to display in a Page Footer.

HOW TO: Troubleshoot Application Performance Issues

The Commerce Server 2002 Profile Service creates many connections to SQL Server

This is the source of our passive open connections to the SQL Server from Commerce Server.

mass spec

This is my brother-in-law Tim's blog.

This article explains the dbcc showcontig report and what it means.

ExtremeExperts

This article has a sql script that generates index defrag statements for all indexes in a database.

Radisson Resort Parkway

Resort hotel in Orlando - $85 per night

WholeHealthMD. Learn to manage your health conditions and illnesses

This article pertains to kidney stones.