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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only