public static void SetPostgresConnectionString(string connString)
{
VConnection vconn = VConnection.Get();
vconn.Db_Type = DatabaseType.DB_POSTGRESQL;
vconn.SetAttributes(connString);
vconn.GetDatabase().SetConnectionString(connString);
DB.SetDBTarget(VConnection.Get());
connectionString = connString;
}
public static void SetOracleConnectionString(string connString)
{
VConnection vconn = VConnection.Get();
vconn.Db_Type = DatabaseType.DB_ORACLE;
vconn.SetAttributes(connString);
vconn.GetDatabase().SetConnectionString(connString);
DB.SetDBTarget(VConnection.Get());
connectionString = connString;
}
public static string CreateConnectionString()
{
if (DataBase.DB.UseMigratedConnection)
{
if (DataBase.DB.MigrationConnection != null && DataBase.DB.MigrationConnection != "")
{
VConnection vconn = VConnection.Get();
vconn.SetAttributes(DataBase.DB.MigrationConnection);
return(DataBase.DB.MigrationConnection);
}
return("");// Ini.CreateConnectionString(WindowMigration.MDialog.GetMConnection());
}
else
{
if (connectionString == null)
{
//connectionString = System.Configuration.ConfigurationSettings.AppSettings["oracleConnectionString"];
VConnection vconn = VConnection.Get();
connectionString = System.Configuration.ConfigurationManager.AppSettings["oracleConnectionString"];
if (!string.IsNullOrEmpty(connectionString))
{
vconn.Db_Type = DatabaseType.DB_ORACLE;
connectionString = TrimUnicode(connectionString);
vconn.SetAttributes(connectionString);
vconn.GetDatabase().SetConnectionString(connectionString);
return(connectionString);
}
connectionString = System.Configuration.ConfigurationManager.AppSettings["PostgreSQLConnectionString"];
if (!string.IsNullOrEmpty(connectionString))
{
vconn.Db_Type = DatabaseType.DB_POSTGRESQL;
vconn.SetAttributes(connectionString);
vconn.GetDatabase().SetConnectionString(connectionString);
return(connectionString);
}
connectionString = System.Configuration.ConfigurationManager.AppSettings["PostgreSQLPlusConnectionString"];
if (!string.IsNullOrEmpty(connectionString))
{
vconn.Db_Type = DatabaseType.DB_POSTGRESQL;
vconn.SetAttributes(connectionString);
vconn.GetDatabase().SetConnectionString(connectionString);
return(connectionString);
}
connectionString = System.Configuration.ConfigurationManager.AppSettings["MSSQLConnectionString"];
if (!string.IsNullOrEmpty(connectionString))
{
vconn.Db_Type = DatabaseType.DB_MSSQL;
vconn.SetAttributes(connectionString);
vconn.GetDatabase().SetConnectionString(connectionString);
return(connectionString);
}
// connectionString = vconn.CreateDBConnectionString();
//return Ini.CreateConnectionString(vconn);
}
return(connectionString);
//VConnection vconn = VConnection.Get();
// return Ini.CreateConnectionString(vconn);
}
//s_conn.Add(1, constr);
//}
//return constr; //return the connection string to the user
}