Verifying the IBM Data Server Driver package

You must verify that install the IBM Data Server Driver package after sequencing the IBM Db2® Data Server Driver image in order to successfully run your Microsoft Application Virtualization (MS App-V) platform.

Procedure

  1. Check where the package is installed:
    1. Right click on the IBM Data Server Driver package shortcut in the Start menu.
    2. Select open file location to check where the package is installed.
  2. Verify the that the IBM Data Server Driver is within the App-V client:
    1. Right click on the db2cli App-V shortcut created and open its file location.
    2. Verify that in the root VFS folder, the IBM Data Server Driver folder is present and all subdirectories such as .bin, .cfg, and .java are under it. You can give write permission to the IBM Data Server Driver folder to make modification to files like db2dsdriver.cfg or to take db2 traces.
  3. Run the db2cli validate command from the App-V command prompt shortcut created in the IBM Data Server Driver/bin folder to test connectivity from ODBC:

    db2cli validate -dsn <dsn name> -connect -user <user> -passwd <password>

    db2cli validate -dsn <dsn name> -connect -odbcdsn -user <user> -passwd <password>

  4. Run the testconn from App-V command prompt to test .net driver connectivity:

    testconn20.exe -dtc "userid=<uid>;password=<pwd>;database=<dbname>

    testconn40.exe -dtc "userid=<uid>;password=<pwd>;database=<dbname>

  5. To test CLPPlus and JCC connection, launch clpplus.bat from the IBM Data Server Driver/bin folder

    Clpplus > conn UserID/Password@HostName:446/DB Name

What to do next

Microsoft recommends using the App-V connection group to test the other sequenced applications with the App-V IBM Data Server Driver package. It generates connections between virtualized applications, which allows the applications to communicate with each other while they run in the virtual environment.