| View previous topic :: View next topic |
| Author |
Message |
ogago
General User
Joined: 22 Jul 2004
Posts: 11
|
 Posted: Wed Jul 28, 2004 3:06 am Post subject: Trying to create a Mysql database and using it on OO. |
 |
|
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 |
|
 |
veru
Power User
Joined: 09 Jul 2004
Posts: 80
|
| Posted: Sun Sep 12, 2004 9:36 am Post subject: |
|
|
| 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 |
|
|
|
|
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
|
