Automation of test for driver specific test in OE dataserver

In OE dataserver, we connect to MS sql server by using DSN of particular odbc driver. Some features are also supported with specific driver. If you want to run specific test only for a particular odbc driver then you can conditionalize the script as per your requirement.

If you want to conditionalize your test script for particular drive then you can query for driver details from schema holder  using below ABL-

for each _db:

display _Db-misc2[1].

         for e.g. p2sqls27.dll

It will return the driver dll name by using which you can know whether it is a SNAC, SQL or native driver.

Same way if you want to know the driver version you can use below ABL-

for each _db:

display _Db-misc2[2].

        for e.g.  0.7.15.0254 (B0248, U0172)

To get the odb_ctl.i number value for specfic driver use below ABL-

for each _db:

display _Db-misc2[4].

       for e.g. 11,13,14,20,23,33,36,39,

Apart from that you can use below ABL for specific details from schema holder-

For dsn name:

       for each _db:

      display _Db-addr.

For quoted information:

       for each _db:

      display _Db-misc2[3].

For logical db name:

          for each _db:

          display _db-name.

For logical db type:

          for each _db:

          display _db-type.

For MS Sql server version:

          for each _db:

          display _Db._Db-misc2[5] .