Public bug reported:
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.
** Affects: libreoffice (Ubuntu)
Importance: Undecided
Status: New
--
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
--
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp
