Everything is done using ODBC Wizard in configing the data source.

Then create a new connection and view with Foxpro environment

>Thanks for the reply. I have a few follow-up questions. I'm a newcomer to SQL Server so these questions may be real basic.
>
>>On my login form, there is a dropdown combo list that displays all of the available ODBC connections on the user machine. I have these filtered to SQL Server types.
>
>I'm assuming your login form is a VFP form you created. How do you populate the record source of the list?
>
>>For SQL Server, I have an automatic process to add a new data source based on small REG file.
>
>Is a REG file something you wrote or something that is a part of ODBC?
>Is there a way to invoke the ODBC wizzard from VFP 6?
>
>Thanks,
>John