Creating a data source v13
When a client application tries to establish a connection with a server, it typically provides a data source name (DSN). The driver manager looks through the ODBC configuration database for a data source whose name matches the DSN provided by the application.
On a Linux or Unix host, data sources are defined in a file usually named
/etc/odbc.ini. The name and location can vary. Use the following command to find out where unixODBC is searching for data source definitions:
$ odbc_config --odbcini --odbcinstini
On a Windows host, data sources are typically defined in the Windows registry.
You can also store a data source definition, called a File DSN, in a plain-text file. A typical data source definition for the EDB-ODBC driver looks like this:
The first line in the data source is the data source name. The name is a unique identifier, enclosed in square brackets. The data source name is followed by a series of
keyword=value pairs that identify individual connection properties that make up the data source.
The ODBC Administrator utility creates named data sources for ODBC connections. In most cases, an ODBC Administrator utility is distributed with the operating system. If you’re using Windows or unixODBC, the tool is called the ODBC Data Source Administrator. If your operating system doesn’t include an ODBC Administrator, third-party options are available online.
Adding a data source definition in Windows and Adding a data source definition in Linux walk you through adding a data source in Windows and Linux using the graphical tools available for each operating system. During the process of defining a data source, you’ll be asked to specify a set of connection properties. EDB-ODBC connection properties contains information about optional data source connection properties. You can specify connection properties with graphical tools or edit the
odbc.ini file with a text editor.