> conn.open= "Provider=msdaora;Server=server_ip;sid=XXXX;UserId=YYY;Password=XXX;"
What is it? On Tue, Jun 23, 2009 at 12: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 -~----------~----~----~----~------~----~------~--~---
