Thanks Shalabh and Prasad,
@Shalabh
I Am using ms access db for practice purpose then will move to sql server
and I did lot of googling too..but not get relevant answers ..thats y I
post here..
@Prasad,
I already mention that i know this steps I read data from DB using Scripts
(connection ,recordset and using query )...Now I read data from DB and keep
data
in data table ..now where you put expected data ? with which data you are
going to compare ? How you compare ? where you put Pass /fail result?
On Saturday, August 25, 2012 6:32:44 AM UTC-5, siva prasad wrote:
>
> 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]<javascript:>
> > 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]<javascript:>
>> To unsubscribe from this group, send email to
>> [email protected] <javascript:>
>> 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
