cancel
Showing results for 
Search instead for 
Did you mean: 

Test Complete14 DB Configuration

SOLVED
anjali_aggarwal
New Contributor

Test Complete14 DB Configuration

Hi @VeenaDevi , @chinmay ,

 

We are trying to configure TC14 with Oracle 12.1 but we are getting the error : 

error : [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 15:03:18 Normal 0.00
 

It would be great if assistance can be arranged from Lexingtonsoft side to help us resolve this and guide where we are going wrong.

2 ACCEPTED SOLUTIONS

Accepted Solutions
A_Roskoshnyi
Contributor

Re: Test Complete14 DB Configuration

Try something like this:

 

var Conn = ADO["CreateADOConnection"]();
Conn["ConnectionString"] = 'Provider=OraOLEDB.Oracle;Data Source='+DataBase+';User Id='+DBUser+';Password='+DBPasswort+';';
Conn["LoginPrompt"]=0;
Conn["Open"]();

 

try

{

var result = Conn["Execute_"](SQL_STATEMENT);

}

catch(e)

{

Log["Error"](e["message"]);

}

View solution in original post

A_Roskoshnyi
Contributor

Re: Test Complete14 DB Configuration

5 REPLIES 5
AlexKaras
Community Hero

Re: Test Complete14 DB Configuration

Hi,

 

First of all check that bitness of TestComplete and DSN (ODBC driver) is the same.

 

Regards,
  /Alex [Community Hero]
____
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.
https://community.smartbear.com/t5/custom/page/page-id/hall-of-fame
================================
sonya_m
Community Manager

Re: Test Complete14 DB Configuration

Thank you for the suggestion, Alex!

 

@anjali_aggarwal does this work for you?


Sonya Mihaljova
Community and Education Specialist

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
A_Roskoshnyi
Contributor

Re: Test Complete14 DB Configuration

Try something like this:

 

var Conn = ADO["CreateADOConnection"]();
Conn["ConnectionString"] = 'Provider=OraOLEDB.Oracle;Data Source='+DataBase+';User Id='+DBUser+';Password='+DBPasswort+';';
Conn["LoginPrompt"]=0;
Conn["Open"]();

 

try

{

var result = Conn["Execute_"](SQL_STATEMENT);

}

catch(e)

{

Log["Error"](e["message"]);

}

View solution in original post

anjali_aggarwal
New Contributor

Re: Test Complete14 DB Configuration

Hi I have tried this solution but it gave me following error this time : 

Provider cannot be found. It may not be properly installed
Tags (1)
A_Roskoshnyi
Contributor

Re: Test Complete14 DB Configuration

New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors