<>
This is new to me, but it sounds to like it has created a generic sql connection. It has the driver but its asking you to make the connection every time you access a table. If you create a new sql connection within ODBCthen you can enter the connection details correctly.
I hope this helps.
(You may already be experienced in ODBC connection and I'm teaching you how to suck eggs! ;-) )
>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement