From owner-freebsd-office@FreeBSD.ORG  Thu Nov  8 07:05:27 2012
Return-Path: <owner-freebsd-office@FreeBSD.ORG>
Delivered-To: freebsd-office@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52])
 by hub.freebsd.org (Postfix) with ESMTP id A650728B
 for <freebsd-office@freebsd.org>; Thu,  8 Nov 2012 07:05:27 +0000 (UTC)
 (envelope-from zaphod@berentweb.com)
Received: from sam.nabble.com (sam.nabble.com [216.139.236.26])
 by mx1.freebsd.org (Postfix) with ESMTP id 84B648FC08
 for <freebsd-office@freebsd.org>; Thu,  8 Nov 2012 07:05:27 +0000 (UTC)
Received: from [192.168.236.26] (helo=sam.nabble.com)
 by sam.nabble.com with esmtp (Exim 4.72)
 (envelope-from <zaphod@berentweb.com>) id 1TWMB4-0006gB-W6
 for freebsd-office@freebsd.org; Wed, 07 Nov 2012 23:05:26 -0800
Date: Wed, 7 Nov 2012 23:05:26 -0800 (PST)
From: Beeblebrox <zaphod@berentweb.com>
To: freebsd-office@freebsd.org
Message-ID: <1352358326988-5759086.post@n5.nabble.com>
Subject: LO Base connection problem
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-BeenThere: freebsd-office@freebsd.org
X-Mailman-Version: 2.1.14
Precedence: list
List-Id: Office applications on FreeBSD <freebsd-office.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/options/freebsd-office>,
 <mailto:freebsd-office-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-office>
List-Post: <mailto:freebsd-office@freebsd.org>
List-Help: <mailto:freebsd-office-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-office>,
 <mailto:freebsd-office-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 08 Nov 2012 07:05:27 -0000

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.