SYMPTOM:
The following error message appears when trying to access an instance of Microsoft SQL Server 2008 64 bits in Strategy Intelligence 9.x and 10.x running on IBM AIX 6.1:
Sample Code/Error
Unexepected Error. Database error <>: Connect failed. Error type: Odbc error. Odbc operation attempted: SQLDriverConnect.
Cannot open database "xxxxx.msg" requested by the login.
The login failed. Driver's SQLSetConnectAttr failed OK
CAUSE:
The database name defined on the ODBC.ini file does not exist.
ACTION:
Define the correct database name on the file ODBC.ini.
Third Party Software Installation:
WARNING:
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.