ODBC Data Source deployment

[jep60]

I am attempting to deploy a VB6 application that uses an Access 2000 database via ODBC. I am using a reference to the ODBC DSN for the connection. I plan to deploy this application on all Win95 versions and greater. How can I create an ODBC Data Source on the target machine during installation?

Thanks

 

[frankrizzojerky]

Just do a registry insert. Since I dont have a win9x machine around I dont know where odbc info is stored in win9x. But it is probably under hk local machine, microsoft, odbc connections or something. You then just do an export and then you can push the reg export with a batch file or something.

 

[wibbe]

Use Install Sheld or WISE to create a MSI package of oure applikation. Then you have a function for creating ODBC DNS and you will support automatic software recovery.
This is almost required then you start to use W2k and AD anyway.

// Wibbe