Connection to Informix not working

[TradSag]

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 able to get data.

Via Informix Connector I'm not able to get the data. The port we are currently using is 9088, so If I don't specify the port I get 

Details: "Microsoft Informix Client: No connection could be made because the target machine actively refused it 172.25.2.111:9089 SQLSTATE=08S01 SQLCODE=-1037"

And if I specify it I get 

Details: "Microsoft Informix Client: Exception of type 'Microsoft.HostIntegration.Drda.Common.DrdaException' was thrown. SQLSTATE=HY000 SQLCODE=-1040"

Does anybody know a workaround to get data from informix?

Many thanks for the support,

Best regarads

[v-xuding-msft · Accepted solution]

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]

Hi,

Many thanks for the anwser! 

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

Best regards