>You really should read up on on the various ways MS and VFP have to enable a remote connection to an odbc datasource.
>there is not one 'Right Way'
>DSNless connections are connections which you make dynamically without having to set up an odbc DSN datasource on each workstation... Sure the driver needs to be installed, but configuration of the driver is done with VFP itself.
>Thats one way.
>
>Another is using sqlstringconnect() statment . you pass in your 'connection string ' and here is the hard part, explaining what that is
>its a string which looks has the Driver name, IP Address of the server, database name, user name password, and other options (as necessary / or required by the driver) you pass into sqlstringconnect() that long string, values seperated by ; and then you get back a connnection handle, That handle is how from then on(while you session is still active) your database server knows you are valid, and will return to your application the results.
>

To see a connection string create file dsn and open it in any text editor.

< snip >