Test fails in TestExecute on VM

[Kostja]

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]

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]

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