Ah ha...I think the penny has dropped!
What I think you are about to tell me is that the correct place for the user name and password is not the ODBC datasource but the VFP Connection?

I suppose I have been getting confused and expected to be able to specify parameters to cover everything that is in the SQL ODBC Connection Wizard.

Many thanks

>Hi Paul,
>
>>I don't really understand why I cannot provide the UID & PWD keywords?
>
>ODBC SQL Server driver doesn't support these keywords for the SQLConfigDataSource function.
>
>>Is there a way around this, or is my syntax simply incorrect?
>Don't worry, your syntax is correct. How are you going to connect to the server:
>VFP or ODBC functions?
>
>Alex