Forum Discussion

anjali_aggarwal's avatar
anjali_aggarwal
New Contributor
4 years ago

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 drive...
  • A_Roskoshnyi's avatar
    A_Roskoshnyi
    4 years ago

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

    }

A_Roskoshnyi's avatar
A_Roskoshnyi
Contributor
4 years ago

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

}