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

Thank you Dan, IanW and Heinrich
for your kind answering and encouraging!
The other day when some spare time I shall study your advice and try again.

Is it not fantastic that we like this can discuss things all across the 
word!!!
Pertti Rönnberg (Finland)


On 6.11.2012 15:12, Dan Lewis wrote:
> 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.
>
> --Dan
>
>
> 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.
> > 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


--
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