private void bTEST_Click(object sender, EventArgs e) { try { using (FirebirdSql.Data.FirebirdClient.FbConnection fbc = new FirebirdSql.Data.FirebirdClient.FbConnection((new clDBInfo(tbDBName.Text, cbServer.Text, tbDBPath.Text, tbUser.Text, tbPassword.Text)).GetFbConnStr())) { fbc.Open(); FbServerProperties fbsp = new FbServerProperties(); fbsp.ConnectionString = (new clDBInfo(tbDBName.Text, cbServer.Text, tbDBPath.Text, tbUser.Text, tbPassword.Text)).GetFbConnStr(); string msg = ""; foreach (string s in fbsp.DatabasesInfo.Databases) { msg = msg + "\n" + s; } MessageBox.Show(string.Format("к серверу {0} успешно установлено соединение.\nВсего соединений к серверу БД: {1}\n {2}", cbServer.Text, fbsp.DatabasesInfo.ConnectionCount, msg)); fbc.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
FbTraceVersion DetectVersion() { var serverProperties = new FbServerProperties(ConnectionString); var serverVersion = FbServerProperties.ParseServerVersion(serverProperties.GetServerVersion()); if (serverVersion < new Version(3, 0, 0, 0)) { return(FbTraceVersion.Version1); } else { return(FbTraceVersion.Version2); } }
async Task <FbTraceVersion> DetectVersionAsync(CancellationToken cancellationToken = default) { var serverProperties = new FbServerProperties(ConnectionString); var serverVersion = FbServerProperties.ParseServerVersion(await serverProperties.GetServerVersionAsync(cancellationToken).ConfigureAwait(false)); if (serverVersion < new Version(3, 0, 0, 0)) { return(FbTraceVersion.Version1); } else { return(FbTraceVersion.Version2); } }
public void ServerPropertiesTest() { FbServerProperties serverProp = new FbServerProperties(); serverProp.ConnectionString = this.BuildServicesConnectionString(false); FbServerConfig serverConfig = serverProp.GetServerConfig(); FbDatabasesInfo databasesInfo = serverProp.GetDatabasesInfo(); Console.WriteLine(serverProp.GetMessageFile()); Console.WriteLine(serverProp.GetLockManager()); Console.WriteLine(serverProp.GetRootDirectory()); Console.WriteLine(serverProp.GetImplementation()); Console.WriteLine(serverProp.GetServerVersion()); Console.WriteLine(serverProp.GetVersion()); }
public void ServerPropertiesTest() { FbServerProperties serverProp = new FbServerProperties(); serverProp.ConnectionString = this.BuildServicesConnectionString(false); FbServerConfig serverConfig = serverProp.ServerConfig; FbDatabasesInfo databasesInfo = serverProp.DatabasesInfo; Console.WriteLine(serverProp.MessageFile); Console.WriteLine(serverProp.LockManager); Console.WriteLine(serverProp.RootDirectory); Console.WriteLine(serverProp.Implementation); Console.WriteLine(serverProp.ServerVersion); Console.WriteLine(serverProp.Version); }
protected override string GetDbProviderManifestToken(DbConnection connection) { try { var serverVersion = default(Version); if (connection.State == ConnectionState.Open) { serverVersion = FbServerProperties.ParseServerVersion(connection.ServerVersion); } else { var serverProperties = new FbServerProperties() { ConnectionString = connection.ConnectionString }; serverVersion = FbServerProperties.ParseServerVersion(serverProperties.GetServerVersion()); } return serverVersion.ToString(2); } catch (Exception ex) { throw new InvalidOperationException("Could not retrieve storage version.", ex); } }
protected override string GetDbProviderManifestToken(DbConnection connection) { if (connection == null) throw new ArgumentException("connection"); FbConnection fbConnection = CheckAndCastToFbConnection(connection); if (string.IsNullOrEmpty(fbConnection.ConnectionString)) { throw new ArgumentException("Could not determine storage version; a valid storage connection is required."); } try { FbServerProperties serverProperties = new FbServerProperties() { ConnectionString = fbConnection.ConnectionString }; Version serverVersion = serverProperties.GetServerVersion().ParseServerVersion(); return serverVersion.ToString(2); } catch (FbException ex) { throw new InvalidOperationException("Could not retrieve storage version.", ex); } }
public Version GetServerVersion() { var server = new FbServerProperties(); server.ConnectionString = BuildServicesConnectionString(_fbServerType); return FbServerProperties.ParseServerVersion(server.GetServerVersion()); }