Forum Discussion

anjali_aggarwal's avatar
anjali_aggarwal
New Contributor
3 years ago
Solved

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.

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

    }

5 Replies

  • AlexKaras's avatar
    AlexKaras
    Champion Level 3

    Hi,

     

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

     

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

    }