Base as a stand alone refers to embedded databases (the database
data is contained in the database file. This type of database can lose data.
However, this does not mean that you have to use MySQL,
Presgresql, or Oracle, ... Nor do you have to install a JDBC or ODBC
driver for Base to connect to the data. Base includes its own JDBC
driver. Everything you need is included in the installed Base files.
The last section of Chapter 3 of the Base Guide discusses how to
extract the data from an embedded database and connect to this data
using Base. (The data becomes an external data source. I don't have time
right now to upload this to the LO Wiki, but I will be doing it in about
6 hours or so. Warning: it is a draft copy, but you are free to study it
and make any suggestions or comments about it.
On 11/06/2012 04:34 AM, Pertti Rönnberg wrote:
Hello LibO experts,
and congratulations IanW!
It has been very interesting to follow this discussion getting Base
working with MySQL.
Unfortunately -- if I got it right - is Ian's OS a Linux (Ubuntu?)
Would it be possible to get the same proceeding described as a
step-by-step instruction for Windows7 (64bit)?
> in plain english (no IT-jargong)
> starting from the very beginning defining the different programs
(versions) and components (ODBC, JDBC, JRE, etc when needed, included)
to be installed
Since Andreas Säger (one of LibO db-experts) last winter and spring
repeatedly pointed out that LibO/Base is not to be considered as a
stand-alone database program I have several times tried to create the
connection LibO/Base to SQLite and to MySQL (I prefer SQLite as
lighter than MySQL), but without success.
I am sure that such an instruction could increase the acceptance and
usability of LibO and
I am sure that we are many that would be happy.
On 6.11.2012 9:54, Steve Edmonds wrote:
On 2012-11-06 20:41, Ian Whitfield wrote:
If you can get your data out of the old database as a csv file it is
real easy to load into MySQL.
You can use the command line MySQL command or if you install webmin
it makes database admin easy.
Thanks Guys!! (Girvin, Henirich, Dan, Mas and maybe others!!)
You have all added some pieces to the Jigsaw and I'm pleased to
*I now have Base working with a MySQL Database!!!! (at last!!)*
As Girvin would say "My Bad"!! I had been looking for the file
'my.cfg' when it should have been 'my.cnf'. This was the last
missing piece, once I found it and found the "skip-networking" line
inside it and commented it out everything worked fine.
So once again guys - thanks for sticking with me - awesome support
and I do appreciate it!!
Now the fun starts - I have already designed my Form yesterday but
now need to puzzle out how to get all my data out of the old DB into
the new SQL DB. And then re-write all my Queries and reports.
Greatly appreciated - regards from South Africa
For unsubscribe instructions e-mail to: firstname.lastname@example.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Connecting LO Base to an SQL DB · Dan Lewis
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy