Tuto WEBDEV 25

70 Part 2: My first database Direct ODBC access An access via ODBC is using a multi-database access standard. The ODBC layer must be installed on your computer. In most cases, this layer is already installed in the recent Windows versions. This can be checked in the control panel of Windows by selecting "ODBC data source" (or "ODBC administrator" according to the Windows version used). Caution: some databases may not be accessible via this method. If you want to use this type of access, check whether an ODBC driver exists and install this driver if necessary. Only the WLanguage SQL* functions can be used with this type of access. OLE DB access An OLE DB access is an access that uses a multi-database access standard. This type of access is based on MDAC (Microsoft Data Access Component). Caution! If you are using an OLE DB access, MDAC must necessarily be installed on the user computers (version 2.6 or later). Some databases may not be accessible via this method. If you want to use this type of access, check whether an OLE DB driver exists. The WLanguage SQL* and HRead* functions can be used with this type of access. ODBC access via OLE DB In summary, it is a "mix" of OLE DB and ODBC. This is the "heaviest" method and the least efficient one in term of performance. It should not be used on small databases. The WLanguage SQL* and HRead* functions can be used with this type of access.