>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?

Check SQLConfigDataSource API in the API section here in UT. You can get to that from the forum main page.