You may use DSN-less connection. See for example:
http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b207595>I want to access SQL Server data on a webserver from a local VFP app. Can we connect to the SQL Server database without having a local ODBC connection setup to the database? In other words, we want to create the connection in the code rather than having each user create a local DSN?
>
>Thanks,
>Doug