General information
Title:
Problems with Trusted Connection
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 !!!!
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