Date: Wed, 7 Nov 2012 23:05:26 -0800 (PST) From: Beeblebrox <zaphod@berentweb.com> To: freebsd-office@freebsd.org Subject: LO Base connection problem Message-ID: <1352358326988-5759086.post@n5.nabble.com>
next in thread | raw e-mail | index | archive | help
Hi. I'm trying to connect from *LibreOffice Base* to a MySQL DB on my system. The DB wizard starts up and in step2 - Setup MySQL Connection, I select "Connect Using JDBC (Java)" In step3, There is the "MySQL JDBC driver class" box displaying "com.mysql.jdbc.Driver". When I hit the "Test Class" button, the error message is: "The JDBC driver coulld not be loaded" I assume this is because I have not included Java support for LO in the config file? Also I would like to connect to ODBC databases (my old Access DB's) and messing around in LO, I found the Tools > Options > LO Base > Connections > Connection Pooling (I enabled this) However, the JDBC driver there is named "com.sun.star.comp.sdbc.JDBCDriver", which when entered in the afore mentioned "Test Class" box gives the same error output. I currently have pooling enabled for ODBC, MySQL, JDBC. Do I need to setup the connections externally as well? Something like "ODBC External Data Source Administrator" being used in Linuxland? Thanks for the help. -- View this message in context: http://freebsd.1045724.n5.nabble.com/LO-Base-connection-problem-tp5759086.html Sent from the freebsd-office mailing list archive at Nabble.com.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1352358326988-5759086.post>