Solved: Power BI Informix connection error - Page 2

gansoxd · ‎08-09-2016

Hello,

I am trying to connect to Power BI using IBM Informix Database (Beta) but after I set up my credentials I get the following error:

Details: "Microsoft Informix Client: No such host is known SQLSTATE=08S01 SQLCODE=-1336".

I searched the forum but could not find any same error posts, so I am writing it here.

My connection is OK when I test on Setnet32.

I am currently using Power BI version 2.37.4464.361 64-bit.

I also tried to create and use ODBC but when I do, I get this error:

The DNS specified contains a mismatch architectures between the Driver and Application.

Any help?

gansoxd · ‎09-02-2016

After many unsucessful attempts, I contacted Microsoft support. After some remote access and data mining, the Power BI developer team found the problem:

After a few changes the error I was receiving changed from -1336 to -1040, wich meant EXCSAT_FAILURE, a protocol DRDA error from a Informix server.

Power BI uses DRDA protocol. I was using olsoctcp, I have been using the same port to all Microsoft products I currently use, so I had to change to a port that was configured with DRDA and it finally worked.

I'm replying to solve this topic and for anyone wich may have a similar problem.

View solution in original post

Power BI Informix connection error

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly