} // End Sub SetMicrosoftLocal
// http://yacoding.blogspot.com/2006/04/connecting-to-firebird-in-c.html
public void SetFirebird()
{
this.dbeDialect = DB.Abstraction.cDAL.DataBaseEngine_t.FireBird;
this.bEmbeddedDatabase = false;
this.strServerName = "localhost";
this.iPort = 3050;
//this.strInitialCatalog = @"E:\SQLData_Firebird\TESTDB.fdb";
this.strInitialCatalog = @"/var/lib/firebird/2.5/data/DNSdata.fdb";
this.strUserName = "******";
this.ssSecurePassword = DB.Abstraction.cDAL.String2SecureString("masterkey");
this.iConnectionTimeout = 15;
} // End Sub SetFirebird
} // End Constructor
// http://yacoding.blogspot.com/2006/04/connecting-to-firebird-in-c.html
public void SetAccess()
{
this.dbeDialect = DB.Abstraction.cDAL.DataBaseEngine_t.OleDB;
this.bEmbeddedDatabase = true;
this.strServerName = "localhost";
this.strProvider = "Microsoft.Jet.OLEDB.4.0";
//this.iPort = 3050;
//this.strInitialCatalog = @"E:\SQLData_Firebird\TESTDB.fdb";
this.strInitialCatalog = @"D:\Stefan.Steiger\Desktop\myfram_code_10\myfram_code_10\bin\db\myfram_entwicklung.mdb";
this.iOleDbServices = -4;
//this.strUserName = "******";
//this.ssSecurePassword = DB.Abstraction.cDAL.String2SecureString("masterkey");
this.iConnectionTimeout = 15;
} // End Sub SetFirebird
} // End Sub SetFirebird
public void SetMicrosoftLocal()
{
this.dbeDialect = DB.Abstraction.cDAL.DataBaseEngine_t.MS_SQL;
this.bEmbeddedDatabase = false;
this.strServerName = "localhost";
this.strInstanceName = "";
this.iPort = 0;
this.strInitialCatalog = "DNSdata";
this.bIntegratedSecurity = true;
this.strUserName = "******";
this.ssSecurePassword = DB.Abstraction.cDAL.String2SecureString("PasswordForMyUserName");
this.iConnectionTimeout = 15;
} // End Sub SetMicrosoftLocal
public static DB.Abstraction.UniversalConnectionStringBuilder GetDefaultCSB(DB.Abstraction.cDAL.DataBaseEngine_t dataBaseEngine)
{
DB.Abstraction.UniversalConnectionStringBuilder csb = DB.Abstraction.UniversalConnectionStringBuilder.CreateInstance(
dataBaseEngine
);
// OMG
if (System.Environment.OSVersion.Platform == System.PlatformID.Unix)
{
csb.Server = "127.0.0.1";
}
else
{
csb.Server = System.Environment.MachineName;
}
switch (dataBaseEngine)
{
case DB.Abstraction.cDAL.DataBaseEngine_t.PostGreSQL:
csb.Port = 5432;
csb.DataBase = "postgres";
break;
case DB.Abstraction.cDAL.DataBaseEngine_t.MySQL:
csb.Port = 3306;
break;
case DB.Abstraction.cDAL.DataBaseEngine_t.MS_SQL:
csb.IntegratedSecurity = true;
csb.DataBase = "master";
break;
} // End switch (dataBaseEngine)
if (!csb.IntegratedSecurity)
{
csb.UserName = "******";
csb.Password = "******";
} // End if(!csb.IntegratedSecurity)
return(csb);
}
