Error Message: QODBC3:Unable to connect in Database Administrator

Situation for the customer: The Collective Data server and client were installed on a Windows 2003 server. A system DSN ODBC connection was created to connect to the database. In Data Source Administrator test data source reported a successful connection.

How it was resolved: When attempting to connect either the client or server to the database a QODBC3:Unable to connect error was returned.
The problem was the 2003 server was 64 bit and the DSN had to be created as a 32 bit entry. The program “C:\WINDOWS\SysWOW64\odbcad32.exe” is the 32 bit version of odbc. When this was created the system DSN connection worked. Both the server and client could now connect to the database.