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