https://bugs.documentfoundation.org/show_bug.cgi?id=103077
--- Comment #6 from Howard Johnson <bridgeportcontrac...@gmail.com> ---
(In reply to robert from comment #5)
> (In reply to Howard Johnson from comment #3)
> > "Have connected to MariaDB ... In odbcinst.ini ... Driver =
> > /usr/lib64/libmyodbc5.so"
> >
> > Thanks, but I think this is the MySQL driver you're pointing to above, not
> > the MariaDB driver (i.e. "lib my odbc..").
> >
> > The MariaDB driver is named: libmaodbc.so (lib ma odbc..).
>
> There is no special libmaodbc available for my system (OepnSUSE 42.1 64bit
> rpm Linux). I use MyODBC-unixODBC instead. Compiled nothing here by myself.
> >
> > ---
> >
> > FYI, I tried to use the MySQL driver here but it crashed when I tried to
> > Test the connection.
> >
> > Which database engine are you using, MariaDB or MySQL?
>
> MariaDB 10.0.27-12.1
> UnixODBC 2.3.1-3.2
>
> So there must be something special with your installed ODBC-configuration.
Thanks.
I have tried to use the MySQL ODBC driver, but with it I could not get ODBC to
work at all, i.e. isql would not connect.
To solve this I got the libmaodbc MariaDB ODBC connector here:
https://mariadb.com/products/connectors-plugins
click <Download MariaDB ODBC driver>
https://mariadb.com/my_portal/download/connector-odbc
Then I selected for Debian/Ubuntu, and:
mariadb-connector-odbc-2.0.12-ga-linux-x86_64.tar.gz
Inside is:
/lib
libmaodbc.so
So I copied the libmaodbc.so file into
/usr/lib/x86_64-linux-gnu/odbc/libmaodbc.so, and set
Driver=/usr/lib/x86_64-linux-gnu/odbc/libmaodbc.so in odbcinst.ini. Then isql
began to work.
Perhaps there is something special about this connector driver, but it is the
one from MariaDB, and I could not get ODBC to work with MariaDB until I
installed it.
I'm also working on trying to get some sort of debug log, but am stalled
because at the moment I don't know how to do this. Will keep working on it.
Thanks for your help.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
