<div>
<div class="content wysiwyg-content">
I need to change multiple ODBC connection - DSNs, can this be done via a script?<br />
<br />
Currently we would have an ODBC connection with the below information<br />
<br />
Name: comrcn02ddsspxx<br />
Server: comrcn02ddsspxx<br />
Database: unifi<br />
Username: report<br />
Password: xxxxx<br />
<br />
It would need to change to this with the server, username and password changing<br />
<br />
Name: comrcn02ddsspxx<br />
Server: lsdad2<br />
Database: unifi<br />
Username: mtg_br_readonly<br />
Password: xxxxxx
</div>
</div>


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

Script to change ODBC connections

A scripting language is a programming language that supports scripts, programs written for a special run-time environment that automate the execution of tasks that could alternatively be executed one-by-one by a human operator. Scripting languages are often interpreted (rather than compiled). Primitives are usually the elementary tasks or API calls, and the language allows them to be combined into more complex programs. Environments that can be automated through scripting include software applications, web pages within a web browser, the shells of operating systems (OS), embedded systems, as well as numerous games. A scripting language can be viewed as a domain-specific language for a particular environment; in the case of scripting an application, this is also known as an extension language.

Scripting Languages

The term 'shell' refers to a general class of text-based command interpreters most often associated with the UNIX and Linux operating systems. Popular shells include Bourne, Debian Almquist (dash), Korn (ksh), Bourne Again (bash) and the C shell family (csh). Some view the DOS 'cmd' prompt as a minimal shell of sorts. It is also possible to install Cygwin on Windows and emulate a full Unix environment with complete shell capabilities. Terminal emulators, such as xterm, GNOME Terminal and OS X Terminal, can be used to access shell.