Courion Tip – ODBC

The confgiuration managers are 32-bit applications.

The 32-bit ODBC Data Soruce Administrator must be used to configure DSNs for 32-bit applications to use.

To run the 32-bit version of the ODBC Administrator, in the Windows Run dialog box, type: %windir%\syswow64\odbcad32.exe

System data sources created in the 64-bit ODBC administrator are only visible to 64-bit applications. System data sources created in the 32-bit ODBC administrator are only visible to 32-bit applications. 32-bit driver data sources are stored in the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI (which is only visible to 32-bit applications) rather than the standard location, HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI.

32-bit ODBC drivers are available to 32-bit applications running in the WOW64 layer, but not to 64-bit applications.

On 64-bit Windows platforms, there is both a 32-bit and a 64-bit version of ODBC Administrator. The 64-bit ODBC Administrator is located in the standard location: Administrative tools in Control Panel. The 64-bit version of the ODBC Administrator only lists 64-bit ODBC drivers and data sources.

Make sure you have the 32 bit version of the ODBC driver.

Additionally, if you are using 7.80 or higher, the 64 bit system hosting IIS and the CF (Connector Framework) must be switched into 32 bit compatibility mode along with having the 32 bit version of the .NET framework. (The CF is where the PMM or Connector that needs ODBC is actually being executed.) This same requirement applies to the CFM (Connector Framework Manager) in order to configure the targets in the Connector Configuration Manager.

See KB from Microsoft …

http://support.microsoft.com/kb/894435

==========

By the way, I switched what I was doing to use the ADO connector instead.

Advertisements

Posted January 25, 2012 by mmdmurphy in Courion Tip

Tagged with

%d bloggers like this: