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

[#1]

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?

[Miguel_Angel_Baeyens]

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

[#3]

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!

[Miguel_Angel_Baeyens]

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