Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Trusted Connection Problems
Message
De
10/03/1998 17:58:08
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Trusted Connection Problems
Divers
Thread ID:
00083760
Message ID:
00083760
Vues:
60
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 !!!!
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform