Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Connecting BIRT to Remote MySQL Server(Need help on making MySQL connection, if feasible.)
Connecting BIRT to Remote MySQL Server [message #700092] Fri, 22 July 2011 16:30 Go to next message
Selena is currently offline Selena
Messages: 2
Registered: July 2011
Junior Member
I have multiple databases I have had no trouble properly connecting to on my laptop, but I have one on my work server that I need to connect to. I can't make a database dump because the MySQL database is too large for my laptop at this point in time. Does anyone have any suggestions for getting BIRT to connect remotely to the server and accessing the database?

I have previously used the com.mysql.jdbc.Driver (v5.1) on my laptop to connect locally to databases. Need more insight on this if anyone has it.
Re: Connecting BIRT to Remote MySQL Server [message #700096 is a reply to message #700092] Fri, 22 July 2011 16:35 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Does setting the jdbc url to point to the remove machine not work?

Jason

On 7/22/2011 4:30 PM, Selena wrote:
> I have multiple databases I have had no trouble properly connecting to
> on my laptop, but I have one on my work server that I need to connect
> to. I can't make a database dump because the MySQL database is too large
> for my laptop at this point in time. Does anyone have any suggestions
> for getting BIRT to connect remotely to the server and accessing the
> database?
>
> I have previously used the com.mysql.jdbc.Driver (v5.1) on my laptop to
> connect locally to databases. Need more insight on this if anyone has it.


Jason Weathersby

BIRT Exchange
Re: Connecting BIRT to Remote MySQL Server [message #700103 is a reply to message #700096] Fri, 22 July 2011 16:57 Go to previous messageGo to next message
Selena is currently offline Selena
Messages: 2
Registered: July 2011
Junior Member
The database is on a server that I don't have administrative privileges over. I am simply needing to generate some reports from the database stored on there. I have tried with the standard URL, but I sense that maybe I can't access it because I don't have administrative rights. Could this be an issue? Here is a couple of examples that I have previously tried

Quote:
jdbc:MySQL://someserver.com/someDB


and

Quote:
jdbc:MySQL://someserver.com:port#/someDB
Re: Connecting BIRT to Remote MySQL Server [message #700372 is a reply to message #700103] Sat, 23 July 2011 05:08 Go to previous message
Eclipse User
Originally posted by: Donkey Hottie

22.7.2011 23:57, Selena kirjoitti:
> The database is on a server that I don't have administrative privileges
> over. I am simply needing to generate some reports from the database
> stored on there. I have tried with the standard URL, but I sense that
> maybe I can't access it because I don't have administrative rights.
> Could this be an issue? Here is a couple of examples that I have
> previously tried
>
> Quote:
>> jdbc:MySQL://someserver.com/someDB
>
>
> and
>
> Quote:
>> jdbc:MySQL://someserver.com:port#/someDB
>

Administrative rights is not an issue here. But two factors are:

1) is the MySQL listening on its network interface? Often it is put to
listen only localhost, for security reasons.

2) firewall? Is the MySQL opened for external access? If the server is
on internet, probably not.

--

Afternoon very favorable for romance. Try a single person for a change.
Previous Topic:APIs error conection
Next Topic:Birt 3.7 OdaException
Goto Forum:
  


Current Time: Wed Apr 16 06:40:44 EDT 2014

Powered by FUDForum. Page generated in 0.17527 seconds