<div>
<a href="http://social.msdn.microsoft.com/Forums/sqlserver/en-US/53f689c1-53c8-45c6-b9ce-c44bce46cd9d/error-creating-dsn-using-odbcconfexe-for-sql-server?forum=sqldataaccess" rel="ugc nofollow">according to this thread</a>, this cannot be done due to the fact that it is very insecure.
</div>


according to this thread [http://social.msdn.microsoft.com/Forums/sqlserver/en-US/53f689c1-53c8-45c6-b9ce-c44bce46cd9d/error-creating-dsn-using-odbcconfexe-for-sql-server?forum=sqldataaccess], this cannot be done due to the fact that it is very insecure.

<div>
But if the windows API can do it (ie. the ODBC tool in Admin Tools) certainly there must be a way I can make a program do the same thing? &nbsp;(how would anybody ever make a program installer that uses ODBC if this wasn't possible?)
</div>


But if the windows API can do it (ie. the ODBC tool in Admin Tools) certainly there must be a way I can make a program do the same thing?  (how would anybody ever make a program installer that uses ODBC if this wasn't possible?)

<div>
Thank you I will look into this.
</div>


<div>
That is an interesting class, but unless I'm missing something, it still does not allow the application of a password..
</div>


That is an interesting class, but unless I'm missing something, it still does not allow the application of a password..

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I can easily use the ODBC control panel in Windows to setup an ODBC connection, including the entry of a password followed by the &quot;test connection&quot;.. &nbsp; I'm referring to SQL Native Client 10, and SQL Server Authentication mode. <br />
<br />
I know how programmatically (VB/C#/C++) add an ODBC entry to the registry, but this doesn't include the password. <br />
<br />
Is it possible to write a small program (compiling the password into the code) that will setup the ODBC registry entry and add the password? This is a utility app for some service folks and I want them to be able to configure and verify the ODBC connection without having to inform them of the password. <br />
<br />
Can this be done?<br />
<br />
Thanks
</div>
</div>


Hi

I can easily use the ODBC control panel in Windows to setup an ODBC connection, including the entry of a password followed by the "test connection"..   I'm referring to SQL Native Client 10, and SQL Server Authentication mode. 

I know how programmatically (VB/C#/C++) add an ODBC entry to the registry, but this doesn't include the password. 

Is it possible to write a small program (compiling the password into the code) that will setup the ODBC registry entry and add the password? This is a utility app for some service folks and I want them to be able to configure and verify the ODBC connection without having to inform them of the password. 

Can this be done?

Thanks

programatically install an ODBC entry including password?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

C++ is an intermediate-level general-purpose programming language, not to be confused with C or C#. It was developed as a set of extensions to the C programming language to improve type-safety and add support for automatic resource management, object-orientation, generic programming, and exception handling, among other features.