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

[nisgupta]

@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.

[nisgupta]

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]

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

Thanks

Nishchal

[tristaanogre · Accepted solution]

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.

[nisgupta]

@tristaanogre 

thank you for the updates 

So

I need to install the same driver on TestExecute machine which is same as that of TestComplete machine?

I need to create Data Source name also on TestExecute ?

I have attached the oracle drivers information which is on TestComplete machine.

Plese update 

Thanks

Nishchal

[tristaanogre · Accepted solution]

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

[nisgupta]

@tristaanogre 

Thank you . It work now.

I have to set up the testcomplete machine with the same oracle driver and same data source name .