JDBC tenging
Specifies the options to access a JDBC database.
JDBC dæmi
You can use a JDBC driver class to connect to a JDBC database from LibreOffice. The driver class is provided by the database manufacturer. Two examples of JDBC databases are Oracle and MySQL.
 |
The driver classes must be added to LibreOffice in LibreOffice - PreferencesTools - Options - LibreOffice - Advanced. |
Oracle gagnagrunnur
You can use a JDBC driver to access an Oracle database from Solaris or Linux. To access the database from Windows, you need an ODBC driver.
On UNIX, ensure that the Oracle database client is installed with JDBC support. The JDBC driver class for the Solaris Oracle client version 8.x is located in the <Oracle client>/product/jdbc/lib/classes111.zip directory. You can also download the latest version from the Oracle web site.
In the Data source URL box, enter the location of the Oracle database server. The syntax of the URL depends on the database type. See the documentation that came with the JDBC driver for more information.
For an Oracle database, the syntax of the URL is:
oracle:thin:@vél:gátt:heiti_gagnagrunns
-
hostname is the name of the machine that runs the Oracle database. You can also replace hostname with the IP address of the server.
-
port is the port where the Oracle database listens. Ask your database administrator for the correct port address.
-
database_name is the name of the Oracle database. Ask your database administrator for the correct name.
MySQL gagnagrunnur
The driver for the MySQL database is available on the MySQL web site.
The syntax for a MySQL database is:
mysql://vél:gátt/heiti_gagnagrunns
-
hostname is the name of the machine that runs the MySQL database. You can also replace hostname with the IP address of the server.
-
port is the default port for MySQL databases, namely 3306.
-
database_name is the name of the database.
Slóð á gagnagjafa URL
Enter the URL for the database. For example, for the MySQL JDBC driver, enter "jdbc:mysql://<Servername>/<name of the database>". For more information on the JDBC driver, consult the documentation that came with the driver.
JDBC klasarekill
Enter the name of the JDBC driver.
 |
Áður en þú getur notað JDBC rekil, verður að bæta slóðinni við fyrir klasana. Veldu LibreOffice - KjörstillingarVerkfæri - Valkostir - LibreOffice- Nánar, og smelltu á hnappinn Klasaslóð. Eftir að þú hefur bætt við slóð, endurræstu LibreOffice. |
Prufuklassi
Tests the connection with the current settings.