Hi Mickael,

Please always post questions to the list, to help us keep an FAQ up to date and allow for others to search etc.

I have just tested it myself with the following:

Database connection URL: jdbc:mysql://localhost:3306/portal
Database User: tim
Database Password: password

and it worked... so, to get started debugging your issue may I please ask some basic questions:

- You wrote "jdbc:mysql://localhost:3306/databasename" - is your database name correct?  
- You are running the IPT on the same machine as the database?  
- You are using mysql?

Cheers,

Tim


On 11 May 2009, at 10:26, Mickael Graf wrote:

Hi Tim,

I'm trying to create a resource in IPT but I encounter a problem while
creating the link to the database: in "Source Data" it is written under
"SQL Data Sources" I have the message "No Database connected. Please
adjust connection parameters to use SQL sources" while it keeps my
settings correctly. I hope I wrote the jdbc string well:
jdbc:mysql://localhost:3306/databasename.

I surprised because I am using the same parameters as with TAPIRLink in
which I don't have any problem. I don't think I should make any changes
in my grants on my database.

Cheers,
Mickaël

--
---------------------------------
Mickaël Graf
Database developper, GBIF Sweden - http://www.gbif.se
tel: +46 8 5195 4045
mailto:mickael.graf@nrm.se

Swedish Museum of Natural History - http://www.nrm.se
Box 50007
SE-104 05 Stockholm
Sweden