代码动态创建ODBC数据源

最新推荐文章于 2021-02-08 20:52:42 发布

emailqjc

最新推荐文章于 2021-02-08 20:52:42 发布

阅读量928

点赞数

分类专栏： .NET 文章标签： database sql server server string command delete

本文链接：https://blog.csdn.net/emailqjc/article/details/5837853

版权

.NET 专栏收录该内容

46 篇文章 0 订阅

订阅专栏

1、定义方法:

/// <summary>
        /// 创建ODBC数据源
        /// </summary>
        /// <param name="dsn"></param>
        /// <param name="server"></param>
        /// <param name="database"></param>
        /// <returns></returns>
        private bool CreateSqlODBC(string dsn, string server, string database)
        {
            try
            {
                RegistryKey regKey = Registry.LocalMachine.OpenSubKey("SOFTWARE").OpenSubKey("ODBC").OpenSubKey("ODBC.INI", true).CreateSubKey(dsn);
                regKey.SetValue("Driver", @"C:/WINDOWS/system32/SQLSRV32.dll");
                regKey.SetValue("Server", server);
                regKey.SetValue("Database", database);
                regKey.SetValue("LastUser", "sa");
                regKey = Registry.LocalMachine.OpenSubKey("SOFTWARE").OpenSubKey("ODBC").OpenSubKey("ODBC.INI", true).OpenSubKey(

                            "ODBC Data Sources", true);
                regKey.SetValue(dsn, "SQL Server");
                //Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;"
                return true;
            }
            catch
            {
                return false;
            }
        }
2、调用：

CreateSqlODBC("bbbbbb", "dd-df428c5053d1", "DbName");

3、测试:

string queryString = "delete from ApLoginLOG";
OdbcCommand command = new OdbcCommand(queryString);

            using (OdbcConnection connection = new OdbcConnection("Driver={sql server};server=dd-df428c5053d1;database=DbName;uid=sa;pwd=pwd;"))
            {
                command.Connection = connection;
                connection.Open();
                command.ExecuteNonQuery();

}