Forum Discussion
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 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?
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.
14 Replies
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.
Hi, have you seen this thread? http://community.powerbi.com/t5/Desktop/Connecting-to-Informix/m-p/53829/highlight/true#M21744
Hello arify, thanks for your reply.
Yes, I have seen this thread, but the error from it is SQLCODE=-1037 and my error is SQLCODE=-1366.
I checked everything from this thread but still can't connect.
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
