Hi, Thanks for your quick reply.
However I checked with DB Admin and his point was since I am able to connect to My DB via TOAD / SQL TOOLS without facing any problem, he told its not because of TNS.Ora file which leaves me with one option ie, the connection string in QTP.
So I checked an alternative way like creating a dB check point. The connection was successful. But the string was bit lengthy. I replaced this string in my script. Now the connection opened successfully. But I got this below error.
"Command text was not set for the command object.
Line (30):Can Someone please guide me how to first get rid of this above error and then how to correct my Connection string. First aim is to successfully connect to DB. 
However I checked with DB Admin and his point was since I am able to connect to My DB via TOAD / SQL TOOLS without facing any problem, he told its not because of TNS.Ora file which leaves me with one option ie, the connection string in QTP.
So I checked an alternative way like creating a dB check point. The connection was successful. But the string was bit lengthy. I replaced this string in my script. Now the connection opened successfully. But I got this below error.
"Command text was not set for the command object.
Line (30):
Code:
"Set thisObjRS = conn1.Execute(query,,adExecuteNoRecords)". "