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?