Greetings and salutations...
I'm having issues connecting from Microstrategy 2017 Release 3 running in AWS to Informix 11.70.FC9 or 14.10.FC3, running on our servers, both running RHEL, using Informix's CSDK ODBC driver version 4.50.FC3.
I get the following (snipped) messages in the ODBC trace:
ENTER SQLSetConnectAttrW ENTER SQLSetConnectAttrW
SQLHDBC 0x007f963c5fc360
SQLINTEGER 1041
SQLPOINTER [Unknown attribute 1041]
SQLINTEGER -3
EXIT SQLSetConnectAttrW with return code -1 (SQL_ERROR)
SQLHDBC 0x007f963c5fc360
SQLINTEGER 1041
SQLPOINTER [Unknown attribute 1041]
SQLINTEGER -3
ENTER SQLSetConnectAttrW ENTER SQLSetConnectAttrW
SQLHDBC 0x007f5f405f9090
SQLINTEGER 1042
SQLPOINTER [Unknown attribute 1042]
SQLINTEGER -3
EXIT SQLSetConnectAttrW with return code -1 (SQL_ERROR)
SQLHDBC 0x007f5f405f9090
SQLINTEGER 1042
SQLPOINTER [Unknown attribute 1042]
SQLINTEGER -3
Issue occurs when generating a report with Microstrategy or querying from Microstrategy's DB Query Tool. Connectivity with isql works just fine.
Here are the [ODBC] section and DSN entry in the odbc.ini
[ODBC]
Trace=3
TraceFile=odbctrace.out
TraceDll=/opt/mstr/MicroStrategy/install/lib/MYtrcXX.so
InstallDir=/opt/mstr/MicroStrategy/install
IANAAppCodePage=106
UseCursorLib=0
UNICODE=UTF-8
[FOO]
Driver=/opt/informix/lib/cli/iclis09b.so
Description=Report FOO Informix Database IBM Driver
Database=db_name
LogonID=username
pwd=******
Servername=servername
CursorBehavior=0
CLIENT_LOCALE=en_us.utf8
DB_LOCALE=en_us.utf8
TRANSLATIONDLL=/opt/informix/lib/esql/igo4a304.so
(names have been changed to protect the innocent... ^_^ )
We filter by "customer code", and of 100 customer codes, only one of them returns this error.
Help please!
Be well!
Ramón
------------------------------
Ramon Rey
Any opinions I express here are my own and not the views of my employer.
------------------------------
#Informix