Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I use the Informix beta connector in PBI Desktop to connect to an on-premise Informix Database
I get this error:
Details: "Microsoft Informix Client: Exception of type 'Microsoft.HostIntegration.Drda.Common.DrdaException' was thrown. SQLSTATE=HY000 SQLCODE=-1040"
However, I can connect with ODBC.
Any suggestion?
Thanks,
Solved! Go to Solution.
Hi @AlexBrisebois,
The error indicates an EXCSAT_FAILURE, a protocol DRDA error from a Informix server.
IBM Informix Server supports multiple client-to-server network connectivity protocols: (1) proprietary IBM Informix client-to-server protocol; and (2) industry-standard Distributed Relational Database Architecture (DRDA). The IBM ODBC Driver for Informix supports both. The Microsoft Connector for Informix supports DRDA only.
You need to configure the Informix Server to be “DRDA enabled”, and to listen for in-bound client TCP/IP network connections on a “DRDA port” (default port number is 9089). Here is a similar thread for your reference.
Regards
Hi @AlexBrisebois,
The error indicates an EXCSAT_FAILURE, a protocol DRDA error from a Informix server.
IBM Informix Server supports multiple client-to-server network connectivity protocols: (1) proprietary IBM Informix client-to-server protocol; and (2) industry-standard Distributed Relational Database Architecture (DRDA). The IBM ODBC Driver for Informix supports both. The Microsoft Connector for Informix supports DRDA only.
You need to configure the Informix Server to be “DRDA enabled”, and to listen for in-bound client TCP/IP network connections on a “DRDA port” (default port number is 9089). Here is a similar thread for your reference.
Regards
Hi,
We are having a very similar issue. how do we go about configuring the client in the way you suggest?
thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |