You can use ODBC to link to other data sources. Ordinarily, you can work with only one R:BASE database at a time. With ODBC, R:BASE can access tables from other databases. This means that you can use ODBC to access multiple R:BASE databases at once. For example, you can take information from one R:BASE database and use it in another. You can also open an R:BASE database, then access databases from other programs, such as Oracle or Paradox.
Also, ODBC allows the developer to write one application that has the ability to access data from databases created with different ODBC-compliant products. For example, you could write an application that would select data from SQL Server, Oracle, Paradox, and R:BASE databases, separately or all at the same time, depending on which database drivers you have installed.
Basically, a data source would need be created for the database product that you will to have access to. If you want R:BASE to have access to SQL Server data, you would set up a SQL Server data source. If you are providing access to R:BASE data, you would set up a R:BASE data source.
ODBC Topics:
Connecting Data Sources and Tables
See also:
