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,
Hi gansoxd:
I am running into the same error that you initially reported (SQLCODE=-1336).
Where and how did you configure a port to use DRDA protocol to resolve the issue? Did you have to configure this port on the machine running Informix database server? Or did you configure this on the client machine running Power BI?
And how exactly did you configure this port? Did you have to load drivers from the Informix SDK to do it?
Thanks,
You might want to post your question and problem to the International Informix Users Group (IIUG) Forums. You can join the IIUG at www.iiug.org (membership is free) and then register for one or more of the forums there. Post you question and you are likely to get answers from experienced Informix users as well as Informix developers from IBM and HCL!
I would respond here, but for some reason I cannot see the OP's question and that previous thread, so I don't know exactly what your problem is. I do not monitor this forum (only saw this in a Google alert), so post to the IIUG Forums your original problem.
You might want to post your question and problem to the International Informix Users Group (IIUG) Forums. You can join the IIUG at www.iiug.org (membership is free) and then register for one or more of the forums there. Post you question and you are likely to get answers from experienced Informix users as well as Informix developers from IBM and HCL!
I would respond here, but for some reason I cannot see the OP's question and that previous thread, so I don't know exactly what your problem is. I do not monitor this forum (only saw this in a Google alert), so post to the IIUG Forums your original problem.
Hello gansoxd
Thanks for your solution.
Could you please post step by step how you change the port? did you do it on SetNet32?
Thank you!
shunsho
