See Message #553571.

>Hi, gang...
>
>We use a DSN-less approach to connecting for Pass-Thru...so we do a
>
>nConn = SQLSTRINGCONNECT('Driver=SQL Server;Server=my server;Trusted_Connection=YES; UID=USER;PASSWORD=PASSWORD;DATABASE=
>
>Problem is that we have been told that in the future, we may not be able to use the TRUSTED_CONNECTION clause, become some clients may view that as a security issue and additional security maintenance on their database server.
>
>If I take out the TRUSTED_CONNECTION clause, I get the SQL Server Login prompt,with the server name, uid, and password already pre-filled in...all I have to do is click OK on the popup, and I'm in. However, we'd rather not have users see that every time they launch our app...but I don't know how to get around it.
>
>Any clues?
>TIA,
>Kevin

--sb--