Showcase iSeries ODBC user DSN creation script
Edit: I found another reg entry that I missed and was able to create the connection via reg file. Thanks.
0 Comments
[ + ] Show comments
Answers (4)
Please log in to answer
Posted by:
shigbee
12 years ago
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"
ODBCCONF.exe CONFIGSYSDSN "SQL Server" "DSN=OrderTracking | Description=Order Tracking Data Source | SERVER=sqlserver01 | Trusted_Connection=Yes | Database=dbOrderTracking"
Comments:
-
This does not work for trying to make a 32bit odbc connection on a 64bit machine. - shigbee 12 years ago
Posted by:
pjgeutjens
12 years ago
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.
Kr,
PJ
Kr,
PJ
Posted by:
randomscripter
12 years ago
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.
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.