StarOffice 6.0 and MySQL

François PASCAL

unread,

Nov 29, 2002, 4:21:35 AM11/29/02

to

Just wondering if Adabase in StarOffice 6.0 can connect DIRECTLY to a MySQL base, remote or localhost either (apart through ODBC).
The idea is to use StarOffice as a front-end, form designer and reporting tool for MySQL

If not, any known third party product empowering StarOffice 6.0 to do that ? Or any knowledge of this feature incorporated in a coming version of StarOffice ?

Thanks for any answer.

François PASCAL

unread,

Nov 29, 2002, 4:30:40 AM11/29/02

to

Sanal

unread,

Dec 1, 2002, 11:55:42 PM12/1/02

to

Hi François,

StarOffice can access a wide variety of databases either by native support (for Oracle, DB2, dBase, MS Access 97, Text) or by other databases with an ODBC/JDBC driver.

Unfortunately, we cannot offer further information.

Regards,

Sanal

Sun Microsystems Inc.

"All responses to questions posted in this News group are given on an "as is" basis. We believe the solutions or explanations given here are correct, but do not guarantee that responses will be complete."

Michael Parry-Thomas

unread,

Dec 16, 2002, 4:54:31 PM12/16/02

to

Hi François

We are using mysql as a localhost
Ist Install WinMysqlAdmin 1.4
2nd Install Data sources ODBC I find that Driver 2.50.39.00 mysql ab the best for staroffice this is stable
if you need step by step I can copy the setup by making a pdf file which will consist of imiges from
my setup

mick pt

wurzel

unread,

Jan 11, 2003, 2:44:27 PM1/11/03

to

François PASCAL cast thy voice into the fray:

In OpenOffice.org a native interface to MySQL datasources is being or will
probably be developed, maybe it'll find it's way into StarOffice one day.

wurzel

Milena Ortiz

unread,

Feb 25, 2003, 6:07:17 PM2/25/03

to

Since I can connect a form to a database in sql to be able to modify the fields from the form.

Thank you very much for his response.

Cordially

Milena Ortiz

hennie van ernst

unread,

Apr 3, 2003, 4:04:10 AM4/3/03

to

O.S: SuSE Linux 8.1 Proffesional
Star Office 6.0
MySQL Server Version 3.23.52
MyODBC 2.50.39
----------------------------
I am asked to build a client interface with Star-Office 6.0 and
MySQL data-base.
ODBC:
The ODBC set-up is tested and works correct.
I can select the database in SO and can open it with the
appropriate user and password. The tables and its column types
are reproduced properly.
When updating a row (adding a record in table view,
(edit is enabled), this error message is shown:
[unixODBC][TCX][MyODBC] Column count doesn't match value
count at row. Error inserting new record.
SQL status: HY000 Error code: 1136
It's not possible to update or insert a row.
I have also tried ODBC via libiodbc, but the error is the same.

With further looking:
SO -> Date Source Administration - Data Source - Organize:
The Data source is shown but at trying to activate
Organize this error message occurs:
Could not load the program library libodbc.so or it is
corrupted. The ODBC data source configuration is not available.
? libodbc.so is linked to from a folder which is
in the operating systems PATH environment variable !
----------------------------
With this result i'm afraid that i cannot use StarOffice
in the project because MySQL is not questionned.
Furthermore I cannot imagine that no other user has the
same problem. So my questions are:
Am I doing something wrong ?
Is JDBC working correctly ?
What solutions or bypasses are recommended ?
Truely thanks in advance for any respond,
I am a dedicated SO user but this problem limits its use
and can give preference to other choices in a pioneering project.
Kind regards,
Henny van Ernst
vane...@wxs.nl

James Lee

unread,

Apr 4, 2003, 3:59:42 AM4/4/03

to

On 03/04/03, 10:04:10, "hennie van ernst" wrote regarding Re: StarOffice
6.0 and MySQL:

Some hints to help you:

http://dba.openoffice.org/FAQ/index.html