ODBC Data Sources

You can store a set of Sybase IQ connection parameters as a data source in either the system registry or as a file. Data sources are required to use applications that connect using the Open Database Connectivity (ODBC) interface.

Microsoft Corporation defines the ODBC interface, which is a standard interface for connecting client applications to database management systems in the Windows environments. Many client applications, including application development systems, use the ODBC interface to access a wide range of database systems.

On Windows, the ODBC Administrator provides a central place for creating and managing ODBC data sources.

Note: Use the 32-bit ODBC Administrator to manage data sources when using the 32-bit ODBC drivers and the 64-bit ODBC Administrator with 64-bit clients.

The following procedure uses the ODBC Administrator to add a new data source to your existing odbc.ini, or creates a new file if necessary.

Sybase IQ also includes a cross-platform command-line utility named iqdsn to create data sources.

Before You Begin

This section describes how to create an ODBC data source. Before you create a data source, you need to know which connection parameters you want to include in it.

In ODBC Administrator, you can work with User Data Sources, File Data Sources, and System Data Sources.