How to Create an ODBC DSN Using QuickTest Professional

QTP/UFT Published on:
UFT UPdate

Here are the steps to install an ODBC driver for InterSystem's Cache database and code to connect and execute a query in QTP.

1. Install the ODBCDriver.exe Client ODBC Driver Install Instersystems
2. Go to your Control Panel\Administrative Tools\Data Sources (ODBC)
3. Go to User DSN and click on Add:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

5. Fill in the following info:

 

 

 

 

 

 

6. Open QTP and enter the following code:

3 responses to “How to Create an ODBC DSN Using QuickTest Professional”

  1. […] The downside to this approach is that for every machine on which you plan to run your QTP test on you will also need to setup a DSN on that machine with the same info that you created earlier. For an example of setting up an ODBC DSN, check out my post entitled “How to create a ODBC DSN Connection.” […]

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

UFT UPdate