remote database  
Author Message
Darko Jovisic





PostPosted: 2004-2-21 8:33:00 Top

java-programmer, remote database Hello!

I'm quite new to Java. I'm making an MySQL interface. So my problem is:

Can I connect to a remote mysql database without having any additional
software running on that server ?
Is JDBC part of JVM ?

I know these are silly questions, but you would help me a great deal.

Thank you!

Darko


 
Ryan Stewart





PostPosted: 2004-2-21 11:59:00 Top

java-programmer >> remote database "Darko Jovisic" <email***@***.com> wrote in message
news:c168vh$dor$email***@***.com...
> Hello!
>
> I'm quite new to Java. I'm making an MySQL interface. So my problem is:
>
> Can I connect to a remote mysql database without having any additional
> software running on that server ?
> Is JDBC part of JVM ?
>
> I know these are silly questions, but you would help me a great deal.
>
> Thank you!
>
> Darko
>
>
http://java.sun.com/docs/books/tutorial/

Especially:
http://java.sun.com/docs/books/tutorial/jdbc/index.html


 
Alan Liu





PostPosted: 2004-2-22 0:07:00 Top

java-programmer >> remote database You can download the mysql JDBC driver. I don't remember where I got it.
Add the MySQL JDBC jar file to your classpath and follow the tutorial below.
"Ryan Stewart" <email***@***.com> wrote in message
news:email***@***.com...
> "Darko Jovisic" <email***@***.com> wrote in message
> news:c168vh$dor$email***@***.com...
> > Hello!
> >
> > I'm quite new to Java. I'm making an MySQL interface. So my problem is:
> >
> > Can I connect to a remote mysql database without having any additional
> > software running on that server ?
> > Is JDBC part of JVM ?
> >
> > I know these are silly questions, but you would help me a great deal.
> >
> > Thank you!
> >
> > Darko
> >
> >
> http://java.sun.com/docs/books/tutorial/
>
> Especially:
> http://java.sun.com/docs/books/tutorial/jdbc/index.html
>
>


 
 
Tales Mein





PostPosted: 2006-1-24 2:19:00 Top

java-programmer >> remote database How do I handle the situation where the website and Sql server are at the
remote site, and I sit here in my underpants at home.

I can get to the website, but how do i browe or connect the data from here.

thanks


 
 
QWxiZXJ0IFBhc2N1YWw





PostPosted: 2006-1-24 2:36:00 Top

java-programmer >> remote database Terminal Service

"Tales Mein" wrote:

> How do I handle the situation where the website and Sql server are at the
> remote site, and I sit here in my underpants at home.
>
> I can get to the website, but how do i browe or connect the data from here.
>
> thanks
>
>
>
 
 
Tales Mein





PostPosted: 2006-1-24 3:35:00 Top

java-programmer >> remote database well how do i browse the data and set up sql connections thru the remote IDE


"Albert Pascual" <email***@***.com> wrote in message
news:email***@***.com...
> Terminal Service
>
> "Tales Mein" wrote:
>
>> How do I handle the situation where the website and Sql server are at the
>> remote site, and I sit here in my underpants at home.
>>
>> I can get to the website, but how do i browe or connect the data from
>> here.
>>
>> thanks
>>
>>
>>


 
 
Raymond





PostPosted: 2006-1-24 5:30:00 Top

java-programmer >> remote database You generally get the server name, uid, pwd and connect to it
from Enterprise Manager by registering it. And you may need to
use TCP/IP instead named pipes. Have you tried registering the server
in EM?


"Tales Mein" <email***@***.com> wrote in message
news:email***@***.com...
> How do I handle the situation where the website and Sql server are at the
> remote site, and I sit here in my underpants at home.
>
> I can get to the website, but how do i browe or connect the data from
here.
>
> thanks
>
>


 
 
Luca





PostPosted: 2006-7-8 1:26:00 Top

java-programmer >> remote database I'have Easy PHP in localhost and i need connect php page (local) to remote
database:

$db_host = "62.149.225.23";
$db_user = "gfo";
$db_password = "gfo";
$db_name = "gfonline";
$db = mysql_connect($db_host, $db_user, $db_password);

The browser show this message:

Warning: mysql_connect(): Can't connect to MySQL server on '62.149.225.23'
(10061) in e:\php\gfonline.it\provaremoto.php on line 7

Bye
Luca


 
 
Alvaro G. Vicario





PostPosted: 2006-7-8 2:24:00 Top

java-programmer >> remote database *** Luca escribi?wrote (Fri, 7 Jul 2006 19:26:04 +0200):
> $db_host = "62.149.225.23";
> $db_user = "gfo";
> $db_password = "gfo";
> $db_name = "gfonline";
> $db = mysql_connect($db_host, $db_user, $db_password);
>
> The browser show this message:
>
> Warning: mysql_connect(): Can't connect to MySQL server on '62.149.225.23'
> (10061) in e:\php\gfonline.it\provaremoto.php on line 7

Does mysql_error() provide further info?


--
-+ http://alvaro.es - 羖varo G. Vicario - Burgos, Spain
++ Mi sitio sobre programaci髇 web: http://bits.demogracia.com
+- Mi web de humor con rayos UVA: http://www.demogracia.com
 
 
David Haynes





PostPosted: 2006-7-8 2:31:00 Top

java-programmer >> remote database Luca wrote:
> I'have Easy PHP in localhost and i need connect php page (local) to remote
> database:
>
> $db_host = "62.149.225.23";
> $db_user = "gfo";
> $db_password = "gfo";
> $db_name = "gfonline";
> $db = mysql_connect($db_host, $db_user, $db_password);
>
> The browser show this message:
>
> Warning: mysql_connect(): Can't connect to MySQL server on '62.149.225.23'
> (10061) in e:\php\gfonline.it\provaremoto.php on line 7
>
> Bye
> Luca
Can you connect using the mysql command line?
If not, check for firewall ports and remote db server running.

-david-

 
 
Jerry Stuckle





PostPosted: 2006-7-8 3:00:00 Top

java-programmer >> remote database Luca wrote:
> I'have Easy PHP in localhost and i need connect php page (local) to remote
> database:
>
> $db_host = "62.149.225.23";
> $db_user = "gfo";
> $db_password = "gfo";
> $db_name = "gfonline";
> $db = mysql_connect($db_host, $db_user, $db_password);
>
> The browser show this message:
>
> Warning: mysql_connect(): Can't connect to MySQL server on '62.149.225.23'
> (10061) in e:\php\gfonline.it\provaremoto.php on line 7
>
> Bye
> Luca
>
>

Sounds like the db server isn't listening on the default port, or a
firewall is blocking your access.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
email***@***.com
==================