Hello Prasad,
i have faced one big problem while i am going to create mysql
connection with QTP, it display a msg that provider can't find, plz check
my driver code
Set con=createobject("adodb.connection")
Set recordst=createobject("adodb.recordset")
con.Provider="Driver={MySQL ODBC 5.1 Driver};Server=127.0.0.1:3306;Database=il;
User=root;Password=123456;Option=3;"
con.Open
plz correct me if m wrong
thanks
Akhalesh yadav
9555717928
On Sat, Aug 25, 2012 at 5:02 PM, Siva Prasad <[email protected]>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
>
--
Akhalesh yadav
+919555717928
+919310680659
--
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
