<div>
Only way I know of is to import registry keys (or use reg.exe, what is the cmdline equivalent). Best method is to create the DSN once (as a system DSN). and then export following keys:<br />
<br />
HKLM\Software\ODBC\ODBC.In<wbr />i\ODBC Data Sources<br />
HKLM\Software\ODBC\ODBC.in<wbr />i\&lt;&lt;DSN-Na<wbr />me&gt;&gt;<br />
<br />
That way you get all relevant settings. In the first export, you only need the line for the single DSN.<br />
<br />
Either combine both edited exports to one reg file, and import it directly, or use reg import (whole file) or multiple reg add (single key).<br />
<br />

</div>


Only way I know of is to import registry keys (or use reg.exe, what is the cmdline equivalent). Best method is to create the DSN once (as a system DSN). and then export following keys:

HKLM\Software\ODBC\ODBC.Ini\ODBC Data Sources
HKLM\Software\ODBC\ODBC.ini\<<DSN-Name>>

That way you get all relevant settings. In the first export, you only need the line for the single DSN.

Either combine both edited exports to one reg file, and import it directly, or use reg import (whole file) or multiple reg add (single key).



<div>
That is much better, but you need to know the complete driver name (should be easy, it's the same as shown when creating a DSN) and DSN string (can be obtained by looking to <a href="http://www.connectionstrings.com" rel="ugc">www.connectionstrings.com</a>).<br />

</div>


That is much better, but you need to know the complete driver name (should be easy, it's the same as shown when creating a DSN) and DSN string (can be obtained by looking to www.connectionstrings.com [http://www.connectionstrings.com]).


<div>
<div class="content wysiwyg-content">
How to create DSN on local pc (ODBC) using command line ?
</div>
</div>


How to create DSN on local pc (ODBC) using command line ?

How to create system DSN  using command line ?

This topic area includes legacy versions of Windows prior to Windows 2000: Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions including Windows Mobile.

Windows OS

Windows 2000 is an operating system for use on both client and server computers. It is the successor to Windows NT 4.0, and is the last version of Microsoft Windows to display the "Windows NT" designation. Four editions of Windows 2000 were released (Professional, Server, Advanced Server, and Datacenter Server) that shared a core set of features, including many system utilities such as the Microsoft Management Console. All versions of the operating system support NTFS 3.0, Encrypting File System, as well as basic and dynamic disk storage. The Windows 2000 Server family includes support for Active Directory services, Distributed File System and fault-redundant storage volumes.

Windows 2000

Microsoft Windows XP is the sixth release of the NT series of operating systems, and was the first to be marketed in a variety of editions: XP Home and XP Professional, designed for business and power users. The advanced features in XP Professional are generally disabled in Home Edition, but are there and can be activated. There were two 64-bit editions, an embedded edition and a tablet edition.