/// <summary> /// 测试连接是否成功 /// </summary> /// <param name="Server"></param> /// <param name="DatabasePrefix"></param> /// <param name="Uid"></param> /// <param name="Pwd"></param> /// <param name="DataWind"></param> /// <returns></returns> public string GetConnection(string Server, string Database, string Uid, string Pwd, bool Authentication) { string strSysConnection = ""; if (Authentication) strSysConnection = string.Format("server={0};database={1};integrated security=SSPI", Server, Database); else strSysConnection = string.Format("server={0};database={1};uid={2};pwd={3}", Server, Database, Uid, Pwd); try { ia = DBAccessLayer.DBFactory.GetDBAccess(strSysConnection); if (ia.OpenConnection()) return strSysConnection; else return ""; } catch (Exception ex) { return ""; } finally { ia.CloseConnection(); } }
/// <summary> /// 测试连接是否成功 /// </summary> /// <param name="Server"></param> /// <param name="DatabasePrefix"></param> /// <param name="Uid"></param> /// <param name="Pwd"></param> /// <param name="DataWind"></param> /// <returns></returns> public bool OpenConnection(string connectionString) { try { ia = DBAccessLayer.DBFactory.GetDBAccess(connectionString); return ia.OpenConnection(); } catch (Exception ex) { return false; } finally { ia.CloseConnection(); } }