OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Trying to create a Mysql database and using it on OO.

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
ogago
General User
General User


Joined: 22 Jul 2004
Posts: 11

PostPosted: Wed Jul 28, 2004 3:06 am    Post subject: Trying to create a Mysql database and using it on OO. Reply with quote

Hi

I would like to try a MYSQL database with OO.

Can anyone give me one adress, login and passwords, of a data source that I can use?

I'm doing a project wich will need a online database.

I'm probing with an local dbase, but I would like to try it for "real" !

---

I have found a website where you can create a MySQL database for free,

http://www.freesql.org/

however I can't conect OOwith the database.

I have tried using J3:

Should I use this configuration (the database calls itself 01fotobase )

sdbc:mysql:jdbc:<www.freesql.org>:<3306>/<01fotobase>
or
sdbc:mysql:jdbc:www.freesql.org:3306/01fotobase

Error: The specified driver could not be found Error code 1000 and Error code -1

When using existing MyOBDC datasource and configuring it to:

sdbc:mysql:jdbc:www.freesql.org:3306/01fotobase

It tells me to verify username and password, but they are OK.

How should I do it, or learn how to do it?

Best regards

Ogago
_________________
ogago
Back to top
View user's profile Send private message
veru
Power User
Power User


Joined: 09 Jul 2004
Posts: 80

PostPosted: Sun Sep 12, 2004 9:36 am    Post subject: Reply with quote

Quote:
sdbc:mysql:jdbc:www.freesql.org:3306/01fotobase

is the right one

Quote:
Error: The specified driver could not be found Error code 1000 and Error code -1


Looks ike the JDBC driver isn't in your Classpath.
You have to go to extras | options, select OpenOffice.org | safety. There's a field called classpath. Click on browse, then on add and navigate to the JDBC driver and select the jar-file. Close OOo completely, restart it and try again to connect to your database.
(perhaps some buttons called slightly different, I only have a german version)

Verena
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group