Script for testing ODBC or OLE DB connection string without QlikView

[Bjorn_Wedbratt]

The attached vbs script can be used to open a ODBC or OLE DB connection without using QlikView.

This is useful for confirming or ruling out that a Database connection problem is QlikView related.

Environment:

QlikView 

Resolution:

First, you need to know which connection string to use. Examples can be found on https://www.connectionstrings.com/

To run the script:

1. Download the attached testconnect.txt file
2. Edit the script in notepad and change the strConnectionString variable into your own connection string
3. Change the file ending from .txt to .vbs
4. Run the script by double clicking on the file, testconnect.vbs

The script will attempt to open a connection with the supplied connection string and will display a message box that tells you the result.