Remote Database connection through QTP

[cdesserich]

Prabhat, as far as I know, through ODBC you have to have the "server" defined in your Oracle client's tnsnames.ora file. It can be found in a similar path to this:

C:\oracle\product\10.2.0\client\NETWORK\ADMIN\tnsnames.ora

Using a text editor, some code similar to the below will have to be added to the file and the correct values added for your system.

Code:

<<This would be the newly defined server name e.g. "TESTDB">> =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = <<host name or IP of server>>)(PORT = 1521))
    (CONNECT_DATA =
      (SID = <<sid of server>>)
      (SERVER = DEDICATED)
    )
  )

The TNS code get worse if there is load balancing and such...