Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to end the database connection

Hi all - I'm using a template for a QV doc that was set up for a database connection. I want to use this as a template but I need to import and excel spreadsheet instead for the moment. How do I kill the database connection? When I upload the Excel spreadsheet and reload I get ODBC errors.

2 Replies
Gysbert_Wassenaar

Comment out the ODBC CONNECT statement by adding two slashed in front of the line: // ODBC CONNECT ...etc


talk is cheap, supply exceeds demand
jeffmartins
Partner - Creator II
Partner - Creator II

Hi carickhoffc,

You can use the disconnect statement that terminates the current ODBC/OLEDB/Custom connection.

Example:

disconnect;

Regards