I just found the answer to my question and am posting it in the event
anyone else is having the same problem. The answer was found in an OO
forum at this url: http://tinyurl.com/qap7s
Basically, when opening an existing MySQL database, select "Connect to
an existing database" and then use the drop down menu to select "MySQL."
On the next screen, click on "connect using JDBC." Next screen: type in
the name of the database exactly as it is in MySQL, the Server URL is
localhost the port number is 3306 and the MySQL JDBC Driver Class is
com.mysql.jdbc.Driver. Add the username and password when prompted.
That's all there is to it. I think I had used these before, but perhaps
I'd made a mistake in typing in the data. Anyway, seems to be working now.
Thanks to those who took the time to respond.
On 2/21/2006 10:55 AM, Bob wrote:
I'm a relative newbie to MySQL, but have been using OO for some time.
Just upgraded to OO 2.x and installed MySQL 5.0.X (neither are beta
versions).
I have several MySQL databases, and would like to use OO to generate
reports from those existing databases, but am unable to connect to the
DBs. Both are nothing fancy, just single tables. I've followed the
spartan directions in OO Help, and the ODBC and JODBC connections
indicate they're loaded.
I've searched the MySQL and OO web sites for specific assistance, but
can't find anything that helps.
Can anyone here point me in the right direction?
Thanks.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
