<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi Mickael,<div><br></div><div>Please always post questions to the list, to help us keep an FAQ up to date and allow for others to search etc.</div><div><br></div><div>I have just tested it myself with the following:</div><div><font class="Apple-style-span" color="#333333" face="'Lucida Grande'"><span class="Apple-style-span" style="white-space: pre;"><br></span></font></div><div><span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family: 'Lucida Grande'; white-space: pre; "><b>Database connection URL</b>: jdbc:mysql://localhost:3306/portal</span></div><div><font class="Apple-style-span" color="#333333" face="'Lucida Grande'"><span class="Apple-style-span" style="white-space: pre;"><b>Database User</b>: tim</span></font></div><div><font class="Apple-style-span" color="#333333" face="'Lucida Grande'"><span class="Apple-style-span" style="white-space: pre;"><b>Database Password</b>: password</span></font></div><div><font class="Apple-style-span" color="#333333" face="'Lucida Grande'"><span class="Apple-style-span" style="white-space: pre;"><br></span></font></div><div><font class="Apple-style-span" color="#333333" face="'Lucida Grande'"><span class="Apple-style-span" style="white-space: pre;">and it worked... so, to get started debugging your issue may I please ask some basic questions:</span></font></div><div><font class="Apple-style-span" color="#333333" face="'Lucida Grande'"><span class="Apple-style-span" style="white-space: pre;"><br></span></font></div><div><font class="Apple-style-span" color="#333333" face="'Lucida Grande'"><span class="Apple-style-span" style="white-space: pre;">- You wrote "<span class="Apple-style-span" style="color: rgb(0, 0, 0); font-family: Helvetica; white-space: normal; ">jdbc:mysql://localhost:3306/databasename" - is your database name correct? </span></span></font></div><div><font class="Apple-style-span" color="#333333" face="'Lucida Grande'"><span class="Apple-style-span" style="white-space: pre;"><span class="Apple-style-span" style="color: rgb(0, 0, 0); font-family: Helvetica; white-space: normal; ">- You are running the IPT on the same machine as the database? </span></span></font></div><div><font class="Apple-style-span" color="#333333" face="'Lucida Grande'"><span class="Apple-style-span" style="white-space: pre;"><span class="Apple-style-span" style="color: rgb(0, 0, 0); font-family: Helvetica; white-space: normal; ">- You are using mysql?</span></span></font></div><div><br></div><div>Cheers,</div><div><br></div><div>Tim</div><div><br></div><div><br><div><div>On 11 May 2009, at 10:26, Mickael Graf wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Hi Tim,<br><br>I'm trying to create a resource in IPT but I encounter a problem while<br>creating the link to the database: in "Source Data" it is written under<br>"SQL Data Sources" I have the message "No Database connected. Please<br>adjust connection parameters to use SQL sources" while it keeps my<br>settings correctly. I hope I wrote the jdbc string well:<br>jdbc:mysql://localhost:3306/databasename.<br><br>I surprised because I am using the same parameters as with TAPIRLink in<br>which I don't have any problem. I don't think I should make any changes<br>in my grants on my database.<br><br>Cheers,<br>Mickaël<br><br>-- <br>---------------------------------<br>Mickaël Graf <br>Database developper, GBIF Sweden - <a href="http://www.gbif.se">http://www.gbif.se</a> <br>tel: +46 8 5195 4045 <br><a href="mailto:mickael.graf@nrm.se">mailto:mickael.graf@nrm.se</a><br><br>Swedish Museum of Natural History - http://www.nrm.se<br>Box 50007 <br>SE-104 05 Stockholm <br>Sweden<br><br><br></div></blockquote></div><br></div></body></html>