Forum Discussion

tristaanogre's avatar
tristaanogre
Esteemed Contributor

I'm not incredibly familiar with using Oracle in TestComplete but the error message you received is similar for other database types.  Essentially, there are certain client applications and drivers for Oracle that are necessary for connecting a machine to an Oracle database. TestComplete does not have these built in but use whatever is already installed in the operating system.  So, if I'm reading this correctly, before you can use the Oracle database as a DB Table variable in TestComplete, you need to make sure you at least have Oracle client drivers and so forth installed on your workstation.

 

Hope this helps.

  • Kostja's avatar
    Kostja
    Contributor
    9 years ago

    Hi,

     

    don't know if it might help you, but i also connect to an Oracle db and i use the 'Microsoft ODBC for Oracle' driver (it was already pre-installed on my platform, seen under 'Administrative Tools') with the connection string from here --> http://www.connectionstrings.com/microsoft-odbc-for-oracle/

     

    In my case everything works fine and i can store a db execute a query etc.

     

    Greetings

     

     

    • DenisMedvedev's avatar
      DenisMedvedev
      Contributor
      9 years ago

      Can you share code example with opening connection and using query?

      • Kostja's avatar
        Kostja
        Contributor
        9 years ago

        Hi,

         

        here is an example i use to get an automatically created number to verify it afterwards:

         

        var Cmd = ADO["CreateADOCommand"]();
  
  Cmd["ConnectionString"] = "Driver={Microsoft ODBC for Oracle};"
                          + "Server=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=123.456.789)(PORT=1234))(CONNECT_DATA=(SID=linux)));"
                          + "Uid=user;Pwd=pw;"
  
  Cmd["CommandText"] = "SELECT * FROM table1 WHERE nr = 112602;
  
  var x = Cmd["Execute"]();