Remote Database connection through QTP

[KavitaPriyaCR]

Hi Prabhat,

Can you try with below connection string?

Code:

objConnection.Open "DRIVER={Oracle in OraClient10g_home1};SERVER=ORCL;UID=xyz;PWD=abc;DBQ=ORCL;DBA=W;APA=T;EXC=F;XSM=Default;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;GDE=F;FRL=Lo;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=Me;CSR=F;FWC=F;FBS=60000;TLO=O;"
AND comment the line:
objConnection.Provider = "OraOLEDB.Oracle"

Any one please correct me if am wrong.