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