Now finish the connection to your database.Ĭhoosing 'Yes, register the database for me' will let you save a connection file to your database, which you can use later on to access your PostgreSQL database in LibreOffice Calc, and to edit your non-spatial data.Įnabling 'Open the database for editing' will take you directly to your data in LibreOffice Base Next, add your username if prompted, and test the connection if you want. For more information on the JDBC driver, consult the documentation that came with the driver.Host=servername dbname=databasename user=username password=****** For example, for the MySQL JDBC driver, enter "jdbc:mysql:///". Port is the default port for MySQL databases, namely 3306.ĭatabase_name is the name of the database.Įnter the URL for the database. You can also replace hostname with the IP address of the server. Hostname is the name of the machine that runs the MySQL database. The driver for the MySQL database is available on the MySQL web site. Ask your database administrator for the correct name. Ask your database administrator for the correct port address.ĭatabase_name is the name of the Oracle database. Port is the port where the Oracle database listens.
See the documentation that came with the JDBC driver for more information.įor an Oracle database, the syntax of the URL is the name of the machine that runs the Oracle database. The syntax of the URL depends on the database type. In the Data source URL box, enter the location of the Oracle database server. You can also download the latest version from the Oracle web site. The JDBC driver class for the Solaris Oracle client version 8.x is located in the /product/jdbc/lib/classes111.zip directory. On UNIX, ensure that the Oracle database client is installed with JDBC support. To access the database from Windows, you need an ODBC driver.
You can use a JDBC driver to access an Oracle database from Solaris or Linux.
The driver classes must be added to LibreOffice in LibreOffice - Preferences Tools - Options - LibreOffice - Advanced.
0 kommentar(er)
