Actually, I hit Enter prematurely, before I worked out that problem with a lucky Google hit. I then wrote the second note, viz.
> Here's where I am now: The system is FC3. I got lucky with google and > found that com.mysql.jdbc.Driver is the correct entry for JDBC driver > class, and jdbc:mysql://localhost:3306/customer_orders is the correct > entry for URL. I can now fill in the dialog. > > BUT...when I attempt to test the connection, OOo replies that access > is > denied for user '@Lenny'. In other words, even though I enter a user > name in the box, OOo isn't picking it up, and is trying to connect to > MySQL as a blank user. Sorry for the inconvenience. Shaky fingers, I guess. Any suggestions on the name recognition problem? stew On Wed, 2005-10-26 at 20:30 -0400, Andrew Douglas Pitonyak wrote: > 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. > >>> > >>> > >>> > >>> > >>> > -- Stew Schneider WMMT's Dutchman at 88.7 in the coal fields, http://appalshop.org on the net On CD at http://CDBaby.com/Foot --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
