Geeks With Blogs

News
Stuart Brierley Integration Management - BizTalk and More

I have previsouly detailed the installation of MySQL, the configuration of MySQL and the installation of the ODBC Data Connector for MySQL.  The reason I needed to install and configure these servers was to provide a test environment for a BizTalk Server 2009 solution I am working on where BizTalk will be querying and populating a MySQL database.

To do this I then needed to install and add the Community ODBC adapter from Two Connect:

"The Community BizTalk Adapter for ODBC is based on the code that was first made available on GotDotNet a few years ago. TwoConnect has refreshed this code, added an installer, and tested it against the latest BizTalk editions. We are releasing the updates back to the BizTalk developer, user and partner community as part of our ongoing community intitiatives. This is the second adapter package that TwoConnect makes available to the community after the very succesful release of the BizTalk WSE 3 adapter a couple of years ago. This adapter is useful in all ODBC based integration scenarios. The following are the new features added and fixes made to the old code base on GotDotNet."

Detailed below are the installation instructions for this adapter.  Downloading and running the installer will load up the splash screen.


BizTalk 2009 Community ODBC Adapter - Splash Screen

Next you need to select the installation location for the adapter.

BizTalk 2009 Community ODBC Adapter - Installation Folder

You then need to confirm the installation following which you will be shown the installation progress.

BizTalk 2009 Community ODBC Adapter - Confirm Installation

BizTalk 2009 Community ODBC Adapter - Installing

Assuming all has gone well you should see the installation complete screen.

BizTalk 2009 Community ODBC Adapter - Installation Complete

Once the installation has completed successfully you will then need to add the adapter to your BizTalk Server.  To do this open the BizTalk Administration console, expand the Platform Settings and right click on Adapters then select New\Adapter.

BizTalk 2009 Community ODBC Adapter - Add New Adapter

You should then be able to select the ODBC adapter and choose the display name for the adapter.

BizTalk 2009 Community ODBC Adapter - Add Adapter Properties

This adapter will then be shown in the BizTalk Administration console.

BizTalk 2009 Community ODBC Adapter - Added

Next I will be looking at using the ODBC Adapter when:

Posted on Wednesday, June 9, 2010 1:24 PM BizTalk Infrastructure and Installation , BizTalk Adapters | Back to top


Comments on this post: BizTalk 2009 - The Community ODBC Adapter: Installation

# re: BizTalk 2009 - The Community ODBC Adapter: Installation
Requesting Gravatar...
thanks for your post on installing the community ODBC Adapter. Do you know if this adapter can be used on x64 bit Biztalk Server? I've installed the adatper sucessfully to c:\program files (x86)\Biztalk Adapter for ODBC (the default). But I'm getting an error in Biztalk Admin 2009 when I create the receive location for the receive port. The error messages are 1) "Exception of type 'system.outofMemoryException' was thrown. and after I click OK I get this error 2) Could not load file or assembly 'file:///C:\Program Files\Biztalk Adapter for ODBC\ODBCAdapterManagement.dll' or one of its dependencies. The system cannot find the file specified.
Left by Sally on Jun 15, 2010 11:49 PM

# re: BizTalk 2009 - The Community ODBC Adapter: Installation
Requesting Gravatar...
Add the ODBC adapter DLL's to the C:\Program Files (x86)\Microsoft BizTalk Server 2009 folder.
Left by Howard Edidin on Jul 23, 2010 8:42 PM

# re: BizTalk 2009 - The Community ODBC Adapter: Installation
Requesting Gravatar...
I have the dlls in the biztalk 2010 folder (x86). but still when tried to create a new one in biztalk admin console, the error is "the application does not exist. not able to gac in the assembly
Left by MOHAN on Dec 16, 2010 8:11 PM

# re: BizTalk 2009 - The Community ODBC Adapter: Installation
Requesting Gravatar...
Will this adapter work in the BizTalk 2010 Server. I have the error when used in the receive location. I configured the location, tried to select the assembly and the schema. The error i got is : "An error occured connecting the BizTalk configuration system. Could you help me on this issue. Thanks
Left by Murtaza on Dec 21, 2010 6:37 PM

# re: BizTalk 2009 - The Community ODBC Adapter: Installation
Requesting Gravatar...
In regards to the message posted by Sally on 6/15/2010...

I had the very same issue on 2010 with an x64 windows 7 box. It required installing the odbc drivers into both c:\program files as well as c:\program files (x86) directories to fix the System.OutOfMemoryException.

Left by Bradley Bell on Feb 03, 2011 2:34 PM

Your comment:
 (will show your gravatar)


Copyright © Stuart Brierley | Powered by: GeeksWithBlogs.net