Creating a USER DSN using a batch file?

User DSN? As in ODBC? This info is stored in the registry.

In XP, its \HKEY_CURRENT_USER\Software\ODBC\ODBC.INI

Under this, you'll find ODBC Data Sources where there's an entry for each User DSN Name, and you'll also find a "folder" for each name with the relevant info set there.

So, you can easily prepare a .reg file (export the entire tree from the point I mention above, and strip out anything which isn't relevant), which you can then merge with the registry from the command line ("regedit myfile.reg", or maybe just "myfile.reg" should do it).

This isn't an ideal solution, I know, but its generally the best "quick and dirty" solution to this problem that I've found.

jc

if you want a user-proof deployment method, you could always try something like old INNO setup (found here ). that'll copy your files into the right folders and allow you to script in some reg info too.