Solved

Script to change ODBC connections

Posted on 2015-02-18
1
77 Views
Last Modified: 2015-02-19
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
Comment
Question by:gilweber3
1 Comment
 
LVL 69

Accepted Solution

by:
Qlemo earned 500 total points
ID: 40617493
A common way is to export the settings from registry and back. DSNs are stored in HKLM\Software\ODBC\Odbc.ini respective HKCU.
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this tutorial I will show you how to provide a dynamic RTF document on your website generated with data from your database. For this tutorial you will need Microsoft Word or WordPad, WhizBase and Microsoft Access. In this tutorial I will show …
Background Still having to process all these year-end "csv" files received from all these sources (including Government entities), sometimes we have the need to examine the contents due to data error, etc... As a "Unix" shop, our only readily …
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question