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.