Open Office has 64-bit versions so using a 64-bit version of Java with it would make the instructions just as valid.
On May 16, 2020 at 7:59:52 AM, Joost Andrae (joost.and...@gmx.de) wrote: Hi, if you have installed a 32 bit java (I would recommend Java 8 in this case and it should be 32 bit because OpenOffice is 32 bit) and you've connected OpenOffice with the installed Java via menu item tools->options->OpenOffice->Java then you can setup a JDBC remote connection to your database click on "Database" on the OpenOffice dashboard check the "connect to an existing database" radio button then click on "Next >>>" button place your cursor into the field "Datasource URL" and press the F1 key where this kind of unified resource locator (URL) is discribed more deeply (eg. mysql://hostname:port/database_name) If you run both your desktop PC and your notebook within the same network you have to check the IP address (or hostname) of your system you want to connect to Checking the IP address of this system: press the Windows button (start menu) type cmd and open the command line type ipconfig /ALL note the IPv4 address because this is the address you have to add to the hostname part of the datasource URL You have to know the port address of the database and you have to know the name (eg. accounting) of your database you want to connect to. Maybe you need to install a database driver on your client system. This driver has to be selected then. An alternate variant can be the connection using a ODBC connection This connection has to be configured within the ODBC settings dialog (search for ODBC in Windows system settings). Once set up within your Windows system the configuration within OpenOffice is quite similar. Kind regards, Joost Am 16.05.2020 um 09:50 schrieb Jose Molina: > Im trying to connect to a database created on my laptop running on windows 10 > pro and trying to connect it so I can open it on my desktop running on > windows 10 home. How does one do that, exactly? > > Sent from my iPhone > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
