|
Connection String Parameters - ODBC Driver for Firebird |
|
|
|
Connection String Parameters - ODBC Driver for Firebird |
|
The following table lists the connection string parameters for Firebird.
| Parameter | Description |
|---|---|
|
|
The full path to the Firebird client library - for example, |
|
|
The full path to the database to connect to. |
|
|
The password of the Firebird user. |
|
|
The port number for the connection. The default port number is 3050. |
Protocol |
The network protocol for the connection to the Firebird server. Possible values:
TCP
Uses TCP/IP to connect to the server.
NetBEUI
Uses NetBEUI named pipe for connection
SPX
Uses the SPX protocol for connection
|
|
|
Serves to supply the server name for login. |
|
|
Used to supply a unique User ID for login. |
Advanced Settings |
|
|
|
Some parameters don't accept null values when retrieving metadata. If a third-party tool passes a null value to such a parameter, the driver returns an error. These options ensure compatibility with such third-party tools. |
|
|
|
|
|
Used to set the character set that the driver uses to read and write character data. |
|
|
The option for passing additional connection parameters separated by comma to the Firebird server. |
|
|
If the default port (3050) is used in the DSN settings, it will be cut out of the connection string for compatibility with certain versions of Firebird. That said, other versions of Firebird won't work correctly if the default port is not explicitly specified in the connection string. The Force Using Default Port option forces the driver to keep the default port in the connection string. The default value is False. |
ODBC Behavior |
Sets the behavior corresponding to the ODBC specification version expected by a third-party tool. The behavior of the ODBC driver can be changed by calling the SQLSetEnvAttr function to set the SQL_ATTR_ODBC_VERSION environment attribute. Some third-party tools expect the driver to exhibit ODBC 2.x behavior, but forget to call SQLSetEnvAttr with the needed version, or pass an incorrect value. In this case, the behavior can be explicitly set in the connection string.
0
The default value. ODBC behavior is determined by a third-party tool.
2
ODBC 2.x behavior is explicitly set.
3
ODBC 3.x behavior is explicitly set.
|
|
|
Used to prevent data from being modified, if set to True. The default value is False. |
|
|
Enables the use of local regional settings when converting numbers to strings. |
|
|
Enables the use of local regional settings when converting dates and times to strings. |
|
|
Used to specify the role that has been granted to the user. |
String Types |
Sets the string value types returned by the driver as Default, ANSI, or Unicode.
Default
The driver defines the string types.
Ansi
All string types are returned as SQL_CHAR, SQL_VARCHAR, and SQL_LONGVARCHAR.
Unicode
All string types are returned as SQL_WCHAR, SQL_WVARCHAR, and SQL_WLONGVARCHAR.
Note: Set the parameter to
Ansi or Unicode if your third-party tool supports only ANSI or Unicode strings.
|
|
|
Enables or disable Unicode support. The default value is |
|
|
Enables or disables compression of data over the wire at global or individual database level. Use Note: You should place |
|
DRIVER={Devart ODBC Driver for Firebird};Data Source=127.0.0.1;User ID=sysdba;Password=masterkey;Client Library=D:\fbclient.dll;Database=D:\mydb.fdb |