Results 1 to 6 of 6

Thread: LibreOffice Base fails to connect to remote mariadb

  1. #1

    Default LibreOffice Base fails to connect to remote mariadb

    Having tried unsuccessfully to my remote mariadb from LibreOffice Base under Leap 15.0, I am still having problems under Leap 15.1. My LO version is 6.1.3.2.

    The JDBC and ODBC drivers 'fail to load'.

    Can someone please point me in the right direction to troubleshoot this problem systematically?

    I have no problem to connect to the remote database with, say, Mysql workbench or phpMyAdmin from the same client desktop, so the database is accessible.

    (By the way, this problem is highlighted also in a thread under LEAP 15.0, so please excuse me for opening the thread anew here. I had no success under 15.0 either)

  2. #2
    Join Date
    Jun 2008
    Location
    Groningen, Netherlands
    Posts
    19,845
    Blog Entries
    14

    Default Re: LibreOffice Base fails to connect to remote mariadb

    Just a guess: maybe you need the mariadb-connector-odbc package?
    ° Appreciate my reply? Click the star and let me know why.

    ° Perfection is not gonna happen. No way.

    https://en.opensuse.org/openSUSE:Board#Members
    http://en.opensuse.org/User:Knurpht
    http://nl.opensuse.org/Gebruiker:Knurpht

  3. #3

    Default Re: LibreOffice Base fails to connect to remote mariadb

    Quote Originally Posted by Knurpht View Post
    Just a guess: maybe you need the mariadb-connector-odbc package?
    What is the syntax for the name of the 'ODBC data source'?

    I am getting the error "SQL Status: IM002 [unixODBC][Driver Manager]Data source name not found, and no default driver specified"

    Cheers and thanks for your help

    hn

  4. #4
    Join Date
    Nov 2009
    Location
    West Virginia Sector 13
    Posts
    15,743

    Default Re: LibreOffice Base fails to connect to remote mariadb

    Does it need to be installed maybe???

  5. #5

    Default Re: LibreOffice Base fails to connect to remote mariadb

    Quote Originally Posted by gogalthorp View Post
    Does it need to be installed maybe???
    Installation of the mariadb-connector-odbc package was the first thing I checked! It had been there all right.

    What needed to be installed for the jdbc alternative was the mysql-connector-java.

    However, whereas I can now connect successfully with jdbc to the database, my existing (LO) input forms won't let me change the data.The form controls are completely deactivated.

  6. #6
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    11,273
    Blog Entries
    2

    Default Re: LibreOffice Base fails to connect to remote mariadb

    Quote Originally Posted by hnimmo View Post
    Installation of the mariadb-connector-odbc package was the first thing I checked! It had been there all right.

    What needed to be installed for the jdbc alternative was the mysql-connector-java.

    However, whereas I can now connect successfully with jdbc to the database, my existing (LO) input forms won't let me change the data.The form controls are completely deactivated.
    Without extensive experience specifically with LO/mariadb but plenty setting up and using various database connections to various RDBMS,

    If you're not able to modify the data, then it's likely a permissions problem.
    You say you are able to connect using MySQL Workbench, use that to query the grants table and specific table objects, and to modify as needed.

    TSU
    Beginner Wiki Quickstart - https://en.opensuse.org/User:Tsu2/Quickstart_Wiki
    Solved a problem recently? Create a wiki page for future personal reference!
    Learn something new?
    Attended a computing event?
    Post and Share!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •