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

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