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