Save the connection string in a .txt file. Using the include function call that connection string notepad in Qlikview script. With this connection string notepad, your no need to connect every time to same Database.
Click Create new connection and select ODBC.The Create new connection (ODBC) dialog opens.
Select which data source to use from the list of available data sources, either User DSN or System DSN.System DSN connections can be filtered according to 32-bit or 64-bit.For User DSN sources you need to specify if a 32-bit driver is used with Use 32-bit connection.
Add Username and Password if required by the data source.
If you want to use a name different from the default DSN name, edit Name.
The connection is now added to the Data connections, and you can connect to, and select data from the connected data source.
Editing an ODBC data connection
Do the following:
Click @ on the ODBC data connection you want to edit.The Edit connection (ODBC) dialog opens.
You can edit the following propertieselect which data source to use from the list of available data sources, either User DSN or System DSN.UsernamePasswordName