One More Try.... Can't See Data From MySQL Database

[mbramble]

I have tried using both ODBC and JDBC but am still having no luck.

When I connect using the ODBC driver, I don't even see the tables in the database when I select Tables in the OO Base interface. Nothing shows at all....

Using isql I can connect using "isql mytest mike "password" " and it connects with no problem. I can type "use mysql;" to open the mysql database; "show tables;" does in fact show tables and a simple query "select host from user;" shows a list of hosts from the user table -- as expected.

This is the .odbc.ini in my home directory:
[MyTest]
Driver = MySQL
DATABASE = mysql
DESCRIPTION = mysql database
PWD =
SERVER = localhost
UID = mike

/etc/odbc.ini is the same
-------------------------------------------------------------
When I connect using JDBC, the tables do show up but I am able to see no data. Whenever I double click a particular table to open it up, I get an error that talks about an illegal operation on an empty table. The tables do have data in them.

Please help!!!!!

I am using Mandrriva 2006 and OOo 2 provided by Mandriva....