Define Database Connections - Brainware for Invoices - 23.1 - 23.1 - Brainware - external

Brainware for Invoices Installation Guide

Brainware for Invoices

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.

  1. 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.

  2. 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.