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

On 10/31/2012 07:28 PM, Heinrich Stoellinger wrote:
> 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 
Thanks again Heinz

But I think we must have different versions of LO. Your 'Step 1' is OK 
for the first part, (and it's what I did before), but the second part 
here only gives me the options...

   o Connect using ODBC
   o Connect using JDBC

   So knowing the JDBC does not work I tried ODBC but that gives me....

       /Could not load the program library libodoc.so.1 or it is corrupted.
       The ODBC data source selection is not available./

       A search on my Hard Drive for 'libodoc' finds nothing and also
       Synaptic does not find it. I than looked under the Extension
       Manager in LO and found the 'Native Connector' written by my
       friend Alex Thurgood, (who seems to have vanished off eMail at
       the moment!!). But I see it is only a Pre-release for Ubuntu and
       I'm running PCLinuxOs - so will it work on my machine and if so
       do I just download it or what?

       IanW
       Pretoria SA.



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