How do report writers typically connect to DBMSs?
There are two commonly used techniques for providing access to data: • Open DataBase Connectivity (ODBC). • Dedicated Middleware. ODBC ODBC is supported by a considerable number of products, including Uniface, but is proprietary to Windows platforms. In addition, there are 16-bit and 32-bit variants of ODBC, and any one application will generally only support one of the two. For example, Focus only supports 16-bit ODBC, whereas Office 95 only supports 32-bit. ODBC uses the same principle as Print Manager. The application talks generically to a driver, which must be separately acquired and configured. In some cases, ODBC drivers are available as freeware (for example, as supplied with ORACLE, SQL Server, and MS-Access) but others must be purchased. ODBC is often a quick and cheap solution, but the long term cost of ownership (the administration, for example) and performance issues can be quite high. Dedicated Middleware Some vendors provide connectivity middleware that not only provides
Related Questions
- By using either the main menu / Remote / Connect to Remote Computer, main menu / Remote / Monitor Remote Computers or main menu / Report / Remote Report Wizard feature, EVEREST fails to connect to the remote computer(s) with "Error 10061: Connection refused" error message. How to solve this?
- Can third-party report writers be used with Skills Manager?
- How do report writers typically connect to DBMSs?
