Forum Discussion

gansoxd's avatar
gansoxd
Regular Visitor
10 years ago
Solved

Power BI Informix connection error

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 ...
  • gansoxd's avatar
    gansoxd
    9 years ago

    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.

arify's avatar
arify
Microsoft Employee
10 years ago

If trying the recommendations in the other thread didn't work, I don't really have much to add.. Can you send a frown email if you're sure it's not a network issue?

 

There's a smiley on the top left corner or PBI Desktop, right next to it there's a little down-button, you can see the send a frown button in there. Please add the traces as well (if they're too big you can attach as zip)

 

Thanks

gansoxd's avatar
gansoxd
Regular Visitor
10 years ago

Hi, arify, thanks again for your reply.

 

I just sent the frown. I hope it contains something useful.

 

Also, I sent it using the Power BI 32 bits version (at first I was using the 64 bits version but I downloaded the 32 bits version to test as well, sadly it didn't work too).

 

I can send it using the 64 bits version as well,  I don't think it will change too much.

 

Thanks in advance!