Dan,
THANKS!
I'll give it a try.
Ken
>Here it is!
>
>DECLARE INTEGER SQLConfigDataSource in odbccp32 Integer, Integer, String, String
>
>cSettings = "DSN=yourDSNname"+chr(0);
> + "Description=yourDSNnamedescription"+chr(0);
> + "Server=yourservername" + chr(0);
> + "Database=defaultdatabasename" + chr(0)
>
>nResult = sqlconfigdatasource(0,1,'SQL Server', cSettings)
>
>if nResult = 0
> =MessageBox("An error occurred creating the ODBC data source.")
> return .f.
>endif
>
>>Hi,
>>
>>In preparation for distibuting my first SQL app, is there a way through VFP to easily create the DSN I need for my app to connect up to SQL Server? I dread the thought of trying to walk users through using the ODBC control panel. Does the dist. Kit deal with it? Any Installers deal with it? How do you (any of you) handle this?
>>
>>Thanks!
>>Ken
Ken B. Matson
GCom2 Solutions