Is it possible to add System DSN data source drivers to ODBC from the Command Line or the do an export/import of your ODBC data source drivers from the command line (a la db2ca's db2cfexp/db2cfimp commands).

I am attemping to write a batch file to automate a client application install, and one of the steps is to add 2 system DSN data source drivers to ODBC, so I need to know how to do this from the command line.

Thank you for any help you can provide,
Francesco Esposito

Do you mean the data source drivers (like a db connector or something) or do you mean actual DSNs? System DSNs are just stored in the registry, so it would be easy enough for you to export the registry key and import it as part of the application install. I don't know how to install the actual drivers...That bit probably varies depending on which drivers you're installing.

Good luck,
-SN

The items found in Control Panel -> Data Sources (ODBC) -> (System DSN Tab), listed under "System Data Sources"

OK, then it shouldn't be too hard. Just find the entry you want in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI in the registry, export it to a .reg file, and import the reg file from the command line using regedit /s.

Good luck,
-SN

Registry editing is disabled on our systems, is there any other way to do it from the command line?

Try the "reg" command. "regini" will process a batch script for you (this comes with the W2k3 resource kit).

Hi,

I dont see the DSN in the control panel applet if i import the reg file. I can see the entries in the registry.