http://www.dotnetfirebird.org/
https://sourceforge.net/
lvjh1036
lvjh8233217
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 |
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. |