>>>>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

Correct - all you should really need is the driver, server, database, and Trusted_connection parameters. You should be able to eliminate UID and WSID.