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?
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.
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!
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.
Retrieving data ...