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