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