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.