General information
Title:
Trusted Connection Problems
Please help !!!!
At home (Win 95 WS to NT Server with SQL Server) my VFP app using SQL
Server must have the "Trusted Connection" box checked in the ODBC setup in order
to not get multiple login prompts. IE, after the initial connection with SQL Server
succeeds, upon opening my remote views I am prompted for my SQL Server login
again for each table. I am having to login four times, then everything works just fine.
That happens only if "trusted connection" is not checked, if it is checked, I login at the
start of the program, connection is established and there are no problems. Now the
problem is that at the client site it is impossible to check the "trusted connection" box in
the ODBC setup. There LAN admin says their setup won't allow it, and an error is
returned. So, leaving it unchecked, you must login four times. Obviously, this doesn't
fly with the client.
Is there something I am missing here ??? I even got added a new connection and new
remote views at the client site, rebuilt and compiled everything and still I get four
logins.
Thanks in advance for your advice !!!!
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