I was attempting all sorts if things to get rid of the login screen.
I guess a left it there once the connection worked,
besides SQL is suposed to ignore them on acount of the trusted connection.
>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.
B.D.H.