Stew Schneider wrote:
I think I'm understanding this more poorly than even I thought. File|
New|Database gives me three possibles:
a. Create a new database
As in... you want to create new tables to hold data that will be stored
in a Base document.
b. Open and existing database (which shows DocketControl as a recently
used database)
Yes, open a Base document that already exists...
c. Connect to an existing database.
As in connect to an existing MySQL, dBase, Calc, etc.... database and
then use a Base document to connect to it.
If I choose b, and DocketControl, I'm taken to a file dialog. I choose
DocketControl.odb, and all seems well until I try to access a table. At
that point, I'm asked for a password. If I enter my MySQL password for
that db, it refuses it.
If I choose c. and JDBC, I'm asked for a URL, to which I have answered
mysql://localhost:3306/customer_orders. I'm then to enter JDBC Driver
class. I do not know what is expected here. I googled for it, and found
that com.mysql.jdbc.Driver should work. It was accepted with a dialog
saying "Java driver loaded" or some such
So, you are saying that you are indeed able to load the JDBC driver, but
then you still can not connect... Is this correct? I actually wrote some
JDBC code using Java to test things out.
On Tue, 2005-10-25 at 22:02 -0400, Andrew Douglas Pitonyak wrote:
If you did this once, then you should have it set in your OOo classpath.
Do you see anything there? In other words, it sounds to me like you are
saying that you are indeed able to connect to one instance. Are you
certain that you are not using ODBC for that connection?
Stew Schneider wrote:
1. File|New|Database leads to a dialog. I have chosen to connect to an
existing database via JDBC. I am asked for the URL, and supply
mysql://localhost:3306/customer_orders. Next, I'm asked for JDBC Driver
class. What's it expecting? System is FC3, OOo installed from your site,
not via yum. HOWto's refer to a .jar file, but I cannot discern which
one I should use.
2. Apparently, I did do this once because I can connect to another mysql
db called Docket Control. However, it will not accept the password for
it. I can connect to this DB from the command line with this password.
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.sxw
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info: http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
