|
|
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.
- Run the ODBC Data Source Administrator.
- Select the ODBC data source type to be created or modified. An ODBC data source name (DSN) can be one of the following types:
- File - A data source stored in a file that can be shared among all users who have the same ODBC drivers installed. These data sources need not be dedicated to a specific user or local to a computer.
- User - A data source local to a computer and accessible only by the current user that created the data source.
- System - A data source local to a computer but not dedicated to a specific user, so any user with appropriate privileges can access a system DSN. A System data source is visible to all users on a computer, including Windows NT services.
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
- Select the Driver for a database from the list of drivers, set Advanced File DSN Creation Settings (driver-specific keywords) for a File data source type and click the Next button.
- Specify the name and the location of ODBC Data Sources file and click Next.
- View the configured data source and click Finish.
|
|