HI Check the following link it may help u ..
http://p2p.wrox.com/topic.asp?TOPIC_ID=35910

Specify the password also

Regards
Chethana

On Mon, Nov 24, 2008 at 2:48 PM, Biswadidev Patro <
[EMAIL PROTECTED]> wrote:

> Hi Hoks
> I could not get the result when I used
> WSID=<your computer name>
> Please let me know if I was wrong.
> The script I used is..
>
> Set Connection = CreateObject("ADODB.Connection")
> Connection.Open "Provider=SQLOLEDB;Data Source=MYSERVER;Initial
> Catalog=MYDB","WSID=My computer name"
> it pops up a message saying not able to login to the server.
>
> Please help.
>
> Best regard,
> Biswadidev
> On Fri, Nov 21, 2008 at 3:12 AM, Hokrani <[EMAIL PROTECTED]> wrote:
>
>> WSID=<your computer name>
>>
>> -Hoks
>>
>>
>> On Fri, Nov 21, 2008 at 4:24 PM, QTP User <[EMAIL PROTECTED]>wrote:
>>
>>>
>>> Hi Friends,
>>>
>>> Please help me logging in to SQL server with windows authentication
>>> using QTP/VBScript.
>>> I used the following code for SQL user authentication
>>> Set Connection = CreateObject("ADODB.Connection")
>>>
>>> Connection.Open "Provider=SQLOLEDB;Data Source=MYSERVER;Initial
>>> Catalog=MYDB","user","password"
>>> but how to go for Windows Authentication?
>>>
>>>
>>> Cheers!!
>>> Biswadidev
>>>
>>>
>>
>>
>> --
>> >>
>>

--~--~---------~--~----~------------~-------~--~----~
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