Re: [libreoffice-users] Connecting LO Base to an SQL DB [SOLVED]

Hello Pertti,
Just for "kicks": I used to personally know some of the "old" IBMers who
actually "invented" SQL, in particular DB2. That's a long time ago though...
I have LO running on Linux-Debian, Linux-Mint, and Windows/Vista (32 Bit).
The MySQL server runs on Linux, the clients run on all of these systems
(locally and LAN- or broadband-Internet-attached).
As I mentioned before, I have taken to using the native MySQL connector
preferably. It is faster and in my view somewhat less "buggy". Besides,
I keep reading in the mail lists that LO intends to "minimise" the
dependence on Java. The native connector comes included in the Windows-LO
version as far as I remember. So all you have to do is define your connection
for it (connect to a MySQL-database and then specify that you want to use the
native connector (the other possibilities on the respective dialog box being
JDBC or ODBC)).
The LO-Base definitions on the client side are basically the same as for the
Linux-version. I used to run the MySQL server also on Windows but have not done
so for a long time. If I remember correctly, my.cnf is called my.ini (or maybe
mysql.ini) in "true" Windows fashion. Again, the definitions in that file
should not be THAT different from the Linux situation (except - maybe -
the stuff concerning sockets/pipes).
Regards from Austria
Heinrich

On Tue, 06 Nov 2012 10:34:10 +0100, Pertti Rönneberg <ptjr@elisanet.fi> 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.
> Regards
> Pertti Rönnberg
>
>
>
> On 6.11.2012 9:54, Steve Edmonds wrote:
> > On 2012-11-06 20:41, Ian Whitfield wrote:
> > > Thanks Guys!! (Girvin, Henirich, Dan, Mas and maybe others!!)
> > >
> > > You have all added some pieces to the Jigsaw and I'm pleased to
> > > say......
> > >
> > > *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
> > >
> > > IanW
> > > Pretoria RSA.
> > 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.
> > Steve


--
Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/

--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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