Gets or sets the string used to open a connection to a Firebird database.
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.
IDbConnection.ConnectionString
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. |
Exception Type | Condition |
---|---|
ArgumentException | An invalid connection string argument has been supplied or a required connection string argument has not been supplied. |
FbConnection Class | FirebirdSql.Data.Firebird Namespace