Connecting to MySQL using Open Office Base via ODBC...

[Gabriel Dragffy]

On Mon, 2007-05-28 at 13:24 -0700, NoOp wrote:
> On 05/29/2007 06:12 AM, Gabriel Dragffy wrote:
> > Connecting OK, but trying to use the query wizard, or create a query
> > gives the error: "The field names from mydatabase.mytable could not be
> > retrieved."
> > I'd really really appreciate any help as I'm totally stumped. Thanks!
> > 
> > 
> 
> Can you explain exactly what you are doing & steps (including OOo
> version & Ubuntu version) etc? I have both the Ubuntu'ized OOo 2.2, the
> OOo 2.2 version, and StarOffice 8 (w/update 6) on Feisty 7.04 and I'll
> be happy to try to reproduce if you can explain in some detail.
> 
> 
> 
Hi

Thanks for the reply.

I installed and correctly configured libmyodbc.

I am using Feisty, and that has OpenOffice 2.2.

So what I do is start up Base. It asks me what database to use. I choose
to "connect to an exisiting database" and select the type as MySQL. I
tell it to connect using ODBC, successfully find the datasource I
defined in the config files and tell it to use that. I can put in my
userame and password, and test the connection - it works, and after I am
shown the main area of Base, where to the left you can choose: "Tables",
"Queries", "Forms", "Reports".

This is where things start to go wrong.
If I click on "Tables", and I double click on one of my tables, a new
windows opens up and it correctly displays my table, including it's
structure and data.

If I go to "Queries" and choose to "Use wizard to create query" I get a
dialogue box pop up saying "the field names for database.table could not
be retrieved". This happens also when I choose to "create query in
design view", "use wizard to create form", "use wizard to create a
report".

Therefore most of the functionality has been blown out of the water :(

The server I am connecting to is on the same LAN, that is also running
Feisty, with an Apache2 server, MySQL, and Samba. As you may have
guessed I use it as a file server and as a testing web server.

Would appreciate any insight. Thank you.

Gabe