Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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
Partner - Champion III
Partner - Champion III

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