Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trusted Connection Problems
Message
From
10/03/1998 17:58:08
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Trusted Connection Problems
Miscellaneous
Thread ID:
00083760
Message ID:
00083760
Views:
56
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
Map
View

Click here to load this message in the networking platform