Firebird ADO.NET Provider SDK Documentation - v1.7

FbConnection.ConnectionString Property

Gets or sets the string used to open a connection to a Firebird database.

[Visual Basic]
<RecommendedAsConfigurable(RecommendedAsConfigurable:=True), _  Category(Category:="Datos"), _  Editor(EditorBaseTypeName:="System.Drawing.Design.UITypeEditor, System.Drawing, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a", EditorTypeName:="FirebirdSql.Data.Firebird.Design.FbConnectionStringUIEditor, FirebirdSql.Data.Firebird, Version=1.7.0.0, Culture=neutral, PublicKeyToken=fa843d180294369d"), _  RefreshProperties(RefreshProperties:=RefreshProperties.All), _  DefaultValue>
NotOverridable Public Property ConnectionString As String _
    Implements IDbConnection.ConnectionString
[C#]
[RecommendedAsConfigurable(RecommendedAsConfigurable=True)]
[Category(Category="Datos")]
[Editor(EditorBaseTypeName="System.Drawing.Design.UITypeEditor, System.Drawing, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a", EditorTypeName="FirebirdSql.Data.Firebird.Design.FbConnectionStringUIEditor, FirebirdSql.Data.Firebird, Version=1.7.0.0, Culture=neutral, PublicKeyToken=fa843d180294369d")]
[RefreshProperties(RefreshProperties=RefreshProperties.All)]
[DefaultValue]
public string ConnectionString {get; set;}

Property Value

The connection string that includes the source database path and name, and other parameters needed to establish the initial connection. The default value is an empty string.

Implements

IDbConnection.ConnectionString

Remarks

The following table lists the valid names for keyword values for ConnectionString property.

Name Description Default
Database Database path to establish the connection.
User Firebird User account for login.
Password Password for the Firebird user account.
Dialect Database dialect. 3
Server or Data Source. Server name for establish the connection.
Port Port number in the server for establish the connection. 3050
Charset Database Character Set. NONE
Role User Role.
Packet Size Size (in bytes) of network packets used to communicate with an instance of Firebird Server. 8192
Connection Lifetime When a connection is returned to the pool, its creation time is compared with the current time, and the connection is destroyed if that time span (in seconds) exceeds the value specified by connection lifetime. 0
MinPoolSize The minimun number of connections allowed in the pool. 0
MaxPoolSize The maximun number of connections allowed in the pool. 100
Pooling When true, the FbConnection object is drawn from the appropriate pool, or if necessary, is created and added to the appropriate pool. Recognized values are true, false, yes, and no. true
Fetch Size Indicates the number of rows that will be fetched at the same time on Read calls into the internal row buffer.
ServerType When 0 the provider will use the GDS implementation used for connections to Firebird Super or Classic servers, when 1 the provider will use the GDS implementation used for connections to the Firebird embedded server. 0

The following table lists the valid names for the Charset keyword of the ConnectionString:

Firebird Charset Description
ASCII American Standard Code for Information Interchange.
BIG_5 Big5, Traditional Chinese.
DOS437 MS-DOS United States, Australia, New Zealand, South Africa.
DOS850 MS-DOS Latin-1.
DOS860 MS-DOS Portugues.
DOS861 MS-DOS Icelandic.
DOS863 MS-DOS Canadian French.
DOS865 MS-DOS Nordic.
EUCJ_0208 JIS X 0201, 0208, 0212, EUC encoding, Japanese.
GB_2312 GB2312, EUC encoding, Simplified Chinese.
ISO8859_1 ISO 8859-1, Latin alphabet No. 1.
ISO8859_2 ISO 8859-2, Latin alphabet No. 2.
KSC_5601 Windows Korean.
ISO2022-JP Windows Japanese.
SJIS_0208 Japanese (Shift-JIS)
UNICODE_FSS Eight-bit Unicode Transformation Format.
WIN1250 Windows Eastern European.
WIN1251 Windows Cyrillic.
WIN1252 Windows Latin-1.
WIN1253 Windows Greek.
WIN1254 Windows Turkish.
WIN1254 Windows Hebrew.
Arabic Windows Turkish.
WIN1257 Windows Baltic.

Exceptions

Exception TypeCondition
ArgumentExceptionAn invalid connection string argument has been supplied or a required connection string argument has not been supplied.

See Also

FbConnection Class | FirebirdSql.Data.Firebird Namespace