Using a SQL Adapter in BizTalk Server 2004

Mauricio Ritter

Rate me:

4.92/5 (28 votes)

31 Jan 200614 min read

286K

This article is a how-to guide to using SQL Server adapters in BizTalk Server 2004. It'll show how to configure the ports, messages, and orchestrations to use this BizTalk resource.

ordermanager_src.zip
- OrderManager
  - bin
    - Deployment
    - Development
      - OrderManager.dll
      - OrderManager.pdb
  - CompleteOrder.xsd
  - IncompleteOrder.xsd
  - IncompleteOrder_To_SQLRequest.btm
  - obj
    - Deployment
      - temp
    - Development
      - OrderManager.dll
      - OrderManager.pdb
      - temp
  - OrderManager.btproj
  - OrderManager.btproj.user
  - OrderManager.sln
  - OrderManager.suo
  - ProcessOrder.odx
  - SQL_To_CompleteOrder.btm
  - SQLService.xsd

Microsoft Visual Studio Solution File, Format Version 8.00
Project("{EF7E3281-CD33-11D4-8326-00C04FA0CE8D}") = "OrderManager", "OrderManager.btproj", "{B72EB591-2377-496B-89D3-7328868FF377}"
	ProjectSection(ProjectDependencies) = postProject
	EndProjectSection
EndProject
Global
	GlobalSection(SolutionConfiguration) = preSolution
		Deployment = Deployment
		Development = Development
	EndGlobalSection
	GlobalSection(ProjectConfiguration) = postSolution
		{B72EB591-2377-496B-89D3-7328868FF377}.Deployment.ActiveCfg = Deployment|.NET
		{B72EB591-2377-496B-89D3-7328868FF377}.Deployment.Build.0 = Deployment|.NET
		{B72EB591-2377-496B-89D3-7328868FF377}.Deployment.Deploy.0 = Deployment|.NET
		{B72EB591-2377-496B-89D3-7328868FF377}.Development.ActiveCfg = Development|.NET
		{B72EB591-2377-496B-89D3-7328868FF377}.Development.Build.0 = Development|.NET
	EndGlobalSection
	GlobalSection(ExtensibilityGlobals) = postSolution
	EndGlobalSection
	GlobalSection(ExtensibilityAddIns) = postSolution
	EndGlobalSection
EndGlobal

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Written By

Mauricio Ritter

Web Developer

Brazil

Mauricio Ritter lives in Brazil, in the city of Porto Alegre. He is working with software development for about 8 years, and most of his work was done at a bank, within a home and office banking system.
Mauricio also holds MCSD, MCSE, MCDBA, MCAD and MCT Microsoft certifications and work as a trainer/consultant in some MS CTEC in his city.
Mauricio also works in his own programming site, aimed to Brazilian Developers: http://www.dotnetmaniacs.com.br

In his spare time he studys korean language...

Using a SQL Adapter in BizTalk Server 2004

License

Comments and Discussions