Forum Discussion
Power BI Informix connection error
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.
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.
Hi gansoxd:
I am trying to troubleshoot the same error that you originally encountered.
My question is, how and where did you configure a port to use DRDA protocol? Did you have to configure a port on the machine running the Informix database server to use DRDA protocol? Or did you configure a port on the Windows client running Power BI to use DRDA?
Thanks,