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