Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

ODBC: Error while trying to connect

Hi All,

I'm a newbie to Power BI (Desktop) and first time trying to connect to an SQLite database.

I set up the connection to the database by following steps provided here:

https://www.biinsight.com/visualise-sqlite-data-in-power-bi/

The database did not require sign in.

 

However, when I tried to connect, I got the following message:

Details: "ODBC: ERROR [HY000] out of memory ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed"

 

Can anyone assist me?

Thanks

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Thanks very much for your reply and assistance.

    I'm still trying to sort it out but I'm sure it just what you suggested.

    🙂

     

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , Based on SQL lite version check the Driver version. Typically "out of memory" ERROR should come when a query runs. It is coming at a time connection so seems like a correct driver issue.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks very much for your help!

      I'll investigate your suggestion

      Thanks

      • v-easonf-msft's avatar
        v-easonf-msft
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi, Anonymous 

        I'm sorry. I can't reproduce your issue.I check all steps in the document your mentioned ,everything works well in my current environment.

        As mentioned by amitchandak  ,please check the version of your powerbi desktop and  Sqlite ODBC driver.Make sure you install the right versions of the driver ( x32 bit or x64).

         

        You aslo can  raise it to the support team for better advice.

         

        Best Regards,
        Community Support Team _ Eason