ODBC setup in a login script

ODBC connections are all in the Registry. So, if you want to push some ODBC connections to remote machines, what you can do is create a REG file with the settings you want, then call the file from the login script.
UserDNSs are in the Registry located at HKEY_CURRENT_USER\Software\ODBC\ODBC.INI
There will be a subfolder for each installed UserDNS configured.
The SystemDSNs are in HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI

The best way to go about this is to set up a machine with all of the correct DSNs that you want to push to other users.
Then, open Regedit, and export those 2 Registry branches. Save each one to its own REG file.
Then place the REG files onto your PDC/BDC (or wherever you keep your login scripts) and put in:
CALLREGEDIT /S odbcfile1.REG
CALL REGEDIT /S odbcfile2.REG

That will push the contents of the two REG files onto the local workstation when the script runs.

Now, you have to make sure that the machines that will get these REG files pushed onto them have the ODBC drivers, otherwise the DSNs will be set up but they won't work!

hope this helps