Connection String Parameters

Example of using the connection string:

FbConnection c = new FbConnection(@"Server=localhost;User=SYSDBA;Password=masterkey;Database=C:\data\test.fdb");

Name	Description	Required for Firebird server	Required for embedded Firebird	Default value
Database	Database path to establish the connection. Can be relative to the server executable or fbembed.dll (embedded Firebird).	Yes	Yes
User	Firebird User account for login.	Yes	No
Password	Password for the Firebird user account.	Yes	No
Dialect	Database dialect.	No	No	3
Server or Data Source.	Server name for establish the connection.	Yes	No
Port	Port number in the server for establish the connection.	No	N/A	3050
Charset	Database Character Set.	No	No	NONE
Role	User Role.	No	No
Packet Size	Size (in bytes) of network packets used to communicate with an instance of Firebird Server.	No	N/A	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.	No	No	0
MinPoolSize	The minimum number of connections allowed in the pool.	No	No	0
MaxPoolSize	The maximum number of connections allowed in the pool.	No	No	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.	No	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.	No	No
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.	No	Yes	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.