ODBC Driver for Firebird

Connection String Options - ODBC Driver for Firebird

Firebird ODBC Connection String Options

The following table lists the connection string options for Firebird.

Option Description

ClientLibrary

The full path to the Firebird client library. For example, D:\fbclient.dll

Database

The full path to the database to connect to.

Password

Used to supply a password for login.

Port

Used to specify the port number for the connection. 3050 by default.

Protocol

Used to specify the Network protocol for connection with Firebird server.

TCP

Uses TCP/IP to connect to the server.

NetBEUI

Uses NetBEUI named pipe for connection

SPX

Uses the SPX protocol for connection

Server

Serves to supply the server name for login.

User ID

Used to supply a unique User ID for login.

Advanced Settings

Option Description

AllowNullStringsInMetadata

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.

EmptyStringsAsNullInMetadata

Charset

Used to set the character set that the driver uses to read and write character data.

Force Using Default Value

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.

RegionalNumberSettings

Enables the use of local regional settings when converting numbers to strings.

RegionalDateTimeSettings

Enables the use of local regional settings when converting dates and times to strings.

Role

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 option to Ansi or Unicode if your third-party tool supports only ANSI or Unicode strings.

Use Unicode

Used to enable or disable Unicode support. The default value is True.

Sample Firebird ODBC Connection String

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

© 2015-2021 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback