ok, I have to connect sql server db and need to check the validations On Wed, Sep 26, 2012 at 2:44 PM, Mangalarapu Srinivas < [email protected]> wrote:
> Tell me what is u r requirement, You want to test DB using QTP or > manually, there are so many concept for DB testing, QTP don't have all > future to test all the DB concepts. > Based on u r need I can suggest. > Regards, > Srinivas Mangalarapu > > > > On Wed, Sep 26, 2012 at 9:16 AM, Santosh Gupta <[email protected]> wrote: > >> Thanks Srini.....any links to learn DB Testing would be >> great.................. >> >> On Tue, Sep 25, 2012 at 7:58 PM, Mangalarapu Srinivas < >> [email protected]> wrote: >> >>> Function OpenConnection(sServer,sDBName,sUserid, sPassword) >>> >>> >>> cnnState=False >>> OpenConnection=False >>> >>> Set cnn = CreateObject("ADODB.Connection") >>> cnn.Open "Provider=SQLOLEDB.1;Password=" & sPassword & " ;Persist >>> Security Info=True;User ID=" & sUserID & ";Initial Catalog=" & sDBName& >>> ";Data >>> Source=" & sServer >>> >>> If cnn.State = 1 Then >>> OpenConnection = True >>> cnnState=True >>> Else >>> OpenConnection = False >>> End if >>> >>> End Function >>> >>> Regards, >>> Srinivas Mangalarapu >>> >>> >>> On Tue, Sep 25, 2012 at 7:47 PM, Santosh Gupta <[email protected]> wrote: >>> >>>> Hi Guys, >>>> >>>> Could you please help me out to find out QTP and MS SQL SERVER database >>>> connectivity and how to proceed with database testing. >>>> >>>> Many Thanks, >>>> S >>>> >>>> -- >>>> 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 >>>> >>> >>> -- >>> 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 >>> >> >> -- >> 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 >> > > -- > 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 > -- 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
