Calc/Base remote connection

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

Calc/Base remote connection

Postby pastorusa » Thu Jan 22, 2015 4:53 am

Maybe I am looking for the connection string. If I take a copy of the spreadsheet and transfer it to another box other than the server, how would I be able to input and retrieve information.


Box 1 = Server, Mysql, Open Office Base. Box 2 = Spread sheet Box = 3 Spread sheet etc. How do I get the client to communicate with the server "Mysql".
ubuntu 10.04 - openoffice 3.2
pastorusa
 
Posts: 2
Joined: Wed Jan 21, 2015 2:23 am

Re: Calc/Base remote connection

Postby MTP » Thu Jan 22, 2015 5:37 pm

It sounds like you have the connection between Base and MySQL setup and working?
And you are connecting over a local network where all the computers can 'see' the Base file on the server?

In that case, just 'register' the Base file on all the computers (Tools->Options->Expand 'OpenOffice Base', click on 'Databases', press the "New" button and navigate to the Base file). Then every spreadsheet can connect to the 'registered' Base file, which has the connection already to MySQL.
OpenOffice 4.1.1 on Windows 10, HSQLDB 1.8 split database
User avatar
MTP
Volunteer
 
Posts: 1618
Joined: Mon Sep 10, 2012 7:31 pm
Location: Midwest USA


Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 2 guests