Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

How can SilkTest connect to more than one SQL Database through one DSN connection?

How can SilkTest connect to more than one SQL Database through one DSN connection?

Firstly when you set up your ODBC connection to the SQL database.

Do not set a default database but leave this blank. In your SilkTest script you can set up a different handle to each database you want to connect to by specifying the "DATABASE=" parameter in your connection string.

So if you have two databases e.g. "Data1" and "Data2" and an ODBC connection called "SQLTEST" you could do the following;

  string ReadData

    // Set up blank Database Handles

    HDATABASE hdbc1,hdbc2
    // Set Up Blank Sql handle

    HSQL hstmnt

    // Set up database handles to your databases

    hdbc1 = ("DSN=SQLTEST;DATABASE=Data1")
    hdbc2 = ("DSN=SQLTEST;DATABASE=Data2")

    // Execute Sql statements on each database

    hstmnt = DB_ExecuteSql (hdbc1, "Select * FROM Table1")
    while (DB_FetchNext (hstmnt, ReadData) == TRUE)
        print (ReadData)

    hstmnt = DB_ExecuteSql (hdbc2, "Select * FROM Table2")
    while (DB_FetchNext (hstmnt, ReadData) == TRUE)
        print (ReadData)


Old KB# 22166

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2013-02-15 19:28
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.