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