public bool CheckUserCredentialsInTNS() { if (!string.IsNullOrEmpty(TNSCalculated) && TNSCalculated.ToLower().Contains("data source=") && TNSCalculated.ToLower().Contains("password="******"user id=")) { return(true); } else { return(false); } }
public string CreateConnectionString() { //Default ConnectionString format Database.ConnectionString = "Data Source=" + Database.TNS + ";User Id={USER};Password={PASS};"; //Change ConnectionString according to DBType if (Database.DBType == eDBTypes.MSAccess) { string strProvider; if (TNSCalculated.Contains(".accdb")) { strProvider = "Provider=Microsoft.ACE.OLEDB.12.0;"; } else { strProvider = "Provider=Microsoft.Jet.OLEDB.4.0;"; } Database.ConnectionString = strProvider + Database.ConnectionString; } else if (Database.DBType == eDBTypes.DB2) { Database.ConnectionString = "Server=" + Database.TNS + ";Database=" + Database.Name + ";UID={USER};PWD={PASS}"; } else if (Database.DBType == eDBTypes.PostgreSQL) { string[] host = TNSCalculated.Split(':'); if (host.Length == 2) { Database.ConnectionString = "Server=" + host[0] + ";Port=" + host[1] + ";User Id={USER}; Password={PASS};Database=" + Database.Name + ";"; } else { // connStr = "Server=" + TNS + ";Database=" + Name + ";UID=" + User + "PWD=" + deCryptValue; Database.ConnectionString = "Server=" + Database.TNS + ";User Id={USER}; Password={PASS};Database=" + Database.Name + ";"; } } else if (Database.DBType == eDBTypes.MySQL) { Database.ConnectionString = "Server=" + Database.TNS + ";Database=" + Database.Name + ";UID={USER};PWD={PASS}"; } return(ConnectionStringCalculated); }
public string GetConnectionString() { string connStr = null; bool res; res = false; if (String.IsNullOrEmpty(ConnectionStringCalculated) == false) { connStr = ConnectionStringCalculated.Replace("{USER}", UserCalculated); String deCryptValue = EncryptionHandler.DecryptString(PassCalculated, ref res, false); if (res == true) { connStr = connStr.Replace("{PASS}", deCryptValue); } else { connStr = connStr.Replace("{PASS}", PassCalculated); } } else { String strConnString = TNSCalculated; String strProvider; connStr = "Data Source=" + TNSCalculated + ";User Id=" + UserCalculated + ";"; String deCryptValue = EncryptionHandler.DecryptString(PassCalculated, ref res, false); if (res == true) { connStr = connStr + "Password="******";"; } else { connStr = connStr + "Password="******";"; } if (DBType == eDBTypes.MSAccess) { if (strConnString.Contains(".accdb")) { strProvider = "Provider=Microsoft.ACE.OLEDB.12.0;"; } else { strProvider = "Provider=Microsoft.Jet.OLEDB.4.0;"; } connStr = strProvider + connStr; } else if (DBType == eDBTypes.DB2) { connStr = "Server=" + TNSCalculated + ";Database=" + Name + ";UID=" + UserCalculated + "PWD=" + deCryptValue; } else if (DBType == eDBTypes.PostgreSQL) { string[] host = TNSCalculated.Split(':'); if (host.Length == 2) { connStr = String.Format("Server ={0};Port={1};User Id={2}; Password={3};Database={4};", host[0], host[1], UserCalculated, deCryptValue, Name); } else { // connStr = "Server=" + TNS + ";Database=" + Name + ";UID=" + User + "PWD=" + deCryptValue; connStr = String.Format("Server ={0};User Id={1}; Password={2};Database={3};", TNSCalculated, UserCalculated, deCryptValue, Name); } } else if (DBType == eDBTypes.MySQL) { connStr = "Server=" + TNSCalculated + ";Database=" + Name + ";UID=" + UserCalculated + ";PWD=" + deCryptValue; } } return(connStr); }