C# 创建Oracle odbc

来源：互联网发布：lrc字幕制作软件编辑：程序博客网时间：2024/06/01 19:01

        /// <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;
            }
        }