VB App. trusted connection through NT to SQL7

[Winla]

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?

[RIVES]

If you are using OLE DB Provider for SQL server, put 'SSPI' on the Integrated Security property of your connection.

[Winla]

thx for reply.

I have found answer
"trusted_connection=yes"