You can probably use a DSN-less connection to avoid the hassle of setting up ODBC connections on each workstation.

To create a DSN-less connection try this from VFP's command line to create a DSN-less connection to the Northwind database in your local server.

OPEN DATA YourDBC
CREATE CONNECTION MyConnection CONNSTRING 'DRIVER=sql server;SERVER=(local);UID=sa;PWD=;DATABASE=northwind'

Once you have this DSN-less connection in your DBC, you can use it to create remote views or get to the server through SQL pass through. For example:

CREATE SQL VIEW MyView REMOTE CONNECTION MyConnection SHARE AS select EmployeeID, LastName, FirstName from employees

USE MyView
BROWSE

>I need to create a program the will automatically setup the clients ODBC data source name that is used in our Visual Foxpro/SQL Server application. Our DBC holds the data source connection name but it seems that the name must also be set up on the clients harddrive as well. Is there a way of doing this in a setup exe?