Manually configure an ODBC data source
Learn how to manually configure data source options that can not be set on the GUI.
The ODBC data source graphical user interface(GUI)
contains
a subset of the most commonly used connection options. Additional
connection options are specified by the connecting application or
by editing the odbc.ini
file.
It is strongly recommended that you reference the Connection string keywords topic before manually configuring connection options.
Use the following
steps to add connection options to the odbc.ini
file:
Note:
- Do not add multiple entries for the same connection option to the same section for a specific data source. This can lead to unpredictable behavior.
- After manually editing the registry you can use
ODBCConfig
to configure your data source. - Options specified by the application in the connection string
override any options specified in the
odbc.ini
file.