Hi,
Yes, this is very much a beginners question. I started struggling with Birt I'm and connecting to my database for the first time.
I installed a fresh download of Eclipse (eclipse-reporting-galileo-SR2-win32.zip) and tried to connect to a database that was set aside for me on a Virtual Private Server. I asked what version of mySQL is used (5.0), and installed the appropriate jar file (com.mysql.jdbc.Driver (driver v5.1)).
Next I had to find out what to fill in for the Driver URL. According to the help information I had to use the following format:
jdbc: odbc:<data source name>
I saw other documents that instructed me to use:
jdbc: odbc:
@<host>:<port>:<service>
So I tried:
jdbc: odbc:
@mydatabase.subdomain.domain.org:3306
and after pinging mydatabase.subdomain.domain.org I even tried
jdbc: odbc:
@10.11.12.13:3306
(and I even omitted the port)
But when I tested it I got the following error:
The selected driver cannot parse the given url.
(Very much a NullPointerException, sigh)
What does "The selected driver cannot parse the given url" tell me? That there is no connection possible to my system, residing on the system with the mydatabase.subdomain.domain.org address? Anyone an answer?
Abel
