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?