What if the app is running fine for a long time then my customer decides to change the server and this new server is named differently? Assume you don't have the source code for the application nor does him has VFP installed in any computer at all.


Luis



>A dsn-less connection string is best because it makes for a self-contained option.
>
>Follow these steps:
>
>1. Create a file dsn.
>2. create a connection in your dbc, choosing to create a connection string.
>3. Click the button next to the textbox where the connection string will go.
> This will provide an opportunity to point to a file-dsn.
>
>Viola, you will see your file-dsn transformed into a connection string. You can then copy/paste the string in program code if you like. In any case, you will not be tied to a specific client-machine setup issue. For example, if somebody decides to monkey around with the DSN settings on the machine, your app won't break if the DSN is removed.
>
>HTH..