Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Connection string for oracle (Remote DB) in QTP
#1
Not Solved
Hi All,

I wanted to insert a database checkpoint in my Test project. My database is installed in a remote server. (oracle 11g)

How can i connect to it. I tried Insert->Checkpoint->DB checkpoint

From the wizard i selected mannual option (not the microsoft access)

When i clicked next, it is asking for connection string. I got some connection string which can be used for oracle from google. I tired putting that, but after submitting - QTP dialog box comes and it says, "The specified thing may not work" i have a Yes, No and Details button. If i click detail button, i can see "For connecting to oracle a oracle client is required ...etc)"

Actually i have installed oracle 11g on my machine too. I used to connect to my remote db using this.

For this issue when i googled, i got to see we have to set up microsoft odbc driver for oracle. But is it useful for connecting to a remote db. Because, i cant see a hostname/ip field while trying to add the odbc drive (from control panel->Admin tools->data sources-> add new for oracle)

After alot of attempts i tried putting scripts (which i got from some websites) in the expert view page, but its throwing some syntax error.

note: I have loaded the addin "Oracle" while doing this. I believe it should be loaded. Please correct me if am wrong. when i loads this, in the run settings, a new url for oracle we have to provide. What url it expects ? Loading this addin is really required?

Thanks in advance
Reply
#2
Not Solved
Can anyone help me out for this...
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Need script to connect remote machine stalinvanama 1 1,694 09-27-2018, 08:12 PM
Last Post: stalinvanama
  Request Help | Usage of Oracle Add-In for Oracle SQL Developer Nasir Ahmed 3 3,606 06-18-2014, 04:28 PM
Last Post: vinod123
  executing qtp on a remote machine sujaravi123 4 5,068 08-02-2013, 01:22 PM
Last Post: sujaravi123
  Connection to oracle using JDBC and QTP dileep45 0 3,467 07-30-2013, 06:39 PM
Last Post: dileep45
Question DB connection string issue jackmartins 2 6,184 07-05-2013, 02:47 PM
Last Post: Staff

Forum Jump:


Users browsing this thread: 1 Guest(s)