Forum Discussion

AlexBrisebois's avatar
AlexBrisebois
Frequent Visitor
9 years ago
Solved

Connecting to Informix

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.HostInt...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    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.:smileyhappy:

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

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.:smileyhappy:

 

Regards

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi,

 

We are having a very similar issue. how do we go about configuring the client in the way you suggest?

 

thanks