Why would you have both a trusted connection and a userid and password?
Jim
>I was getting the login screen to but it stoped after i included the "Trusted_Connection=yes" on the connection tring.
>I don't know if this is the correct awnser i hpe it helps.
>
>Bernardo
>
>>Even if I do an on error for error trapping, I still get the SQL Server login screens when the connection fails. I need the SQL login screens to not appear because the user is going to be able to enter the elements of the connection string. How do I prevent the screen from appearing?
>>
>>Jim
>>
>>>my string is like this:
>>>
>>>"DRIVER=SQL Server;SERVER=TECH03;UID=bdehoyos;APP=Microsoft Visual FoxPro;WSID=TECH03;DATABASE=testedi;Trusted_Connection=yes"
>>>
>>>by including UID , Trusted_Connection=yes and the database and server name on it i had no problems.
>>>
>>>btw some error traping might be good just to be sure .
>>>
>>>Bernardo.
Thanks
Jim