Test Complete14 DB Configuration

[anjali_aggarwal]

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.

[AlexKaras]

Hi,

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

[sonya_m]

Thank you for the suggestion, Alex!

@anjali_aggarwal does this work for you?

[A_Roskoshnyi · Accepted solution]

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"]);

}

[anjali_aggarwal]

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

Provider cannot be found. It may not be properly installed

[A_Roskoshnyi · Accepted solution]

Look here https://www.oracle.com/database/technologies/odac-downloads.html and install the missing components