Friday, September 10, 2004

SQL Adapter Schema Generator Wizard Bug

SQL adapter schema genarator wizard throws an error when the stored procedure parameter contains char(1). There is no KB article for this bug.

Workaround:Make the char(1) to varchar(1) and generate the schema and change it back to char(1) in the stored procedure.

geek's fix:
In BizTalk installation directory, look for XDRtoXSD.xslt and change as follows:

From: <xsl:template mode="convert-datatype" match="@dt:type[.='char']">xs:char</xsl:template>
To: &<xsl:template mode="convert-datatype" match="@dt:type[.='char']">xs:string</xsl:template>
You are all set now.

10 Comments:

At 8:07 PM, Anonymous Anonymous said...

I was experiencing the same issue. Thanks for the work around.

 
At 9:30 AM, Blogger Steve Austin said...

Interesting blog. I have a xforms blog.

 
At 7:42 PM, Anonymous Anonymous said...

You can run an article submission site and article software that gets other people to submit articles, which builds thousands of Google AdSense revenue generating pages without you lifting a finger.

 
At 5:56 PM, Blogger Kim said...

The more I read other blogs it really gives me great ideas. Your is good.

My business management article site is all about business management article.

I think you will like it.

 
At 10:06 AM, Anonymous Anonymous said...

Thanks for the blog. While I was cruising the net, I found your blog on article magazine submission womens. There is an article directory that has good information on article magazine submission womens. You can find it here at article magazine submission womens I will be back to this blog again.
Thanks, Larry

 
At 3:51 PM, Anonymous home equity line of credit said...

A

 
At 4:51 PM, Blogger Kim said...

Love your post my friend. I just happened to come across your site.

We have a viral online marketing tool that is a really cool viral online marketing tool.

 
At 5:11 AM, Anonymous Anonymous said...

http://corporatestrategicalliances.com/http://corporatestrategicalliances.com/Effective marketing tools, create a wave of traffic hungry for your product/services with this free set of marketing tools in the download area.

Grab your share of internet income with the most explosive discovery now free to download

 
At 5:18 PM, Anonymous Anonymous said...

Duplicate content, web scraping auto bots, article generation software and article spinning. It seems every scaremonger and opportunist has jumped on the article writing band wagon. I still feel that article writing and article marketing are in their infancy - there is much more benefit to be derived from article writing. None of my web sites have suffered from the alleged, duplicate content filter or penalty - very much the opposite. The Article Writing blog is on course to become the number one source of information on article writing and marketing.

 
At 11:11 AM, Anonymous Anonymous said...

Duplicate content, web scraping auto bots, article generation software and article spinning. It seems every scaremonger and opportunist has jumped on the article writing band wagon. I still feel that article writing and article marketing are in their infancy - there is much more benefit to be derived from article writing. None of my web sites have suffered from the alleged, duplicate content filter or penalty - very much the opposite. The Article Marketing blog is on course to become the number one source of information on article writing and marketing.

 

Post a Comment

<< Home