/// <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;
}
}
C# 创建Oracle odbc
最新推荐文章于 2024-03-24 14:39:08 发布