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

    }

anjali_aggarwal's avatar
anjali_aggarwal
New Contributor

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

Provider cannot be found. It may not be properly installed