ODBC Driver for InterBase

Connection String Parameters - ODBC Driver for InterBase

InterBase ODBC Connection String Parameters

The following table lists the connection string parameters for InterBase.

Parameter Description

ClientLibrary

The full path to the InterBase client library. For example, D:\ibclient64.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 to InterBase.

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

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 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.
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.
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.

RegionalDateTimeSettings

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

RegionalNumberSettings

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

Role

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

UseUnicode

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

Sample InterBase ODBC Connection String

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

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