Forum Discussion
ODBC connection to Informix - no tables
Hi Dedmon
Thanks for your response:
No, I am trying to connect to a remote informix database. What I was saying was that I have successully created a linked server in our sql enviroment using a SYSTEM DSN created earlier. I have now downloaded power Bi desktop to the SQL environment and I am trying to use the same SYSTEM DSN to connect power bi to this remote informix instance. The connection is successful - but I do not get a table listing so that I am able to start querying the tables.
Below is the ODBC Driver I am using to make the connection:
IBM Informix ODBC Driver (64 bit) Version 4.50.00.17629
Community SupportHi pthawkes,
I recommend you update the power bi desktop and the ODBC driver to the latest version. You can get the latest version of ODBC driver from https://www.ciscounitytools.com/Applications/CxN/InformixODBC/InformixODBC.html.
Would you please confirm if the user you map to in the linked server is the same as you used when you connect power bi desktop to informix.
As a workaround, would you please try to use datasource connection provided by power bi desktop:
Best Regards,
Dedmon Dai
Thanks Dedmon
I was trying to avoid using the power bi connector and just use the existing DSN connectivity I already had in place. I have given up trying to make it work and have decided to use the SQL Server Linked server via SSRS to generate the reports I need.
Otherwise thanks for taking the time to help out.
- v-deddai1-msft
Hi pthawkes,
If you have any other questions please let me know.
Best Regards,
Dedmon Dai