Hi All,
I have used the below connection string.
Set con=createobject("adodb.connection")
Set rs=createobject("adodb.recordset")
' Open a session to the database
con.Open "provider=SQLOLEDB.1;Data Source=XXXX;Initial
Catalog=XXXX;Trusted_Connection=yes;"
rs.open "Select * from XXXX where ID in (107993)",con
msgbox rs.Fields.Item(1)
Set rs=nothing
Set con = nothing
rs.Close
con.Close
But i am getting error "Cannot open database "XXXX" requested by the login.
The login failed."
Please help me on this.
--
--
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
---
You received this message because you are subscribed to the Google Groups "QTP
- HP Quick Test Professional - Automated Software Testing" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
