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

2012-11-07 Thread Mas
On Tue, Nov 6, 2012 at 2:41 AM, 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"!!

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

2012-11-06 Thread Girvin R. Herr
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!!)* IanW Pretoria RSA. Ian, Glad to hear you got it working. For imp

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

2012-11-06 Thread Tom Davies
libreoffice.org >Sent: Tuesday, 6 November 2012, 19:38 >Subject: Re: [libreoffice-users] Connecting LO Base to an SQL DB [SOLVED] > >http://wiki.documentfoundation.org/Documentation/Publications > >    This is the link to the LibreOffice guides. The Base section contain >lin

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

2012-11-06 Thread Dan Lewis
http://wiki.documentfoundation.org/Documentation/Publications This is the link to the LibreOffice guides. The Base section contain links to the first 3 chapters of the Base Guide. Chapter 1 has been published. Chapter 2 & 3 are still in draft form. --Dan (Eastern US) On 11/06/2012 10:29

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

2012-11-06 Thread Pertti Rönnberg
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:

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

2012-11-06 Thread Dan Lewis
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

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

2012-11-06 Thread Dan Lewis
On 11/06/2012 02:41 AM, 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

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

2012-11-06 Thread Heinrich Stoellinger
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 t

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

2012-11-06 Thread John Clegg
The way I extracted my data was to right-click on each table and copy, and then open a new spreadsheet and paste. Once in the spreadsheet you can then save as CSV for easy importing into MYSQL. On 6 November 2012 10:10, Ian Whitfield wrote: > On 11/06/2012 11:34 AM, Pertti Rönnberg wrote: > >>

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

2012-11-06 Thread Ian Whitfield
On 11/06/2012 11: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 proceedi

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

2012-11-06 Thread Pertti Rönnberg
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

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

2012-11-05 Thread Steve Edmonds
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 f

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

2012-11-05 Thread Ian Whitfield
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 be