Database drivers changes

New and desupported database drivers.

New database clients supported in Genero 4.01:

  • Microsoft™ ODBC 18 for SQL Server (new ODI driver dbmsnc_18):

    In this version, the generic dbmsnc driver name is an alias for dbmsnc_18. If you don't plan to install Microsoft ODBC 18 and keep using ODBC 17, you must use the dbmsnc_17 ODI driver for Microsoft ODBC 17.

    By default, Microsoft ODBC 18 for SQL Server enables connection encryption, that can lead to the following ODBC error when TLS/SSL certificates are not properly configured:
    [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:1416F086:SSL routines:
    tls_process_server_certificate:certificate verify failed:self signed certificate]
    To disable encryption on Linux platforms, set the following ODBC option in the data source definition file:
    Encrypt = No
    On Microsoft Windows®, set "Connection Encryption" to "Optional" in the 4th panel of the ODBC data source configuration application.

For more details, see Database driver specification (driver).

Databases / ODI drivers desupported in Genero 4.01:

Desupported database server versions:

  • Oracle® Database 12.x (dbmora_12 ODI driver is no longer provided)
  • Generic ODBC ODI driver (dbmodc_3)

Changes in earlier versions

Make sure to check the upgrade notes of earlier versions, to not miss changes introduced in maintenance releases. For more details, see Database drivers changes in BDL 4.00.