Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 137
  • Last Modified:

Script to change ODBC connections

I need to change multiple ODBC connection - DSNs, can this be done via a script?

Currently we would have an ODBC connection with the below information

Name: comrcn02ddsspxx
Server: comrcn02ddsspxx
Database: unifi
Username: report
Password: xxxxx

It would need to change to this with the server, username and password changing

Name: comrcn02ddsspxx
Server: lsdad2
Database: unifi
Username: mtg_br_readonly
Password: xxxxxx
0
gilweber3
Asked:
gilweber3
1 Solution
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
A common way is to export the settings from registry and back. DSNs are stored in HKLM\Software\ODBC\Odbc.ini respective HKCU.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now