Forum Discussion

Kostja's avatar
Kostja
Contributor
9 years ago

Test fails in TestExecute on VM

Hi everybody,

 

i wrote the a test just to verify the connection with the database:

 

var Cmd = ADO.CreateADOCommand();
  Cmd.ConnectionString = "Driver={Microsoft ODBC for Oracle};"
                        + "Server=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=199.199.199.199)(PORT=1523))(CONNECT_DATA=(SID=SID)));"
                        + "Uid=user;Pwd=password;"
  
  Cmd.CommandText = "SELECT * FROM table1 WHERE anr = 112640";

  Cmd.Execute();

 

Everything works fine on my computer (TestComplete and TestExecute), but when i execute the same test in TestExecute on the VM, the test fails with following description --> [Microsoft][ODBC driver for Oracle][Oracle]ORA-06413: Connection not open

 

I tried to modify the Firewall and start TestExecute with admin rights, but it didn't help. The needed Drivers are also installed (except for the Oracle in OraClient11g_home1)

 

Can anybody give me an advice what the causes TestExecute to fail on the VM?

 

The VM runs with Windows 8.1 Pro. My Computer runs with Windows 10 Pro.

  • Marsha_R's avatar
    Marsha_R
    Moderator
    9 years ago

    Sounds like the VM can't see the machine where the database lives.  Try it without TE, ping or some other connection make sure those two machines can communicate first.

    • Kostja's avatar
      Kostja
      Contributor
      9 years ago

      The solution was to configure the Oracle driver properly and to set a System DSN variable.