@Akhalesh,
could you floow the following steps to get proveder
and write this provider name in script.
open notepad-->ave notepad with .udl--->double click on udl file-->click on
provider -->select microsoft oledbprovider for mysql-->click on
next-->enter servaer,username,password-->click on allow saving
password-->click ok.
then righ click on udl file -->open with notepad-->take the providername
and datasource name and wrie this in script,
Thanks&Regards
prasad k
On Sun, Aug 26, 2012 at 9:54 PM, Akhalesh Yadav <[email protected]
> wrote:
> 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
>
--
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
