Forum Discussion

nisgupta's avatar
nisgupta
Valued Contributor
6 years ago
Solved

Jenkins - testcomplete script give the error on testExecute machines about the ODBC driver manager -

cunderw 

TestComplete Version 14.0.3

TestExecute version 14.0.3

 

Ran the TestComplete Script on TestExecute machine . Script use database connection and we are using the DB table variable. On My local machine we are using the Micorsoft ODBC driver and data source name 

 

We ran the script through jenkins on TestExecute  machines and we got the error as shown below. 

 

How we can resolve this ?

 

 

 

 

[TestComplete] Test runner exit code: 2.
[TestComplete] [WARNING] Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
[TestComplete] [WARNING] Errors occurred during the test execution.

 

 

 

  • Yes, the machine that is running TestExecute needs to have the same ODBC drivers installed as on the machine you're doing the TestComplete development on.  Those drivers are part of the OS, not part of TestComplete.

    Additionally, make sure you have the "bitness" correct.  As with TC 12.4 and later, there are two versions of TestComplete/TestExecute installed: a 32-bit version and a 64-bit version.  By default, the 64-bit version is what is installed.  So, if you've installed the 32-bit ODBC drivers but are running the 64-bit version of TestComplete/TestExecute you'll get the same error.

  • Yes, you need to install all the same drivers and assign the same names on your TestExecute machines that you have on your TestComplete.

6 Replies

  • nisgupta's avatar
    nisgupta
    Valued Contributor

    I am using oracle database. Did not find any thing on Smartbear site.

     

    Do I need to install oracle driver installed on TestExecute machine ?

     

    Please update 

     

    Thanks

    Nishchal

    • nisgupta's avatar
      nisgupta
      Valued Contributor

      has any one ran the testcomplete database script on testexecute machine ? Does testexecute machine should also have database driver installed ?

       

      Thanks

      Nishchal

      • tristaanogre's avatar
        tristaanogre
        Esteemed Contributor

        Yes, the machine that is running TestExecute needs to have the same ODBC drivers installed as on the machine you're doing the TestComplete development on.  Those drivers are part of the OS, not part of TestComplete.

        Additionally, make sure you have the "bitness" correct.  As with TC 12.4 and later, there are two versions of TestComplete/TestExecute installed: a 32-bit version and a 64-bit version.  By default, the 64-bit version is what is installed.  So, if you've installed the 32-bit ODBC drivers but are running the 64-bit version of TestComplete/TestExecute you'll get the same error.