
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
.png)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
.png)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
