Create System DSN - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Create System DSN

Neeraj GillNeeraj Gill Posts: 2Member
Hello Myself is Neeraj I am using C#.net. I know how to create system dsn runtime using vb. Is it possible to devlop system dsn for SQL Server runtime using c#.net

please help me to solve this problem

Regards
Neeraj Kumar Gill
Software Engineer
Value One Infotech Pvt Ltd.
Email [email protected]

Comments

  • sanat_kmsanat_km Posts: 1Member
    using Microsoft.Win32;
    using System.Runtime.InteropServices;

    [DllImport("ODBCCP32.dll")]
    private static extern bool SQLConfigDataSource(IntPtr parent, int request, string driver, string attributes);

    private void btnDsn_Click(object sender, EventArgs e)
    {

    string str = "SERVER=MYDBSERVERDSN=MYDSNDESCRIPTION=MYDSNDESCDATABASE=masterTRUSTED_CONNECTION=YES";
    SQLConfigDataSource((IntPtr)0, 4, "SQL Server",str);

    }


    Hi,
    try the above code.I feel it will solve ur problem. Let me know if you have nay specific requirement.
Sign In or Register to comment.