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

Announcements
Join us in Bucharest on Sept 18th 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