U0003590 DB error

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Affects Release version(s): 6.00A

U0003590 DB error

Environment

Release:
Component: AAUTEN

Resolution

Detailed Description and Symptoms

Installing a 32-bit version of 6.00A onto a Windows 2008 server (64-bit) causes an error message when starting up the WP for the first time.  The connection string is correct.

Investigation

For the components to work correctly, you need to install a 32-bit driver for the ODBC connection, since a 64-bit machine natively uses a 64-bit ODBC connection.

Solution

For this to work you have to invoke the 32 bit ODBC GUI from a dos prompt with this command.  
 
%WINDIR%\SysWow64\odbcad32.exe
 
It is described in more detail here:
http://vijirajkumar.blogspot.com/2009/11/32-bit-driver-installation-for-64bit.html
The allows the Data source (ODBC) to communicate on the server that is 64 bit.