SYMPTOM:
When connecting to a Sybase IQ database using Strategy DB Query tool 10.x, the error "Database server not found" may be encountered as shown below:
Additionally, it is confirmed that the 'DatabaseName' and 'CommLinks' parameters in the ODBC.ini file are correctly set.
CAUSE:
One possible cause is that the 'EngineName' parameter is set incorrectly in the odbc.ini file.
ACTION:
Confirm and correct the EngineName parameter in the odbc.ini file to resolve this error. 'EngineName' should be the name of the database server to connect to.
For additional details on setting up DSN to Sybase IQ, refer to the product manual, Strategy Installation and Configuration Guide > Connection to Databases: ODBC and DSNs
