Forum Discussion

pthawkes's avatar
pthawkes
New Member
6 years ago

ODBC connection to Informix - no tables

I have a DSN set up on the machine and I am able to use the DSN to connect via SQL server...the connection allows me to see the tables of the informix DB With power BI I am using the ODBC option and...
Need Help
v-deddai1-msft's avatar
v-deddai1-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi pthawkes,

 

Are you trying to connect to sql server data source via odbc driver? If anything is misunderstood, please tell me.

 

>>ERROR [IM001] [Informix][Informix ODBC Driver]Driver does not support this function.\r\nStackTrace:\n

 

What is the version of odbc driver and desktop are you using? Would you please try to update it to the latest version? You can check it in the screenshot below:

 

Use win+R and type ODBCAD32 in it

 

 

Where did you create DSN? Please create DSN in System DSN. Here is the similar thread for your reference: https://community.powerbi.com/t5/Power-Query/Personal-Gateway-X-On-Premises-Gateway/m-p/70945#M5526

 

Best Regards,

Dedmon Dai

  • pthawkes's avatar
    pthawkes
    New Member
    6 years ago

    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

    • v-deddai1-msft's avatar
      v-deddai1-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi 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

      • pthawkes's avatar
        pthawkes
        New Member
        6 years ago

        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.