Creating DSN

[143Aroul]

I have done a project in vb6/msaccess/crystall report 8.5.
for the reporting i created ODBC DSN. This normally i suggest the user to goto control panel and select the ODBC ,create a system DSN like that.

But i would like to automise this task like when i install the software the DSN automatically created and the same for when i install the DSN should remove.

anyone can suggest?

Regards
Aroul

 

[cdraycott]

Aroul,

You can use the SQLConfigDataSource routine found in odbccp32.dll. As to where you should use this function you could do it from an InstallShield routine, or from your application the first time it runs.

 

[zemp]

See faq222-273.

zemp