You can use 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 it is shipped with Microsoft Access, Microsoft Excel, Microsoft Word for Windows, FoxPro, and other software packages that support ODBC drivers for data access.
If you use FoxPro, you can connect to the target server and generate a database using either ODBC or by directly generating the files in the database. If you do not define an ODBC data source for this database, you are prompted to provide the name of the path for the database when you generate the schema.
More features are supported during schema generation when you use ODBC rather than using a direct connection to the files.
| Copyright © 2009 CA. All rights reserved. | Email CA about this topic |