I have used the SQL Adapter Metadata template to create the XML schemas for many projects. I now have to do the same thing where the database is an ODBC connection using IBM Client Access to an AS/400. Is there a way to use the Add Generated Items to perform this, or does that only work with a SQL Server database? Any help or direction would be greatly appreciated. -- Keith
As far as I know this is supported by SQL and not by the adapter as the adapter relies on SQL server's support for XML. I have never used it myself, but I know a community ODBC adapter existed (can't post a link as I can't find anything post GotDotNet!) - have you looked at it? -- Yossi Dahan MVP BizTalk Server http://www.sabratech.co.uk/blogs/yossidahan "Keith" wrote: > I have used the SQL Adapter Metadata template to create the XML schemas for > many projects. I now have to do the same thing where the database is an ODBC > connection using IBM Client Access to an AS/400. Is there a way to use the > Add Generated Items to perform this, or does that only work with a SQL Server > database? > > Any help or direction would be greatly appreciated. > -- > Keith
Hi Keith, If youâre connecting to an IBM DB2 database you may want to consider using DB2 Adpter which is part of BizTalk 2006 Adapter Pack. This is can be installed as part of Host Integration Services 2006. If you have either BizTalk 2006 or BizTalk 2006 R2 then you should be licensed for BizTalk 2006 Adapter Pack â not Host Integration Services 2006 (I got this verified from Microsoft Licensing). The following articles should get you started. Setting Up the BizTalk Adapter for DB2 Using Send Ports http://www.microsoft.com/downloads/details.aspx?FamilyID=0A98A3E5-5D95-4F94-99AA-CE185862B3EE&displaylang=en Setting Up the BizTalk Adapter for DB2 Using Receive Ports http://www.microsoft.com/downloads/details.aspx?familyid=A08D1FA7-6B3D-4B9C-BCE2-38F40D36DAA9&displaylang=en I found them useful but our DB2 database is hosted on Windows 2003 not AS/400 system so the setup wizard was different for me. Also you when using the data access tool to set up your connection will need to be very specific about the configuration. Hope this helps. Enjoy, Samad
