@Shalabh,Prasad and Jitu,
Thanks all of you for replying it ..I have same doubt as Jitu ..
On Saturday, August 25, 2012 1:07:20 PM UTC-5, Jitu wrote:
>
> 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]> 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
