Forum Discussion

Adagio's avatar
Adagio
Frequent Contributor
8 years ago

JDBC request with external driver DB2/AS400

Hello,   I have to connect Testcomplete project with Db2/AS400 database using JDBC request. It requires a driver so I copied the jt400 jar in the 'bin' folder of TestComplete. I'm using the followi...
  • AlexKaras's avatar
    AlexKaras
    8 years ago

    Hi Abhi,

     

    JDBC and .jar files is Java-related stuff. You need to find regular Windows 32-bit ODBC drivers (or OLE providers) (because TestComplete is 32-bit application) for DB2/AS400 and install them. Whether or not will these drivers require Java depends on their implementation and I hope that their respective installers will take care about this.

    Than you will have to create DSN, referencing the database that you are going to use, using ODBC Administrator and use this DSN when specifying connection for .CreateADOConnection(). This is in case ODBC drivers are used. In case of OLE providers, no DSN is required and connection string must be provided for .CreateADOConnection().

     

    P.S. This thread (https://community.smartbear.com/t5/TestComplete-Functional-Web/Can-anyone-help-me-how-to-access-Mongo-database/td-p/86442) may help you with creation of connection string.

  • Adagio's avatar
    Adagio
    8 years ago

    Thank you, Alex! This helped me.

     

    Windows 64-bit machines come with 32-bit and 64-bit odbc drivers so I didn't have to install a new one.

    But for AS400 I'm using IBMDA400 driver which made the connection work. 

     

    appreciate your help!

     

    Thank you

    Abhishek

Adagio's avatar
Adagio
Frequent Contributor

Thank you, Alex! This helped me.

 

Windows 64-bit machines come with 32-bit and 64-bit odbc drivers so I didn't have to install a new one.

But for AS400 I'm using IBMDA400 driver which made the connection work. 

 

appreciate your help!

 

Thank you

Abhishek

nandini9's avatar
nandini9
Occasional Contributor
6 years ago

Hi Abhishek,

I didn't find IBMDA400 driver in my system with windows 64bit. Did you install it seperately or did you get it through OS directly?

If installed, what is the exact driver name you installed?

Kindly let me know 

 

Thanku you,

Nandini

    • nandini9's avatar
      nandini9
      Occasional Contributor
      6 years ago

      Hi Alex,

      Thanks for the response. I've installed IBM DB2 driver from the below link provided. I created a new DSN with the IBM DB2 driver selected and tried to connect. I am facing an issue after clicking on connect. What is the data source name we should mention while creating the DSN?

      Please refer the screenshot of the issue and suggest.

       

      Regards,

      Nandini

      • AlexKaras's avatar
        AlexKaras
        Champion Level 3
        6 years ago

        Hi Nandini,

         

        Important note 1:

        TestComplete and ODBC driver must be of the same bitness. 64-bit flavor of TestComplete is located in the <TestComplete.\x64\bin\ folder, while 32-bit flavor is in the <TestComplete>\bin one. Pay attention to this or TestComplete (and ADO subsystem) will not be able to find your DSN and driver.

         

        Important note 2:

        You must use the odbcad32.exe utility to create and configure DSN for the ODBC driver. Like TestComplete, the bitness of odbcad32 must match the bitness of the ODBC driver. odbcad32 must be started from the <Windows>\System32\ folder if you are working with 64-bit ODBC driver. If you are working with 32-bit ODBC driver, then start odbcad32 utility from the <Windows>\SysWOW64\ folder.

         

        Further refers the screenshot you've posted:

        Use these steps to create a DSN:

        -- start odbcad32 utility;

        -- Switch to the User DSN tab if you like to create a DSN that is accessible to your account only. Switch to the System DSN tab if you like to create a DSN that is accessible to any user logged into the given computer. Note, that in the latter case odbcad32 must be started with the elevated privileges (Run As Administrator);

        -- Click the Add... button, provide whatever name for the DSN and select the appropriate ODBC driver (DB2/AS400 in your case);

        -- Select created DSN in the list, click the Configure... button and provide parameters required by the driver;

        -- Click Test button to test the connection. Test must succeed.

         

        Succeeded connection test means that the DSN exists and is properly configured.

        Now you must craft the OLE DB connection string that you will provide to the ADO subsystem which is used by TestComplete to access databases. https://www.connectionstrings.com/as-400/ provides examples of AS400 connection strings.

        https://community.smartbear.com/t5/TestComplete-Functional-Web/Can-anyone-help-me-how-to-access-Mongo-database/m-p/86460#M20415 may be used as a possible way to create and verify ADO connection string.

        Note: If you installed OLE DB provider instead of ODBC driver, there is no need to create and configure DSN then. Only OLE DB connection string must be created in this case.