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

Reply via email to