Edit: I found another reg entry that I missed and was able to create the connection via reg file. Thanks.
0 Comments   [ + ] Show Comments


Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.


ODBC connections can basically be created by just copying over the correct HKCU registry keys to the user's hive. Just setup the connection manually on a machine and then export the keys in HKCU\Software\ODBC that are linked to this connection. Beware of the fact that the driver you use needs to be present on the target system too.

Answered 03/15/2012 by: pjgeutjens
Red Belt

Please log in to comment
...or HKLM\Software\ODBC for what ODBC calls a 'System' DSN.
Answered 03/15/2012 by: VBScab
Red Belt

Please log in to comment
Thanks for the responses. One of the things I tried before posting was to import the reg keys but when I go into ODBC connections there's nothing there. I'll see if I can mess with that some more if that's all there should be to it.
Answered 03/15/2012 by: randomscripter
Yellow Belt

Please log in to comment
You can create an odbc connection by running this script. I run this in a batch file when needed
ODBCCONF.exe CONFIGSYSDSN "SQL Server" "DSN=OrderTracking | Description=Order Tracking Data Source | SERVER=sqlserver01 | Trusted_Connection=Yes | Database=dbOrderTracking"
Answered 03/22/2012 by: shigbee
Second Degree Black Belt

  • This does not work for trying to make a 32bit odbc connection on a 64bit machine.
Please log in to comment
Answer this question or Comment on this question for clarity
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja