>I want to have a VFP application that uses MS SQL, but I do not want to have to setup a DSN on every computer.
>
>Can VFP use MS SQL with having to install anything on the work station (except the Runtime)?
>
>No DSN setup at all.
And when you open a DSN with notepad, you get your connect string. Just put all the lines together, i.e. replace each ";"+cr with just ";" and that's it. You may omit a few pieces from the string if you like: the preferred database to USE is optional; the application is just a description, a courtesy to the DBA - not a showstopper if absent.
Another way to get the connection string in use is to get a handle and then
_cliptext=SQLGETPROP(h,"ConnectString")
Then just paste it in the code where you need it.