https://bugs.documentfoundation.org/show_bug.cgi?id=65830
Beluga <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #39 from Beluga <[email protected]> --- (In reply to Lionel Elie Mamane from comment #34) > 1) Install MySQL or MariaDB, or secure access to a server. > > 2) Install MyODBC (from OpenSUSE 12.3) > > 3) In MySQL connection: > > CREATE DATABASE fdo65830; > use fdo65830; > > 4) replay the SQL script in attachment 81091 [details] > (e.g.: > SCRIPT /path/to/libretest.sql; > ) Did this on openSUSE 13.2 64-bit with MariaDB 10.0.13, MyODBC 5.1.8, unixODBC 2.3.2. Running the script was with: \. /home/test/libretest.sql > 5) In ~/.odbc.ini, add something like: My ~/.odbc.ini is: [ODBC Data Sources] myodbc5 = MySQL ODBC 5.1.8 Driver DSN [fdo65830] Description = fdo#65830 test DB Driver = MySQL Server = 127.0.0.1 Database = fdo65830 Port = 3306 Socket = Option = 3 ReadOnly = No I got help from Mechtilde on IRC and used this guide with modifications: http://mechtilde.de/mysql2ooo20/howtomysql2ooo20.html I also have an /etc/unixODBC/odbcinst.ini: [unixODBC] Description = ODBC Driver for Unix Driver = /usr/lib64/libmyodbc5.so Setup = /usr/lib64/libodbcinst.so FileUsage = 1 CPTimeout = CPReuse = > 6) libreoffice --base > (use a 4.x TDF build, not OpenSUSE build) > > 7) "Connect to an existing database" > Next >> > > 8) Connection using ODBC (Open Database Connectivityà > Next >> > LibO kept complaining about missing libodbc.so.1, so I had to link /usr/lib64/libodbc.so.2 /usr/lib64/libodbc.so.1 > 9) Browse / Select "fdo65830" in list, OK, Next >> The list is empty. I'm stuck, what should I do? -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
