Richard,

x= SQLSTRINGCONNECT("Driver={SQL Server};Server=yourserver;UID=yourid;PWD=;DATABASE=yourDB;Trusted_Connection=Yes")

the key part is "trusted connection=Yes". You can also ommitt UID and PWD, when you use a trusted connection. BTW: If you create a file DSN with the ODBC Administrator, you can have a look at the available options of the ODBC driver. All (or at least most of them) are stored in the file.

Armin

>i am having difficulty getting connected to my SQL:server from FoxPro6.0
>NOT A TRUSTED Connection
>
>Can anyone help me with the connection string, I am able to connect with a DSN