|
Re: Connecting BIRT to Remote MySQL Server [message #700096 is a reply to message #700092] |
Fri, 22 July 2011 20:35 |
|
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.
|
|
|
|
Re: Connecting BIRT to Remote MySQL Server [message #700372 is a reply to message #700103] |
Sat, 23 July 2011 09:08 |
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.
|
|
|
Powered by
FUDForum. Page generated in 0.03264 seconds