>Environment: SQL Server 7.0 (desktop), VFP 6.0, Win 98
>
>I have a VFP form that is using a remote view to add/edit/delete data in SQL Server. Whenever I execute the form from the menu it always gives me "connection failed" and then prompts me for the SQL Server login, I provide the login, the form comes up and everything works great.
>
>How can I avoid the SQL Server prompt, I know this must be a simple switch, but I haven't found it yet.
>
>Thanks in advance for any help !!!!!
>
>J.C.
>Genesys Technologies

Have you made a named connection through Control Panel - ODBC with the connection string. If you do this and point your remote view to the 'named' connection you have created, you should get round this problem.

Don't know how you would distibute this solution though. ;-)


Jason