Hi Mark,

That connection string for the SQLConnect was great! If I leave off the password will it prompt the user for one?

Thanks a million
Jim

>You do not need a SET PATH TO statement in your App's MAIN prg file as long as you are including all the forms, classes, programs, icons, bitmaps, etc., in your project. All these will be compiled into the App and therfore locatable.
>
>You do need the SET PATH TO statement in the MAIN prg so anything you do not compile into the app can be located at runtime. The SETUP wizard will do none of this for you. It will only install files to where you direct it, but the installation paths will not be reflected in your MAIN prg.
>
>You should develop a standard for where files like the data and reports will be. If this is a stand-alone app [e.g., single user installed on local drive], then this is quite easy. Just put the reports in a REPORTS sub-folder off the App installation folder. Put the data files in a DATA sub-folder. Then in your MAIN prg you can then use relative pathing:
>
>SET PATH TO .\REPORTS;.\DATA;.\Whatever_else
>
>For a multi-user system where the data and reports will be on a shared drive, you have to be more creative. I suggest ditching the VFP setup wizard and go to something like InstallShield where you can create registry entries where stuff is installed. Then in your MAIN prg you can read where files were installed and programmatically build your SET PATH statement.
>
>DSN Files? Probably. I recommend you NOT use DSN files to create remote connections. Use SQLStringConnect() to make the connection and provide the connect string yourself:

>goApp.nhandle = "SQLStringConnect(Driver=Microsoft ODBC For Oracle;" ;
>      + "UID=" + alltrim(oLoginForm.txtUserID.Value) + ";" ;
>      + "PWD=" + alltrim(oLoginForm.txtPassword.Value) + ";" ;
>      + "Server=SID;"

>For examples and help with ODBC connections, installed drivers, etc., download my free ODBC DSN class from:
>
>http://www.mctweedle.com/downloads/odbc_dsn.zip
>
>
>
>>Hi Mark,
>>
>>Thanks for the help. I put a path statement in my main program that referenced all of the programs, data, and forms in my project folder. Should I have changed the paths to my distribution folder or does the wizard do that for me.
>>
>>Do I need to add my dsn files in the distribution folder?