using System;

using System.Linq;

using System.Runtime.InteropServices;

​

namespace ConsoleApp16

{

    enum RequestFlags : int

    {

        ODBC_ADD_DSN = 1,

        ODBC_CONFIG_DSN = 2,

        ODBC_REMOVE_DSN = 3,

        ODBC_ADD_SYS_DSN = 4,

        ODBC_CONFIG_SYS_DSN = 5,

        ODBC_REMOVE_SYS_DSN = 6,

        ODBC_REMOVE_DEFAULT_DSN = 7

    }

​

    class Program

    {

        static void Main(string[] args)

        {

            var ex = UpdateDsnServer("nameTest", "serverStr", RequestFlags.ODBC_ADD_DSN);

            Console.WriteLine("ex = " + ex);

        }

​

        static bool UpdateDsnServer(string name, string server, RequestFlags flag)

        {

            var dsnNameLine = "DSN=" + name;

            var serverLine = "Server=" + server;

​

            // ja jag kopierade ett explel 

            var configString = new[] { dsnNameLine, serverLine }.Aggregate("", (str, line) => str + line + "\0");

​

            return SQLConfigDataSourceW(0, flag, "SQL Server", configString);

        }

​

        [DllImport("ODBCCP32.DLL", CharSet = CharSet.Unicode, SetLastError = true)]

        static extern bool SQLConfigDataSourceW(UInt32 hwndParent, RequestFlags fRequest, string lpszDriver, string lpszAttributes);

​

    }

}

​