https://bugs.documentfoundation.org/show_bug.cgi?id=65830

--- Comment #40 from Lionel Elie Mamane <[email protected]> ---
(In reply to Beluga from comment #39)
> (In reply to Lionel Elie Mamane from comment #34)
> > 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 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         = 

The "Driver = ..." line must match the section name in odbcinst.ini (where you
put "unixODBC" which is a bit weird). In other words, the Driver line in my
instructions assumes that the corresponding driver section is called "MySQL",
but you called it "unixODBC". Also, it seems unusual to me that the "Setup = "
line maps to unixodbc's libodbcinst.so instead of a myodbc .so file; my entry
has "Setup=libodbcmyS.so"; that's on Debian GNU/Linux FWIW.

> LibO kept complaining about missing libodbc.so.1, so I had to
> link /usr/lib64/libodbc.so.2 /usr/lib64/libodbc.so.1

This sounds like LibreOffice is compiled for a different libodbc than what you
have... Usually, when the .so has a different name, it means it is an
incompatible version, and simply linking one to the other WILL NOT WORK (or can
seem to work, but lead to crashes, data corruption, etc).

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

Reply via email to