Hi and thanks for the reply,

Unfortunately I didn't post all of my original message regarding the environment. I'm adding this custom form off of the Visual AccountMate (SQL version) menu. Everything is already connected via a 32bit ODBC System DSN connection that Visual AccountMate sets up. I copied an existing form, changed my remote view and added my new fields. I have no idea why it is asking me to give my SQL login and password.

Mysterious indeed.........


>>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