>Err ODBC
>
>I have a connection string that looks something like this:
>
>driver={SQL Server};DATABASE=TRADLIVE;SERVER=10.0.1.88;UID=sa;pwd=;
>
>I've taken off the pwd value (i.e. it's not really blank).
>
>Thanks
>Simon

OK:

lcString = [driver={SQL Server};DATABASE=TRADLIVE;SERVER=10.0.1.88;]
lnConnection = SQLSTRINGCONNECT(lcString+[UID=sa;PWD=......]) 
IF lnConnection < 0
   lnConnection = SQLSTRINGCONNECT(lcString+[Trusted_Connection=yes]) 
   IF lnConnection < 0
      AERROR(laError)
      MessageBox([Can not connect to SQL Server. Reason: ]+laError[1,2])
      RETURN
   ENDIF
ENDIF