Hi,
We can performing the data base testing through
qtp we 've to follow the following process.
step1)
create a object for database connetion
set conn=createobject("adodb.connection")
step2)
create a object for recodset
set rs=createobject("adodb.recordset")
here adodb stands for activx dataobject database
step3)
pass the provider
conn.provider="providername"
for ms-acess- microsoft.jet.oledb.4.0
for oracle msdaora.1
step4)
open your database
conn.open "C:\programfiles\hp\quicktestprofessional\samples\flight32.mdb"
step5) open record set write the query
rs.open "select *form orders",con
while not rs.eof
msgbox rs(0)
rs.movenext
wend
Thanks&Regards
prasad k
On Sat, Aug 25, 2012 at 4:20 AM, Tester <[email protected]> wrote:
> Hi All,
>
> Can anybody guide me on that what is process to do database testing using
> QTP in real time?
>
> I know how to read data or table from ms access data base and SQl server ..
>
> Help will be really appreciate .
>
> Thanks,
>
> --
> 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
