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

Can you please send us a frown with traces?

 

For traces: Options > Diagnostics > Enable Tracing (Choose Verbose) > Open Traces folder, then reproduce the error. Trace files should appear in the traces folder. Please attach those traces in your frown email.

 

Thanks

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi arify,

I tried to import data directly from Pronto and  was not succeessful. I tried both get data/from IBM informix  and also ODBC connection. I got  following errors. We also contacted our Pronto support and they confiigured the Port but still we get following errors. Could you please help?  is there any email that I can send trace fiules so can have a look? I am not able to attach them here.

 

 

 

Thank you!