Revelation ODBC Driver.Revelation's ODBC driver enables ODBC compliant applications, such as Crystal Reports, Microsoft Excel, or Microsoft Access, to read OpenInsight's MultiValue Linear Hash data. Revelation's ODBC driver is a read-only driver; the contents of the OpenInsight (or Advanced Revelation) tables can be accessed but not updated through the driver. ODBC is a de-facto standard for passing data back and forth between different Windows-based applications. The Revelation ODBC Driver makes use of OpenInsight's internal SQL processing to quickly and correctly normalise any MultiValued data that is requested. The installation provides a fixed number of ODBC connections to the OpenInsight Database at any point in time. The driver needs to be installed on the workstations that will be accessing your OpenInsight databases using the ODBC-compliant database and it can be configured either as a System or User DSN. It is licensed on a per user, per serial number basis. A Technical Note:The Revelation ODBC Driver is for OpenInsight versions 7.1 and above. Those wishing to provide ODBC access to earlier OpenInsight and Advanced Revelation (ARev) data may do so by taking advantage of the fact that OpenInsight can access ARev version 3.1 and higher data tables with no change or affects on the data, providing that there are no dots (.) in the file or field names. In our experience, the only difficulty has been with those applications that have field or column names that are reserved SQL keywords. The documentation provided with the Revelation ODBC Driver lists some of the more commonly used SQL keywords in Revelation systems, such as DESC, ALL, and GROUP. | |
|
