Winla
Sep 18th, 2000, 01:56 PM
Hi That is my question.
How to make a trusted NT connection between VB application and SQL7 server?
In other words, when I run my VB application from a NT client, do I still need to give DB userID and password if NT Client has trusted NT authentication.
I know you can setup NT authentication for a NT domain group/user on SQL7 Server. But how to apply this rule in my VB application through ADO connection?
For instance,when creating ADO connection
cmdADO.CoonectionString="Provider=MSDASQL;uid=fred;pwd=xyz; server=sql7;database=pubs"
Both password and UserID must be supplied here.But, I have already set the whole NT group as trusted user in SQL7 server. how to get ride of useid and pwd here and establish a ADO connection to SQL7 server?
How to make a trusted NT connection between VB application and SQL7 server?
In other words, when I run my VB application from a NT client, do I still need to give DB userID and password if NT Client has trusted NT authentication.
I know you can setup NT authentication for a NT domain group/user on SQL7 Server. But how to apply this rule in my VB application through ADO connection?
For instance,when creating ADO connection
cmdADO.CoonectionString="Provider=MSDASQL;uid=fred;pwd=xyz; server=sql7;database=pubs"
Both password and UserID must be supplied here.But, I have already set the whole NT group as trusted user in SQL7 server. how to get ride of useid and pwd here and establish a ADO connection to SQL7 server?