← Back to team overview

desktop-packages team mailing list archive

[Bug 833741] Re: libreoffice base problem connecting mysql with various schema

 

Thank you for reporting this bug to Ubuntu. This Ubuntu release has reached EOL for Desktops.
See this document for currently supported Ubuntu releases: https://wiki.ubuntu.com/Releases

Please upgrade to the latest version and re-test. If the bug is still
reproducible, please note that and set the status back to New.

Do feel free to report any other bugs you may find.

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/833741

Title:
  libreoffice base problem connecting mysql with various schema

Status in libreoffice package in Ubuntu:
  New

Bug description:
  I use Ubuntu 64bit 11.04 and Libreoffice Base 3.3.3 and mysql 5.1.54
  I have 4 different schema in mysql, each with different tables.
  In LOB I use a form combining tables from different schema for data input.
  I use native mysql connector, from LOB to connect to mysql server, specifying no database name, thus from LOB I had access to all schemas and their corresponding tables.
  The mysql server runs in the same computer as LOB, thus the connection is to "localhost".
  After updating (which solved a tremendous problem with forms in Base) I receive a message of:
  SQL status: 42000 
  Error Code: 1049

  Unknown database 'localhost:3306'

  When opening the forms in LOB (which worked perfectly before!)

  I found that changing the connector to mysql (JDBC) and back to mysql
  (native) I am able to see all schema and tables as before.

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/833741/+subscriptions


References