On Saturday 19 March 2005 00:51, SOTL wrote: > On Friday 18 March 2005 00:10, Andrew Douglas Pitonyak wrote: > > SOTL wrote: > > >On Thursday 17 March 2005 06:14, CPHennessy wrote: > > >>On Wednesday 16 March 2005 01:19, Ennio-Sr wrote: > > >>>Hi all. > > >>>Do understand well that the 1.1.4 capacity to > > >>> connect to an existing database (via the New > > > >>> Spreadsheet > Tools > Data Sources ,etc ...) is no > > >>> longer available in coming OOo-2.0 ? > > >> > > >>The exact steps may not be the same but I'm almost > > >> sure that the functionality is still available ( and > > >> should be easier to use). > > > > > >I am not so sure about that. > > > > > >Yes it is suppose to work go to: File -> New -> > > > Database -> Connect to an existing Database > > > > > >and you should be able to connect. > > > > > >I have been able to connect to a dBase test database I > > > have but I have NOT been able to connect to a test > > > MySQL database I have with no idea of why not so I > > > subscribed to user database list. Unfortunately > > > either that list is dead or something as in 3 days I > > > have received exactly 1 posting saying I was > > > subscribed. > > > > > >Previously I had posted questions concerning that very > > > issue on this list without receiving comments which > > > is a good indicator that database issue are not on > > > the top of people's list of issues at the present > > > time. > > > > > >Frank > > > > Are you using ODBC or JDBC? I did some limited testing > > today and I was able to connect to a MySQL database > > using the latest production JDBC driver. I added a > > brief descriptions, complete with pictures an arrows to > > my web site. Let me know after you have it so that I > > can remove it from my web site. > > > > http://www.pitonyak.org/MySQLTest.sxw > > > > At which step do things fail for you? > > Well the issues start with line 3 of your Chapter on > Databases and Tables which states that one must have Java > installed. > > I checked and this computer does have Java installed. I > would have been greatly surprised if I had not of > installed it when I installed the system but I check > anyway. > > I also checked to see if OO recognizes that java is > installed. OO does not even though Java was installed > when OO-1.9 was installed. So first issue is how do I get > OO-1.9 to recognize Java? > > Second I noted that I need to use a new JDBC driver which > I know is not installed. So installing this driver is the > second issue with making connections function. > > Any suggestion would be helpful.
The whole thread seems to have been overcomplicated. For MySQL you only need the .jar class file available from mysql.com, not the whole jdbc folder. I know I'm not allowed to attach files to a mailing list but mail me and I'll send you the file if you like. It really is as simple as that. Cheers, Steve. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
