skip to main content
Using the ODBC Client : Specifying ODBC Connection Attributes
 

Specifying ODBC Connection Attributes

You can modify a connection by specifying connection string options.
The basic format of a connection string includes a series of keyword/value pairs separated by semicolons. The following example shows the keywords and values for a simple connection string to connect to the host hal:
"Host=hal;Port=19998;User Id=test01;Password=test01;Database=test;"
This section describes the ODBC connection attributes supported by the ODBC driver on Linux, UNIX, and Windows, on 32-bit and 64-bit platforms.
This section lists ODBC connection attributes in alphabetical order. The list includes long and short names and provides a description of each attribute. Short names are shown enclosed within parentheses ( ).
The following connection option descriptions are listed alphabetically by the GUI name, that is, by the name that appears on the driver Setup dialog. The connection string name, along with its short name, is listed immediately underneath the GUI name.
In most cases, the GUI name and the attribute name are the same; however, some exceptions exist. Also, a few connection string attributes, for example, Password, do not have equivalent options that appear on the GUI. They are in the list of descriptions alphabetically by their attribute names.