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 fordbmsnc_18
. If you don't plan to install Microsoft ODBC 18 and keep using ODBC 17, you must use thedbmsnc_17
ODI driver for Microsoft ODBC 17.Important: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:
To disable encryption on Linux platforms, set the following ODBC option in the data source definition file:[Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:1416F086:SSL routines: tls_process_server_certificate:certificate verify failed:self signed certificate]
On Microsoft Windows®, set "Connection Encryption" to "Optional" in the 4th panel of the ODBC data source configuration application.Encrypt = No
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.