Forum Discussion

TradSag's avatar
TradSag
Frequent Visitor
7 years ago
Solved

Connection to Informix not working

Hi,   I'm triying to connect Power BI with Informix database but I'm suffering some issues.   Via ODBC I'm not able to list the tables, but if I include an initial query to a specific table, I'm ...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    7 years ago

    Hi TradSag ,

     

    Please check whether the protocol is DRDA. The Microsoft Connector for Informix supports DRDA only. You need to configure the Informix Server to be “DRDA enable”, and to listen for in-bound client TCP/IP network connections on a “DRDA port” (default port number is 9089). You can reference the similar thread.

     

    Best Regards,

    Xue Ding 

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-xuding-msft's avatar
v-xuding-msft
Community Support
7 years ago

Hi TradSag ,

 

Please check whether the protocol is DRDA. The Microsoft Connector for Informix supports DRDA only. You need to configure the Informix Server to be “DRDA enable”, and to listen for in-bound client TCP/IP network connections on a “DRDA port” (default port number is 9089). You can reference the similar thread.

 

Best Regards,

Xue Ding 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

TradSag's avatar
TradSag
Frequent Visitor
7 years ago

Hi,

 

Many thanks for the anwser! 

 

We will check soon if the proposed solution is working and let you know.

 

Best regards