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