Create a System DSN ODBC Connection to SQL Server on Windows 7 using C#

Posted on 2011-10-04
Last Modified: 2013-12-16
Hello Experts,

I set up a DSN connectiosn in windows (ODBC Data Source Administrator) quite often to connect to my SQL Server Databases...

I would like to do this programatically using C# on Windows 7 machines.

Does anyone know how to do this?

Question by:Saxitalis
    LVL 16

    Expert Comment

    by:Kalpesh Chhatrala
    you can use SQL Server with C# without using DSN. then why do you create DSN in System ?

    any Special reason ?

    check below related thread.
    LVL 69

    Accepted Solution


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Recently while returning home from work my wife (another .NET developer) was murmuring something. On further poking she said that she has been assigned a task where she has to serialize and deserialize objects and she is afraid of serialization. Wha…
    A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    This video discusses moving either the default database or any database to a new volume.

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now