ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / Access via ODBC or OLE DB
  • Overview
  • Notes
  • Special case
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
OLE DB: Required configuration
OLE DBAvailable only with this kind of connection
Overview
To handle a database via OLE DB, the following elements must be installed on the development computer and on the deployment computer:
  • an OLE DB driver (OLEDBORA, ORACLE, ...),
  • MDAC (Microsoft DATA Access Component) version 2.7. minimum.
Notes
  • If MDAC is not installed, only the connection to the OLE DB database will be possible.
  • By default, the setup of WINDEV and WEBDEV proposes to install MDAC 2.7.
    It can also be downloaded from the following site: http://www.microsoft.com/downloads.
Remark: At the time this documentation is written, this module can be distributed freely. The module to download is named: MDAC_TYP.EXE.

Special case

The decimal of the ADO layer used by the OLE DB access is limited to 28 digits. If the value exceeds this limit, it is returned to the database in real format.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help