P/Invoke to create ODBC system DSN

最新推荐文章于 2024-02-07 22:09:49 发布

mail_dcb2

最新推荐文章于 2024-02-07 22:09:49 发布

阅读量371

点赞数

文章标签： system string database server class api

本文链接：https://blog.csdn.net/mail_dcb2/article/details/1917371

版权

public class AddLocalDSN
    {
        public static void Add()
        {
            string DSName = ConfigurationSettings.AppSettings["DSName"] as String;
            string serverName = ConfigurationSettings.AppSettings["ServerName"] as String;
            string databaseName = ConfigurationSettings.AppSettings["DatabaseName"] as String;
            bool addDSNSuccess = CreateDataSource((IntPtr)0,
            4,
            "SQL Server/0",
            "DESCRIPTION=" + DSName + "/0"
            + "DSN=" + DSName + "/0"
            + "Server=" + serverName + "/0"
            + "Database=" + databaseName + "/0"
            + "Trusted_Connection=yes/0");
        }
        ///

        /// Win32 API Imports
        ///

        [DllImport("ODBCCP32.dll")]
        private static extern bool SQLConfigDataSource(IntPtr hwndParent, int fRequest, string lpszDriver, string lpszAttributes);
        private static bool CreateDataSource(IntPtr hwndParent,
        int fRequest,
        string lpszDriver,
        string lpszAttributes)
        {
            return SQLConfigDataSource(hwndParent,
            fRequest,
            lpszDriver,
            lpszAttributes);
        }
    }