You need to update the tns file in the oracle/ your db installation path...
On Jun 23, 9:46 pm, Judy <[email protected]> wrote: > Hi, > > I am using the following code to query DB using ADODB connections. > > I get the following error: > > ORA-12560 TNS :protocol adapter error > > Here is my code: > Dim rs,sql,pkey > set conn=createobject("adodb.connection") > set rs=createobject("adodb.recordset") > ' Oracle client is required to be installed on your box > conn.open= "Provider=msdaora;Server=server_ip;sid=XXXX;User > Id=YYY;Password=XXX;" > sql="select * from t_table" > rs.open sql,conn > Set rs =conn.Execute(sql) > Do Until rs.EOF > msgbox rs("EE_TRANSACTION_ID") > > rs.MoveNext > Loop > > Can some one give me a solution for this. > > Thanks > > rs.close > set rs=nothing > > conn.close > set conn=nothing --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google "QTP - HP Quick Test Professional - Automated Software Testing" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/MercuryQTP?hl=en -~----------~----~----~----~------~----~------~--~---
