The default database connection method for OnBase servers and applications requires ADO.NET connection strings. An ODBC connection is still required for the OnBase Client and the OnBase Configuration module.
A connection string contains the information required to connect to a database, and each connection string has a unique identifying name for that data source connection. This unique data source name is referenced by other applications to connect to the database configured in the connection string.
Data source connection strings are configured in the configuration file of the application used to connect directly to the database. For example, the connectionStrings element in the Application Server web.config file contains a data source connection string for each database that the Application Server accesses. Other applications using the Application Server, such as the Unity Client or Web Server, access the database by referencing the unique data source name from the relevant connection string.
As of OnBase 18, the default database connection method for the Application Server and other Core-based applications is ADO.NET connection strings. The Application Server no longer supports ODBC connections to connect to the OnBase database. If you are upgrading from version 17 or earlier, you must update data source connections in the Application Server to use connection strings. In addition, any applications that connect to the database using the Application Server must also be updated to reference the name of the Application Server's data source connection string instead of an ODBC data source name.
Beginning in OnBase Foundation 24.1, any ADO.NET connection strings for Microsoft SQL Server databases enforce encryption by default. If you are upgrading from a previous version of OnBase, you must ensure the encryption settings for both your database server and your ADO.NET connection strings are compatible. For example, when using a SQL Server database, the connectionString element in your Application Server's web.config file must use either the Encrypt=Mandatory (default) string token to only allow encrypted connections to the database server or the Encrypt=Optional string token to allow unencrypted connections. These string tokens correspond to the older Encrypt=True or Encrypt=Yes tokens and the older Encrypt=False or Encrypt=No tokens used in previous versions of OnBase, respectively.