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

Hi Ian,
To be honest - I am somewhat confused regarding the issue of "where is the
native connector"! It might be that going to extensions and then download/installing
the native connector (for OpenOffice) does the trick. On the other hand, I think
that it should come automatically with the newest versions of LO. The definition
of a natively connected MySQL database goes as follows:
- (1) connect to an existing database, then select "MySQL" from the drop-down
      list (JDBC is shown as the first item in that list! MySQL is third from
      bottom in my case)
- (2) on the next dialog box select "direct connection" (direkte Verbindung in
      German)
- (3) on the next dialog box specify the database name, server name, IP-address
      or localhost (127.0.0.1) and port (usually 3306) or else the socket file
      (possible in case of a local server)
- (4) then specify the username and whether a password has to be given on
      connection
- (5) then store the odb-file.
Hope this is of use to you...
Regards
H
P.S.: It's already getting warmer here again! This usually coincides with
      bad weather in Italy which in turn causes warm winds to come across
      the Alps


On Wed, 31 Oct 2012 17:25:25 +0100, Ian Whitfield <whitfield@telkomsa.net> wrote:

> On 10/31/2012 05:27 PM, Heinrich Stoellinger wrote:
> > Just one question: the "native" MySQL-Connector should be included in
> > 3.6.2. I had a lot of trouble in the past with it, but now it seems to be
> > the best choice of all the possible connectors (Native, ODBC, JDBC).
> > In any case, reading through your steps - I think that
> > - the database name should be the name of the database as defined in the
> >   create database statement of MySQL
> > - did you specify the correct path for the jdbc-connector?
> > Regards (from snowed-in Salzburg)
> > Heinz
> Hi Heinz
>
> Thanks for info....
> So where is the "native" connector file?
> Database name IS as specified in MySQL and is as saved - but I added the
> path as well (?)
> The connector comes up automatically when you "register" it in Base.
>
> (Sorry about your snow!! 25C here and sunny!!
>
> IanW
> Pretoria SA


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