On the Database Connection screens, you must define the database connection string to the Brainware for Invoices configuration database and then the Brainware for Invoices Reporting database. If you chose to have the installer create the database, you must also define the database name. BFI Installer supports TLS 1.2 so that the current standard protocols can be used to secure the environment.
To define database connections, complete the following steps.
Click the Change button within the Database
Connection screens. A dialog appears and allows you to create
the connection by selecting the database type (either Oracle or
SQL Server), server name, and authentication method. You can also
test the connection from this dialog.
If database tables already exist, a warning message is displayed. You must manually remove the existing database tables, select a new database to continue, or abort the installation. The installer cannot be used to overwrite existing database tables.
Click OK to acknowledge the warning and then do
any of the following:
Click Cancel to go back to change your connection string.
Manually remove the existing database tables.
Select a new database.
Abort the installation process.
The installer cannot be used to overwrite existing database tables.
The OLE DB provider referenced during installation is only used to determine whether the database is SQL Server or Oracle. The actual provider used is System.Data.SQLClient for SQL Server and Oracle.ManagedDataAccess for Oracle databases.