Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

No database selected error when loading data through odbc connection to mysql

I loaded my database through ODBC connection and was able to select my tables just fine.  When I click "load data" it says no database selected. I followed the online video for this, what am I missing?

1.JPG2.JPG

3 Replies
MVP
MVP

Re: No database selected error when loading data through odbc connection to mysql

Hi Aaron,

There are two LIB statements in your script, one should work fine. In the DSN definition, did you specify the database?

You can also add a

SQL USE databasename;

after the LIB statement.

Miguel

Not applicable

Re: No database selected error when loading data through odbc connection to mysql

This appeared to work.  I am surprised the database line was not inserted automatically since I selected the database with the "select data" button in the first place.  Thank you for your help!

MVP
MVP

Re: No database selected error when loading data through odbc connection to mysql

Glad to help.

However, if that happens to you more often, I'd suggest to log a case with Support if you are using Qlik Sense server with as much information as possible from your environment.

Miguel