Connecting to an established MySQL database

[jgnfld]

I have developed a large database that takes in data from student forms (~200 fields, many of them binary T-F responses). I have been using MySQL query browser and phpMyAdmin to view fields and to cut out data for processing in SPSS/Calc/etc. but I am looking at something a little more user friendly so others can use the system. The database is in MySQL 5.0, Windows XP, and I am using the MySQL ODBC drivers.

I can connect to my database in Base, but I can only perform operations using the SQL queries portion of Base. I cannot find any trick for seeing the tables and viewing the fields in any more native mode. All of the examples I see relate to making up a new database from scratch. What am I missing? How do I view the tables and fields so that I can construct forms and reports???

Thanks for any help out there.

[r4zoli]

What version of OOo and ODBC driver you use?
I has problem on 2.3.0 OOo with ODBC driver, see: http://qa.openoffice.org/issues/show_bug.cgi?id=83681, which is connected to http://qa.openoffice.org/issues/show_bug.cgi?id=81661.
and breaking down issue with 5.1.1 driver: http://qa.openoffice.org/issues/show_bug.cgi?id=85861

[jgnfld]

"What version of OOo and ODBC driver you use?"

Windows ODBC driver 3.51.23
OpenOffice 2.3.1 (full installation)

MySQL:

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 29
Server version: 5.0.41-community-nt MySQL Community Edition (GPL)

[r4zoli]

My mysql 5.0.27 and ODBC 3.51.23, and OOO 2.3.0 and Dev 2.4 I can connect and manipulate data.
If you double click or right click on table name you can open it.
Some wikis and other sources:
http://wiki.services.openoffice.org/wiki/Base
http://neowiki.neooffice.org/index.php/ ... Back_Again
http://neowiki.neooffice.org/index.php/NeoBase
Forms, and programming:
http://www.geocities.com/rbenitez22/OOo/