ODBC Driver for InterBase

Connection String Options - ODBC Driver for InterBase

InterBase ODBC Connection String Options

The following table lists the connection string options for InterBase.

Option Description


The full path to the InterBase client library. For example, D:\ibclient64.dll


The full path to the database to connect to.


Used to supply a password for login.


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


Used to specify the Network protocol for connection to InterBase.


Uses TCP/IP to connect to the server.


Uses NetBEUI named pipe for connection


Uses the SPX protocol for connection


Serves to supply the server name for login.

User ID

Used to supply a unique User ID for login.

Advanced Settings

Option Description


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.

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 InterBase. That said, other versions of InterBase 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.
The default value. ODBC behavior is determined by a third-party tool.
ODBC 2.x behavior is explicitly set.
ODBC 3.x behavior is explicitly set.
String Types Sets the string value types returned by the driver as Default, ANSI, or Unicode.
The driver defines the string types.
All string types are returned as SQL_CHAR, SQL_VARCHAR, and SQL_LONGVARCHAR.
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.


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


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


Used to specify the user role for connection to InterBase. For more information about InterBase roles, see https://www.ibphoenix.com/resources/documents/general/doc_59


Enables or disables Unicode support. The default value is False.

Sample InterBase ODBC Connection String

DRIVER={Devart ODBC Driver for InterBase};Data Source=; Database=D:\testdb.gdb; User ID=sysdba;Password=masterkey;Client Library=D:\ibclient64.dll

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