+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming)
+--- Thread: Connection string for oracle (Remote DB) in QTP (/Thread-Connection-string-for-oracle-Remote-DB-in-QTP)
Connection string for oracle (Remote DB) in QTP - rohit330 - 02-22-2012
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
RE: Connection string for oracle (Remote DB) in QTP - rohit330 - 02-23-2012
Can anyone help me out for this...