C# 创建Oracle odbc

最新推荐文章于 2021-04-13 04:54:45 发布

wl076

最新推荐文章于 2021-04-13 04:54:45 发布

阅读量2.3k

点赞数

分类专栏： .net 文章标签： oracle c# string microsoft server

本文链接：https://blog.csdn.net/wl076/article/details/4375705

版权

.net 专栏收录该内容

27 篇文章 0 订阅

订阅专栏

        /// <summary>
        /// ODBC
        /// </summary>
        /// <param name="dsn">dns</param>
        /// <param name="server">服务名</param>
        /// <param name="description">说明</param>
        /// <param name="uid">用户名</param>
        /// <param name="pwd">密码</param>
        /// <returns></returns>
        private bool CreateODBC(string dsn, string server, string description, string uid,string pwd)
        {
            try
            {
                RegistryKey regKey = Registry.LocalMachine.OpenSubKey("SOFTWARE").OpenSubKey("ODBC").OpenSubKey("ODBC.INI", true).CreateSubKey(dsn);
                regKey.SetValue("BufferSize", "65535"); //默认
                regKey.SetValue("Description", description);
                regKey.SetValue("Driver","%SystemRoot%//system32//msorcl32.dll"); //Oracle
                regKey.SetValue("DSN", dsn);
                regKey.SetValue("GuessTheColDef","0");
                regKey.SetValue("PWD", pwd);
                regKey.SetValue("Remarks", "0");
                regKey.SetValue("SERVER", server);
                regKey.SetValue("StdDayOfWeek", "1");
                regKey.SetValue("StripTrailingZero", "0");
                regKey.SetValue("SynonymColumns", "1");
                regKey.SetValue("UID", uid);

                regKey = Registry.LocalMachine.OpenSubKey("SOFTWARE").OpenSubKey("ODBC").OpenSubKey("ODBC.INI", true).OpenSubKey("ODBC Data Sources", true);
                regKey.SetValue(dsn, "Microsoft ODBC for Oracle"); //Oracle
                return true;
            }
            catch
            {
                return false;
            }
        }