cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED
Super Contributor

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.

 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Hero

Re: Jenkins - testcomplete script give the error on testExecute machines about the ODBC driver manag

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.


Robert Martin
[Community Expert Group]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Extensions available
Community Hero

Re: Jenkins - testcomplete script give the error on testExecute machines about the ODBC driver manag

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


Robert Martin
[Community Expert Group]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Extensions available
6 REPLIES 6
Super Contributor

Re: Jenkins - testcomplete script give the error on testExecute machines about the ODBC driver manag

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

Super Contributor

Re: Jenkins - testcomplete script give the error on testExecute machines about the ODBC driver manag

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

 

Thanks

Nishchal

Community Hero

Re: Jenkins - testcomplete script give the error on testExecute machines about the ODBC driver manag

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.


Robert Martin
[Community Expert Group]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Extensions available
Super Contributor

Re: Jenkins - testcomplete script give the error on testExecute machines about the ODBC driver manag

@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

 

 

 

Community Hero

Re: Jenkins - testcomplete script give the error on testExecute machines about the ODBC driver manag

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


Robert Martin
[Community Expert Group]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Extensions available
Super Contributor

Re: Jenkins - testcomplete script give the error on testExecute machines about the ODBC driver manag

@tristaanogre 

 

Thank you . It work now.

 

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

 

 

 

New Here?
Join us and watch the welcome video:
6 / 7 API Testing Mistakes Video
Top Kudoed Authors