ODBC: Error while trying to connect

[Anonymous]

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

[amitchandak]

@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]

Thanks very much for your help!

I'll investigate your suggestion

Thanks

[v-easonf-msft]

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

[Anonymous · Accepted solution]

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.

🙂