Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Flexible connection string
Message
De
29/05/2007 13:31:30
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
29/05/2007 13:27:49
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Divers
Thread ID:
01228078
Message ID:
01229112
Vues:
17
>>>I have the following code to create a SQL Server connection.
>>>
>>>text to lcConnectionString textmerge noshow pretext 15
>>>	DRIVER=SQL Server;SERVER=PAG-SQLSERVER;
>>>	UID=DonF;APP=Microsoft Visual FoxPro;
>>>	WSID=TPD284;DATABASE=TRPSurvey;Trusted_Connection=Yes
>>>endtext
>>>
>>>
>>>The DonF and the TPD284 are specific to me and my PC. How can I query my user's PC to obtain these values for different users and different PCs?
>>
>>Remove them from the connection string. The ODBC driver should fill them for you.
>
>That works from my PC but not from my user's PC. Perhaps the SQL-Server Administrator needs to loosen the security settings?

You're using trusted_connection. Then the connecting user should be a trusted one (domain\username).
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform