Connection and disconnection

For a local database, like Microsoft Access, connect to a database means open the MDB file, while for a remote database, like MySQL, MariaDB, Oracle or Microsoft SQL Server, it means connect to a internet address, specifying the database name (schema name) and the own credentials (user name and password).
Thus, for MDB files, select the item "Open local database" from the Database menu, otherwise, select the item "Connect remote database" from the same menu.
In both cases, a dialog window will appear, as shown in the figure below:

graphic

The information that should be supplied into this dialog window are:

·     Address Name : the internet address where the database is placed.
·     Server Name : available only with Microsoft SQL Server, can be leave blank.
·     Database Name : name of database instance (or schema).
·     Type of database : can be MySQL, MariaDB, SQL Server or Oracle
·     Authentication :
·     Trusted authentication : available only with SQL Server.
·     User ID and password : your credentials.


For the disconnect from database, select the item "Close / Disconnect database" from the Database menu.