Hi uday,
wecan retrive the data from data base by using adodb
method.
set con=createobject("adodb.connection")
set rs=createobject("adodb.recordset")
con.provider="microsoft.jet.4.0.oledb"(for ms -access)
con.open"dsn=dsnname"
rs.open " provide the query",con
while not rs.eof
msgbox rs(0)
rs.movenext
wend
Thanks&Regards
prasad k
On Wed, Jul 25, 2012 at 9:17 PM, Tamil selvan <[email protected]>wrote:
> Hai uday,
>
> Using Adodb connection and Adodb Recordset, we can retrieve the data from
> the database
>
>
> On Sat, Jul 21, 2012 at 9:36 PM, Ganesh muralidharan
> <[email protected]>wrote:
>
>> Have you tried using Database Query Wizard in QTP?
>>
>> Insert -> Output Value -> Database Output Value
>>
>>
>> On Sat, Jul 21, 2012 at 11:49 AM, uday bhaskar
>> <[email protected]>wrote:
>>
>>> good evening i wrote a script in VB which i want to get the data from
>>> the msaccess but when i am running the code it is not running and getting
>>> error dsn name is not taking but i created dsn name again still error is
>>> coming and this is DSN Name MYDSN please clarify the query
>>>
>>> --
>>> 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
>>>
>>
>>
>>
>> --
>> Regards,
>>
>>
>> Ganesh Muralidharan
>> 'God Never Forgets'
>>
>> --
>> 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
> "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
>
--
prasad kopparapu
+91-9032114331
--
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
