Click here to Skip to main content
15,510,484 members
Articles / Programming Languages / C#
Posted 21 Mar 2012

Tagged as


11 bookmarked

Create SQL DSN in C#

Rate me:
Please Sign up or sign in to vote.
4.36/5 (6 votes)
7 Mar 2014CPOL
Create the SQL Data Source name Programmatically


This tip is about creating DSN through C#

Using the code

In order to create a DSN in C#, we just need to write few lines of code. Consider the code below:

            string ODBC_PATH = "SOFTWARE\\ODBC\\ODBC.INI\\";     
            string driverName = "SQL Server";
            string dsnName = "DSNfromCode";
            string database = "MyDBName";
            string description = "This DSN was created from code!";
            string server = "";
            bool trustedConnection = false;

            // Lookup driver path from driver name         
            string driverPath = "C:\\WINDOWS\\System32\\sqlsrv32.dll"; 
            var datasourcesKey = Registry.LocalMachine.CreateSubKey(ODBC_PATH + "ODBC Data Sources");         
            if (datasourcesKey == null) 
throw new Exception("ODBC Registry key does not exist"); 
            datasourcesKey.SetValue(dsnName, driverName);          
            // Create new key in odbc.ini with dsn name and add values        
            var dsnKey = Registry.LocalMachine.CreateSubKey(ODBC_PATH + dsnName);        
            if (dsnKey == null) 
throw new Exception("ODBC Registry key for DSN was not created"); 
            dsnKey.SetValue("Database", database);         
            dsnKey.SetValue("Description", description);         
            dsnKey.SetValue("Driver", driverPath);         
            dsnKey.SetValue("LastUser", "sa");         
            dsnKey.SetValue("Server", server);         
            dsnKey.SetValue("Database", database);
            dsnKey.SetValue("username", "sa");
            dsnKey.SetValue("password", "system123#");
            dsnKey.SetValue("Trusted_Connection", trustedConnection ? "Yes" : "No");

Please note, here I am using the hardcoded values. you can pass these values through the user input also or as per your requirement. Note the following lines in the code:

string dsnName = "DSNfromCode";
string database = "MyDBName";
string description = "This DSN was created from code!";
string server = "";
bool trustedConnection = false;


1. dsnName is the name of the DSN that you want to create.

2. database name is name of your Database.

3. description and server is the description and Database IP respectively.

4. trustedconnection "false" indicates SQL server Authentication. If it's true then Authentication mode is Windows.

Next, you need to pass the driver (sqlsrv32.dll).

At last, pass all these values to "SetValue" (see last few line of code). I have also pass the SQL username and Pwd hardcoded. you can also pass thse through user inputs.

Points of Interest

If you do not pass the LastUser, it will enter Windows User.


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By
Software Developer (Senior)
India India
Linkedin profile:

Comments and Discussions

SuggestionPInvoke Pin
TcJoshJohnson7-Mar-14 8:33
TcJoshJohnson7-Mar-14 8:33 
QuestionAccess to the registry key 'HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources' is denied. Pin
wayvirgo4-Oct-12 7:22
wayvirgo4-Oct-12 7:22 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.