Previous Topic: Select Generic ODBCNext Topic: Define an ODBC Data Source


ODBC Data Sources

You can use the Open Database Connectivity (ODBC) software to access some target databases and to perform tasks such as schema generation. ODBC divides data access tasks between an ODBC database driver and an ODBC data source.

If you want to connect to a specific target DBMS, you can define the target server as an ODBC data source using the ODBC Administrator program. The ODBC Administrator program is available in both 16-bit and 32-bit versions, and is shipped with Microsoft Access, Microsoft Excel, Microsoft Word for Windows, and other software packages that support ODBC drivers for data access.

More features are supported during schema generation when you use ODBC rather than using a direct connection to the files.

More information:

Define an ODBC Data Source