private NameValueCollection GetConnectionPropertiesInternal(bool use64Bit) { var values = new NameValueCollection(); if (string.IsNullOrEmpty(resDataCtrl.MarkedFile)) { return(values); } //throw new InvalidOperationException(Properties.Resources.OdbcNoMarkedFile); string drv = InferDriver(resDataCtrl.MarkedFile, use64Bit); if (drv == null) { return(values); } //throw new InvalidOperationException(string.Format(Properties.Resources.OdbcCannotInferDriver, resDataCtrl.MarkedFile)); var inner = new System.Data.Odbc.OdbcConnectionStringBuilder(); inner["Driver"] = drv; //NOXLATE inner["Dbq"] = StringConstants.MgDataFilePath + resDataCtrl.MarkedFile; values["ConnectionString"] = inner.ToString(); //NOXLATE return(values); }
/// <summary> /// Initialize a new GeoLocationEntities object. /// </summary> public GeoLocationEntities(string connectionString) : base(Util.ConvertNormalCS2EF(connectionString)) { InstanceKey = Guid.NewGuid(); _contextStartup = new EFDAL.ContextStartup(null, true); ResetContextStartup(); try { var builder = new System.Data.Odbc.OdbcConnectionStringBuilder(Util.StripEFCS2Normal(this.Database.Connection.ConnectionString)); var timeoutValue = "30"; if (builder.ContainsKey("connect timeout")) { timeoutValue = (string)builder["connect timeout"]; } else if (builder.ContainsKey("connection timeout")) { timeoutValue = (string)builder["connection timeout"]; } var v = Convert.ToInt32(timeoutValue); if (v > 0) { this.CommandTimeout = v; } } catch { } this.OnContextCreated(); }
} // End Constructor public cAccess(string strConnectionString) { //this.m_DatabaseConfiguration = dbcDBconfig; this.m_dbtDBtype = DataBaseEngine_t.Access; this.m_providerFactory = this.GetFactory(); this.m_dictScriptTemplates = GetSQLtemplates(); this.m_dblDBversion = 0.0; this.m_ConnectionString = new System.Data.Odbc.OdbcConnectionStringBuilder(); } // End Constructor 2
private string GetDbInfo() { var csBuilder = new System.Data.Odbc.OdbcConnectionStringBuilder(ConfigurationManager.ConnectionStrings["RockContext"].ConnectionString); object dataSource, catalog = string.Empty; if (csBuilder.TryGetValue("data source", out dataSource) && csBuilder.TryGetValue("initial catalog", out catalog)) { return(string.Format("{0} @ {1}", catalog, dataSource)); } return(string.Empty); }
/*Al caricamento della pagina il programma preleva tutti le impostazioni modificabili dal file Web.config e le * mette nei relativi campi, salva inoltre una copia delle impostazioni di collegamento dal database in delle * variabili per poter verificare in fase di salvataggio se l'utente ha apportato modifiche o meno aggiornando * eventualmente i dati presenti nel file e riavviando l'applicazione per rendere effettive le modifiche.*/ protected void Page_Load(object sender, EventArgs e) { config = WebConfigurationManager.OpenWebConfiguration("~"); section = config.GetSection("connectionStrings") as ConnectionStringsSection; System.Data.Odbc.OdbcConnectionStringBuilder builder = new System.Data.Odbc.OdbcConnectionStringBuilder(); builder.ConnectionString = section.ConnectionStrings["Test1"].ConnectionString; if (!IsPostBack) { ns.Text = WebConfigurationManager.AppSettings["Titolo"]; TextBox2.Text = builder["Data Source"].ToString(); TextBox3.Text = builder["Initial Catalog"].ToString(); TextBox4.Text = builder["User ID"].ToString(); TextBox5.Text = builder["Password"].ToString(); } }
/// <summary> /// Set the database connection string. /// </summary> /// <param name="connectionString"></param> public void SetConnectionString(string connectionString) { if (string.IsNullOrWhiteSpace(connectionString)) { this.ConnectionString = null; } else { // Parse the connection string and store the server name and database name. var csBuilder = new System.Data.Odbc.OdbcConnectionStringBuilder(connectionString); object serverName; object databaseName; bool isValid; isValid = csBuilder.TryGetValue("server", out serverName); if (!isValid) { csBuilder.TryGetValue("data source", out serverName); } isValid = csBuilder.TryGetValue("database", out databaseName); if (!isValid) { csBuilder.TryGetValue("initial catalog", out databaseName); } _serverName = serverName.ToStringSafe(); _databaseName = databaseName.ToStringSafe(); this.ConnectionString = connectionString; } // Reset all cached properties. _platform = PlatformSpecifier.Unknown; _versionInfoRetrieved = false; _versionNumber = null; _version = null; _versionFriendlyName = null; _databaseServerOperatingSystem = null; _snapshotIsolationAllowed = null; _readCommittedSnapshotEnabled = null; _edition = null; _recoverMode = null; }
public string GetConnectionString() { if (!string.IsNullOrEmpty(DatabaseServer) && !string.IsNullOrEmpty(DatabaseName)) { var connectionStringBuilder = new SqlConnectionStringBuilder(); connectionStringBuilder.DataSource = DatabaseServer; connectionStringBuilder.InitialCatalog = DatabaseName; if (string.IsNullOrEmpty(DatabaseUser)) { connectionStringBuilder.IntegratedSecurity = true; } else { connectionStringBuilder.IntegratedSecurity = false; connectionStringBuilder.UserID = DatabaseUser; connectionStringBuilder.Password = DatabasePassword; } connectionStringBuilder.ConnectTimeout = 5; return(connectionStringBuilder.ToString()); } if (DSN != null) { var connectionStringBuilder = new SqlConnectionStringBuilder(); var odbcConnectionStringBuilder = new System.Data.Odbc.OdbcConnectionStringBuilder("DSN=" + DSN); connectionStringBuilder.AsynchronousProcessing = true; connectionStringBuilder.ConnectTimeout = 5; connectionStringBuilder.DataSource = (string)odbcConnectionStringBuilder["Server"]; connectionStringBuilder.InitialCatalog = (string)odbcConnectionStringBuilder["Database"]; connectionStringBuilder.MultipleActiveResultSets = true; connectionStringBuilder.ApplicationName = System.Reflection.Assembly.GetEntryAssembly().GetName().Name; connectionStringBuilder.IntegratedSecurity = true; return(connectionStringBuilder.ToString()); } if (ConnectionStrings != null && !(string.IsNullOrEmpty(ConnectionName))) { var connectionStringSetting = ConnectionStrings.SingleOrDefault(x => x.Name == ConnectionName); if (connectionStringSetting == null) { throw new ArgumentException(string.Format("Cannot find a connection string named \"{0}\"", ConnectionName), "ConnectionName"); } return(connectionStringSetting.ConnectionString); } return(null); }
/* Azure SQL Test Settings * private const string _TestSettingServerName = "tcp:oneheartbali.database.windows.net"; * private const string _TestSettingDatabaseName = "rock_live"; * private const string _TestSettingsDatabaseVersion = "12.0.2000.8"; * private const string _TestSettingsDatabaseVersionFriendlyName = "SQL Server 2014"; * private const string _TestSettingsDatabaseHostPlatform = "Azure"; * private const string _TestSettingsDatabaseEdition = "Standard"; * private const string _TestSettingsDatabaseRecoveryMode = "FULL"; * private const string _TestSettingsServiceObjective = "S0"; * private const bool _TestSettingReadCommittedSnapshotEnabled = true; * private const bool _TestSettingSnapshotIsolationAllowed = true; * private const RockInstanceDatabaseConfiguration.PlatformSpecifier _TestSettingPlatform = RockInstanceDatabaseConfiguration.PlatformSpecifier.AzureSql; */ protected override void OnValidateTestData(out bool isValid, out string stateMessage) { try { // Verify that we are connected to the expected test database. var dataContext = GetNewDataContext(); var connectionString = dataContext.Database.Connection.ConnectionString; var csBuilder = new System.Data.Odbc.OdbcConnectionStringBuilder(connectionString); object value; bool hasValue; hasValue = csBuilder.TryGetValue("server", out value); if (!hasValue) { hasValue = csBuilder.TryGetValue("data source", out value); } var serverName = value.ToStringSafe(); if (!serverName.Equals(_TestSettingServerName, StringComparison.OrdinalIgnoreCase)) { throw new Exception($"Test database is invalid. Server Name \"{serverName}\" does not match test configuration settings."); } csBuilder.TryGetValue("initial catalog", out value); var databaseName = value.ToStringSafe(); if (!databaseName.Equals(_TestSettingDatabaseName, StringComparison.OrdinalIgnoreCase)) { throw new Exception($"Test database is invalid. Database Name \"{databaseName}\" does not match test configuration settings."); } isValid = true; stateMessage = null; } catch (Exception ex) { isValid = false; stateMessage = ex.Message; } }
/*Questa funzione salva le impostazioni aggiornate.*/ protected void Button1_Click(object sender, EventArgs e) { System.Data.Odbc.OdbcConnectionStringBuilder builder = new System.Data.Odbc.OdbcConnectionStringBuilder(); builder.ConnectionString = section.ConnectionStrings["Test1"].ConnectionString; //Se è stata inserita una nuova password e la conferma è corretta la password nel database viene aggiornata. if (TextBox1.Text != "" && TextBox1.Text == TextBox6.Text) { Auth.rePass(TextBox1.Text); Label2.Text = "La password è stata modificata con successo"; } //Se le impostazioni del database stato cambiate il programma le testa e in caso di esito positivo aggiorna il file e riavvia l'applicazione if (TextBox2.Text != builder["Data Source"].ToString() || TextBox3.Text != builder["Initial Catalog"].ToString() || TextBox4.Text != builder["User ID"].ToString() || TextBox5.Text != builder["Password"].ToString()) { if (DBTest.stringTest("Data Source=" + TextBox3.Text + ";Initial Catalog=" + TextBox4.Text + ";Persist Security Info=True;User ID=" + TextBox5.Text + ";Password="******"Test1"].ConnectionString = "Data Source=" + TextBox3.Text + ";Initial Catalog=" + TextBox4.Text + ";Persist Security Info=True;User ID=" + TextBox5.Text + ";Password="******"Connessione al database fallita, verranno ripristinate le impostazioni precedenti"; } } //Se il titolo dell'installazione dell'applicazione è stato cambiato aggiorna il file e riavvia l'applicazione if (WebConfigurationManager.AppSettings["Titolo"] != ns.Text) { Configuration objConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("~"); AppSettingsSection objAppsettings = (AppSettingsSection)objConfig.GetSection("appSettings"); if (objAppsettings != null) { objAppsettings.Settings["Titolo"].Value = ns.Text; objConfig.Save(); reboot = true; } } if (reboot) { HttpRuntime.UnloadAppDomain(); Response.Redirect(Request.RawUrl); } }
/// <summary> /// Combines the Rock semantic version number and the database name into a comma separated string /// </summary> /// <returns>A comma separated string of the Rock Semantic Version Number and the database name</returns> public string CreateTags() { string tags = string.Empty; // Get Rock Version var version = new Version(Rock.VersionInfo.VersionInfo.GetRockSemanticVersionNumber()); tags += version.ToString(); // Get database name var builder = new System.Data.Odbc.OdbcConnectionStringBuilder(ConfigurationManager.ConnectionStrings["RockContext"].ConnectionString); object catalog; if (builder.TryGetValue("initial catalog", out catalog)) { tags += "," + catalog; } return(tags); }
public override DbConnection GetConnection() { // Look up configuration var cs = ConfigurationManager.ConnectionStrings[FileOrName]; if (cs != null) { return(new ProviderConnectionSetting(cs.ProviderName, cs.ConnectionString).GetConnection()); } // Access file? if (FileOrName.EndsWith(".accdb") || FileOrName.EndsWith(".mdb")) { var builder = new System.Data.Odbc.OdbcConnectionStringBuilder(); builder.Add("Driver", "{Microsoft Access Driver (*.mdb, *.accdb)}"); builder.Add("Dbq", FileOrName); var conn = new System.Data.Odbc.OdbcConnection(); conn.ConnectionString = builder.ConnectionString; conn.Open(); return(conn); } // Assume a SQLite file // Restricts to an exsiting file to prevent mistyping from creating a new database if (File.Exists(FileOrName)) { var builder = new System.Data.SQLite.SQLiteConnectionStringBuilder(); builder.Add("Data Source", FileOrName); var conn = new System.Data.SQLite.SQLiteConnection(); conn.ConnectionString = builder.ConnectionString; conn.Open(); return(conn); } throw new RuntimeException(String.Format("'{0}' is not a database file name nor connection string name", FileOrName)); }
private string GetDbInfo() { StringBuilder databaseResults = new StringBuilder(); var csBuilder = new System.Data.Odbc.OdbcConnectionStringBuilder( ConfigurationManager.ConnectionStrings["RockContext"].ConnectionString ); object dataSource, catalog = string.Empty; if ( csBuilder.TryGetValue( "data source", out dataSource ) && csBuilder.TryGetValue( "initial catalog", out catalog ) ) { _catalog = catalog.ToString(); databaseResults.Append( string.Format( "Name: {0} <br /> Server: {1}", catalog, dataSource ) ); } try { // get database version var reader = DbService.GetDataReader( "SELECT SERVERPROPERTY('productversion'), @@Version ", System.Data.CommandType.Text, null ); if ( reader != null ) { string version = ""; string versionInfo = ""; while ( reader.Read() ) { version = reader[0].ToString(); versionInfo = reader[1].ToString(); } databaseResults.Append( string.Format( "<br />Database Version: {0}", versionInfo ) ); } try { // get database size reader = DbService.GetDataReader( "sp_helpdb " + catalog, System.Data.CommandType.Text, null ); if ( reader != null ) { // get second data table reader.NextResult(); reader.Read(); string size = reader.GetValue( 5 ).ToString(); if ( size != "Unlimited" ) { if ( size.Contains( "KB" ) ) { size = size.Replace( " KB", "" ); int sizeInKB = Int32.Parse( size ); int sizeInMB = sizeInKB / 1024; databaseResults.AppendFormat( "<br />Database Size: {0}", sizeInMB ); } } else { databaseResults.Append( "<br />Database Size: Unlimited" ); } } } catch { databaseResults.AppendFormat( "<br />Database Size: unable to determine" ); } try { // get database snapshot isolation details reader = DbService.GetDataReader( string.Format( "SELECT [snapshot_isolation_state], [is_read_committed_snapshot_on] FROM sys.databases WHERE [name] = '{0}'", _catalog ), System.Data.CommandType.Text, null ); if ( reader != null ) { bool isAllowSnapshotIsolation = false; bool isReadCommittedSnapshopOn = true; while ( reader.Read() ) { isAllowSnapshotIsolation = reader[0].ToStringSafe().AsBoolean(); isReadCommittedSnapshopOn = reader[1].ToString().AsBoolean(); } databaseResults.AppendFormat( "<br />Allow Snapshot Isolation: {0}<br />Is Read Committed Snapshot On: {1}<br />", isAllowSnapshotIsolation.ToYesNo(), isReadCommittedSnapshopOn.ToYesNo() ); } } catch { } } catch ( Exception ex ) { databaseResults.AppendFormat( "Unable to read database system information: {0}", ex.Message ); } return databaseResults.ToString(); }
public new static void Tests() { System.Data.Common.DbConnectionStringBuilder dbcsb = new System.Data.Common.DbConnectionStringBuilder(); System.Data.SqlClient.SqlConnectionStringBuilder sqlcsb = new System.Data.SqlClient.SqlConnectionStringBuilder(); sqlcsb.NetworkLibrary = ""; //sqlcsb.TransactionBinding sqlcsb.TypeSystemVersion = ""; sqlcsb.UserInstance = true; Npgsql.NpgsqlConnectionStringBuilder csb = new Npgsql.NpgsqlConnectionStringBuilder(); // csb.Protocol // csb.Compatible //csb.SslMode = Npgsql.SslMode.Require; // csb.UseExtendedTypes System.Data.OracleClient.OracleConnectionStringBuilder ocb = new System.Data.OracleClient.OracleConnectionStringBuilder(); FirebirdSql.Data.FirebirdClient.FbConnectionStringBuilder fbcsb = new FirebirdSql.Data.FirebirdClient.FbConnectionStringBuilder(); fbcsb.ServerType = FirebirdSql.Data.FirebirdClient.FbServerType.Embedded; Mono.Data.Sqlite.SqliteConnectionStringBuilder litecsb = new Mono.Data.Sqlite.SqliteConnectionStringBuilder(); litecsb.BinaryGUID = true; litecsb.DateTimeFormat = Mono.Data.Sqlite.SQLiteDateFormats.ISO8601; litecsb.DefaultIsolationLevel = System.Data.IsolationLevel.ReadCommitted; litecsb.DefaultTimeout = 123; litecsb.FailIfMissing = true; litecsb.JournalMode = Mono.Data.Sqlite.SQLiteJournalModeEnum.Off; litecsb.LegacyFormat = false; litecsb.SyncMode = Mono.Data.Sqlite.SynchronizationModes.Full; litecsb.Uri = ""; litecsb.Version = 123; MySql.Data.MySqlClient.MySqlConnectionStringBuilder mycb = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder(); mycb.AllowBatch = true; mycb.CertificateFile = ""; mycb.CertificatePassword = ""; mycb.CertificateStoreLocation = MySql.Data.MySqlClient.MySqlCertificateStoreLocation.LocalMachine; mycb.CertificateThumbprint = ""; mycb.CharacterSet = ""; mycb.CheckParameters = true; mycb.ConnectionLifeTime = 123; mycb.ConnectionProtocol = MySql.Data.MySqlClient.MySqlConnectionProtocol.Tcp; mycb.ConnectionReset = true; mycb.ConvertZeroDateTime = false; mycb.DefaultCommandTimeout = 123; mycb.FunctionsReturnString = true; mycb.IgnorePrepare = true; mycb.InteractiveSession = false; mycb.Keepalive = 123; mycb.PipeName = ""; System.Data.Odbc.OdbcConnectionStringBuilder odbc = new System.Data.Odbc.OdbcConnectionStringBuilder(); //System.Data.OleDb.OleDbConnectionStringBuilder oledb = new System.Data.OleDb.OleDbConnectionStringBuilder(); } // End Sub
//dBase functions //Use Intersolv ODBC Driver v3.10 private static void SaveDBF(DataTable DT, byte saveType) { StringBuilder shortPath = new StringBuilder(300); Com_WinApi.GetShortPathName(driver.Config.ConfigManager.Instance.CommonConfiguration.Path_Cheques, shortPath, shortPath.Capacity); //Check if (File.Exists(driver.Config.ConfigManager.Instance.CommonConfiguration.Path_Cheques + "\\" + DT.TableName + ".DBF")) File.Delete(driver.Config.ConfigManager.Instance.CommonConfiguration.Path_Cheques + "\\" + DT.TableName + ".DBF"); //Creating connection System.Data.Odbc.OdbcConnectionStringBuilder c_string = new System.Data.Odbc.OdbcConnectionStringBuilder(); c_string.Driver = "VODBFODBC"; c_string.Dsn = "VODBF"; c_string.Add("DB", shortPath.ToString()); c_string.Add("ULN", 1); c_string.Add("MS", 1); System.Data.Odbc.OdbcConnection odbc_connection = new System.Data.Odbc.OdbcConnection(c_string.ConnectionString); try { odbc_connection.Open(); } catch { } System.Data.Odbc.OdbcCommand odbc_command = odbc_connection.CreateCommand(); //Creating Table odbc_command.CommandText = "CREATE TABLE " + DT.TableName + " (ID char(10), AP numeric(11, 5), VQ numeric(11, 3), DR numeric(8, 2))"; try { odbc_command.ExecuteNonQuery(); } catch { } //Adding data string[] cols = new string[] { "PRICE", "PACK" }; if (saveType != 0) Array.Reverse(cols); for (int i = 0; i < DT.Rows.Count; i++) { odbc_command.CommandText = "INSERT INTO " + DT.TableName + " (ID,AP,VQ,DR) values ("; odbc_command.CommandText += "\'" + DT.Rows[i]["ID"] + "\'"; odbc_command.CommandText += ","; odbc_command.CommandText += MathLib.ReplaceNDS(DT.Rows[i][cols[0]].ToString(), "."); odbc_command.CommandText += ","; odbc_command.CommandText += MathLib.ReplaceNDS(DT.Rows[i]["TOT"].ToString(), "."); odbc_command.CommandText += ","; odbc_command.CommandText += MathLib.ReplaceNDS(DT.Rows[i][cols[1]].ToString(), "."); odbc_command.CommandText += ");"; try { odbc_command.ExecuteNonQuery(); } catch { } } odbc_connection.Close(); //string shortPath = "C:\\" + DT.TableName + ".dbf"; //mktChequeRow[] rows = new mktChequeRow[DT.Rows.Count + 5]; //for (int i = 0; i < DT.Rows.Count + 5; i++) //{ // rows[i].sz = DT.Rows[1]["ID"].ToString().ToCharArray(); // rows[i].r1 = (double)DT.Rows[1]["PRICE"]; // rows[i].r2 = (double)DT.Rows[1]["TOT"]; // rows[i].r3 = (double)DT.Rows[1]["PACK"]; //} //UInt32 r = MakeCheque((UInt32)DT.Rows.Count + 5, rows, shortPath); }
private NameValueCollection GetConnectionPropertiesInternal(bool use64Bit) { var values = new NameValueCollection(); string path = txtFilePath.Text; if (string.IsNullOrEmpty(path)) return values; //throw new InvalidOperationException(Properties.Resources.OdbcNoMarkedFile); string drv = InferDriver(path, use64Bit); if (drv == null) return values; //throw new InvalidOperationException(string.Format(Properties.Resources.OdbcCannotInferDriver, path)); var inner = new System.Data.Odbc.OdbcConnectionStringBuilder(); inner["Driver"] = drv; //NOXLATE inner["Dbq"] = path; //NOXLATE values["ConnectionString"] = inner.ToString(); //NOXLATE return values; }
private string GetDbInfo() { StringBuilder databaseResults = new StringBuilder(); var csBuilder = new System.Data.Odbc.OdbcConnectionStringBuilder(ConfigurationManager.ConnectionStrings["RockContext"].ConnectionString); object dataSource, catalog = string.Empty; if (csBuilder.TryGetValue("data source", out dataSource) && csBuilder.TryGetValue("initial catalog", out catalog)) { databaseResults.Append(string.Format("Name: {0} <br /> Server: {1}", catalog, dataSource)); } try { // get database version var reader = DbService.GetDataReader("SELECT SERVERPROPERTY('productversion'), @@Version ", System.Data.CommandType.Text, null); if (reader != null) { string version = ""; string versionInfo = ""; while (reader.Read()) { version = reader[0].ToString(); versionInfo = reader[1].ToString(); } databaseResults.Append(string.Format("<br />Database Version: {0}", versionInfo)); } // get database size reader = DbService.GetDataReader("sp_helpdb " + catalog, System.Data.CommandType.Text, null); if (reader != null) { // get second data table reader.NextResult(); reader.Read(); string size = reader.GetValue(5).ToString(); if (size != "Unlimited") { if (size.Contains("KB")) { size = size.Replace(" KB", ""); int sizeInKB = Int32.Parse(size); int sizeInMB = sizeInKB / 1024; databaseResults.Append(string.Format("<br />Database Size: {0}", sizeInMB)); } } else { databaseResults.Append("<br />Database Size: Unlimited"); } } } catch {} return(databaseResults.ToString()); }
private string GetDbInfo() { StringBuilder databaseResults = new StringBuilder(); var csBuilder = new System.Data.Odbc.OdbcConnectionStringBuilder(ConfigurationManager.ConnectionStrings["RockContext"].ConnectionString); object dataSource, catalog = string.Empty; if (csBuilder.TryGetValue("data source", out dataSource) && csBuilder.TryGetValue("initial catalog", out catalog)) { _catalog = catalog.ToString(); databaseResults.Append(string.Format("Name: {0} <br /> Server: {1}", catalog, dataSource)); } try { // get database version var reader = DbService.GetDataReader("SELECT SERVERPROPERTY('productversion'), @@Version ", System.Data.CommandType.Text, null); if (reader != null) { string version = ""; string versionInfo = ""; while (reader.Read()) { version = reader[0].ToString(); versionInfo = reader[1].ToString(); } databaseResults.Append(string.Format("<br />Database Version: {0}", versionInfo)); } try { // get database size reader = DbService.GetDataReader("sp_helpdb " + catalog, System.Data.CommandType.Text, null); if (reader != null) { // get second data table reader.NextResult(); reader.Read(); string size = reader.GetValue(5).ToString(); if (size != "Unlimited") { if (size.Contains("KB")) { size = size.Replace(" KB", ""); int sizeInKB = Int32.Parse(size); int sizeInMB = sizeInKB / 1024; databaseResults.AppendFormat("<br />Database Size: {0}", sizeInMB); } } else { databaseResults.Append("<br />Database Size: Unlimited"); } } } catch { databaseResults.AppendFormat("<br />Database Size: unable to determine"); } try { // get database snapshot isolation details reader = DbService.GetDataReader(string.Format("SELECT [snapshot_isolation_state], [is_read_committed_snapshot_on] FROM sys.databases WHERE [name] = '{0}'", _catalog), System.Data.CommandType.Text, null); if (reader != null) { bool isAllowSnapshotIsolation = false; bool isReadCommittedSnapshopOn = true; while (reader.Read()) { isAllowSnapshotIsolation = reader[0].ToStringSafe().AsBoolean(); isReadCommittedSnapshopOn = reader[1].ToString().AsBoolean(); } databaseResults.AppendFormat("<br />Allow Snapshot Isolation: {0}<br />Is Read Committed Snapshot On: {1}<br />", isAllowSnapshotIsolation.ToYesNo(), isReadCommittedSnapshopOn.ToYesNo()); } } catch { } } catch (Exception ex) { databaseResults.AppendFormat("Unable to read database system information: {0}", ex.Message); } return(databaseResults.ToString()); }
private string GetDbInfo() { var csBuilder = new System.Data.Odbc.OdbcConnectionStringBuilder( ConfigurationManager.ConnectionStrings["RockContext"].ConnectionString ); object dataSource, catalog = string.Empty; if ( csBuilder.TryGetValue( "data source", out dataSource ) && csBuilder.TryGetValue( "initial catalog", out catalog ) ) { return string.Format( "{0} @ {1}", catalog, dataSource ); } return string.Empty; }