JDBC and ODBC Connections

rahulkjha

Hi,

I have MySQL Database on Linux. I am accessing the database from Windows to develop report on Actuate BIRT Report Designer. When I use JDBC-ODBC bridge, I am able to see the entire schema with all the tables, views, stored procedures etc. But when I define a data set, the performance goes for a toss and it gets hang.

Then I tried using direct JDBC driver for MySQL. I supply the following information in the URL:

IP:Port/<DB Name>

This time it says Unknown Database <DB Name>. When I am able to see and access the same database while using JDBC-ODBC driver as explained above. Why am I getting this error?

Then I remove the <DB Name> from the URL. Then connection gets successful. But while defining Data Set, it does not show any tables or views. Why?

Please let me know if there are any connection set up I have been missing somewhere.

Regards,
Rahul