Got it. Many thanks stew
On Wed, 2005-10-26 at 21:37 -0400, Stew Schneider wrote: > Well, here's a bit more information. The reason my user name is being > rejected is that OOo is adding '@Lenny' to the end of it, and mysql is > rejecting that. > > Anybody know how to address that? > > stew > > On Wed, 2005-10-26 at 20:46 -0400, Stew Schneider wrote: > > 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]
