>>I have the connection string to pass in with a database login. What needs to be changed to use a trusted login ?
>>
>>This has worked in the past:
>>lcConStr = "DRIVER=SQL Server;SERVER=A23339\SCR_TEST;UID=sail;PWD='big daddy'
>>lhX = SQLStringConnect( lcConStr )
>>
>>I want this to work for all users on our network. We are using SQL 2000.
>>
>>TIA
>>
>>__Stephen
>
>Stephen,
>Instead of passing PWD and UID, use TrustedConnection=Yes.
>
>HTH.
Thanks! that was it.
__Stephen