Table of ContentsPreviousNext

Ispirer             Ispirer

Ispirer SQLWays Database Migration Software

Setting Up ODBC Data Sources

ODBC (Open Database Connectivity) is a standard application programming interface (API) used to access data in relational databases. Database vendors as well as third-party vendors offer ODBC drivers to enable connecting to all popular databases using ODBC. SQLWays can use the ODBC interface to access source databases.

In order to use ODBC to access databases, you have to create a data source that associates a particular ODBC driver with a database and contains information how to connect to the database.

ODBC data sources can be created by using the ODBC Data Source Administrator application of the Control Panel under Administrative Tools as Data Sources (ODBC) (for information about how add and configure the drivers, click Help in the ODBC Data Source Administrator dialog box) or by SQLWays Wizard clicking New in the Choose a Source Database page.

Data source information must be configured for each database system that is to be accessed using the ODBC Driver for a database.

The following steps describe how to create and configure data sources for use with the ODBC Driver for a database.

User and System data sources are stored in the registry. File data sources are stored as files with a file extension of dsn. File DSNs can be stored in any location on the file system including remotely-mounted shares. By default, File DSNs are stored in the following location:

C:\Program Files\Common Files\ODBC\Data Sources

Table of ContentsPreviousNext
Ispirer             Ispirer
Copyright © 1999-2015 Ispirer Systems Ltd. Ispirer and SQLWays are trademarks of Ispirer Systems Ltd. All other product names may be trademarks of the respective companies. All rights reserved.