/// <summary> /// 设置连接 /// </summary> /// <param name="strConnectString">连接的字符串</param> /// <returns>0 success -1 fail</returns> public int Connect(string strConnectString) { try { //显示进度 this.ProgressBarValue = 50; this.ProgressBarText = "正在连接数据库..."; con = new IBM.Data.DB2.DB2Connection(strConnectString); con.Open(); Neusoft.FrameWork.Management.Connection.Instance = con as IBM.Data.DB2.DB2Connection;//传给全局连接 WriteDebug("连接数据库!" + strConnectString); this.ProgressBarValue = 0; return(0); } catch (Exception ex) { this.ProgressBarValue = 0; this.Err = "连接数据库产生错误!" + ex.Message; this.ErrorException = ex.InnerException + "+ " + ex.Source; this.ErrCode = "-1"; this.WriteErr(); return(-1); } }
// Helper method: This method establishes a connection to a database private IBM.Data.DB2.DB2Connection ConnectDb() { String server = txtHostName.Text.Trim(); String alias = txtDatabaseName.Text.Trim(); String userId = txtUserId.Text.Trim(); String password = txtPwd.Text.Trim(); String portNumber = txtPortNumber.Text.Trim(); String connectString; try { connectString = "Server=" + server + ":" + portNumber + ";Database=" + alias; if (userId != "") { connectString += ";UID=" + userId + ";PWD=" + password; } IBM.Data.DB2.DB2Connection conn = new IBM.Data.DB2.DB2Connection(connectString); conn.Open(); return(conn); } catch (Exception) { throw; } }
public void Open() { try { _DB2Conn = new IBM.Data.DB2.DB2Connection(); _DB2Conn.ConnectionString = _connectingString; _DB2Conn.Open(); } catch (System.Exception ex) { _DB2Conn = null; throw ex; } }
/* * Método que conecta con la base de datos. */ private static IBM.Data.DB2.DB2Connection ConnectDb() { String userId = "sromero"; String password = "******"; String connectString; string message = string.Empty; try { connectString = "Database=CGS;Server=ARUS3DB03.nwsn.local:50000;Persist Security Info=True"; string letMeIn = "Database=CGS;Server=ARUS3DB06.nwsn.local:50000;Persist Security Info=True"; if (userId != "") { letMeIn += ";UID=" + userId + ";PWD=" + password; } IBM.Data.DB2.DB2Connection conn = new IBM.Data.DB2.DB2Connection(letMeIn); conn.Open(); message = "DB2 Cennexion exitosa !"; return(conn); } catch (Exception) { throw; } }