Talk, talk and more talk about BizTalk

Where’s my Sybase ODBC driver?

I am currently working with a customer that use Sybase (remember them?) Adaptive Server Enterprise, as their primary database environment.  Sybase and Microsoft originally co-developed the early versions of SQL Server, so there are still enough similarities that it “feels” like working with MS-SQL, albeit an older version.

However, the BizTalk Adapters are not so forgiving, and will not work with ASE.  Our solution was to use the open-source ODBC Adapter provided by TWOCONNECT (link).  This was when we ran into trouble.

Opening the ODBC Data Source Administrator to add a new System DSN left me with only 2 available options in the Driver’s tab:


Digging into things a little, I determined that the Sybase drivers are 32-bit only, but my development machine is running 64-bit Windows.  In order to be able to configure 32-bit ODBC drivers, you need to run the 32-bit version of ODBC Data Source Administrator.  This can be done by entering “C:\Windows\SysWOW64\odbcad32.exe” from the Run prompt:

Now the full range of “legacy” 32-bit ODBC drivers and data sources are available:

One final issue to consider.  If you have configured and wish to use a 32-bit DSN, you will need to run any associated Send and Receive Ports within the context of a 32-bit Host Instance.


November 19, 2012 - Posted by | BizTalk | , , ,

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: