Can"t connect

Can"t connect

am 23.03.2006 06:57:31 von Dwi Putra L

I have two computer, the computer name is : comp_1 and comp_2

I install mySQL server on comp_1, and ODBC 3.51 on both
computer.

When both computer using windows 2000 as the operating
system, ODBC on comp_2 could connect mySQL server on
comp_1.

Later, I changed the operating system in both computer,
I installed windows XP.

After windows XP installed in both computer, ODBC ion
comp_2 could connect mySQL server on comp_1.

But after I turn off both computer, and turn on them
again. ODBC in comp_2 can not connect mySQL server on
comp_1.

The error messages is : Can't connect mySQL server on comp_1 (10060)

Anybody could tell me, what is wrong ?, and what should
I do.

Thanks

_dwi.







--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: Can"t connect

am 23.03.2006 16:34:11 von Markus Grossrieder

Hi Dwi,

could be the XP firewall (activated by default),
try the following:
- on your server (comp_1), open Control Panel, Network Connections
- right-click your active connection and select Properties
- click the Advanced tab
- click Settings for Windows Firewall
- click the Exceptions tab
- if there is no MySQL entry:
- click Add Port
- type MySQL in the Name
- type 3306 in the Port number (if you're connecting to port 3306 ...)
- click Change scope
- choose My network (subnet)
- click 2 times ok
- be sure the MySQL entry is activated
- while still in the Windows Firewall window, click Advanced
- click Settings in the ICMP section
- activate Allow incoming echo request (this will allow comp_1 to be pinged)
- click ok until everything is closed

Now try again ... HTH,
Markus

----- Original Message -----
From: "Dwi Putra L"
To:
Sent: Thursday, March 23, 2006 6:57 AM
Subject: Can't connect


>I have two computer, the computer name is : comp_1 and comp_2
>
> I install mySQL server on comp_1, and ODBC 3.51 on both
> computer.
>
> When both computer using windows 2000 as the operating
> system, ODBC on comp_2 could connect mySQL server on
> comp_1.
>
> Later, I changed the operating system in both computer,
> I installed windows XP.
>
> After windows XP installed in both computer, ODBC ion
> comp_2 could connect mySQL server on comp_1.
>
> But after I turn off both computer, and turn on them
> again. ODBC in comp_2 can not connect mySQL server on
> comp_1.
>
> The error messages is : Can't connect mySQL server on comp_1 (10060)
>
> Anybody could tell me, what is wrong ?, and what should
> I do.
>
> Thanks
>
> _dwi.
>
>
>
>
>
>
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe:
> http://lists.mysql.com/myodbc?unsub=markus.grossrieder@alba- systems.com
>
>




--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: Can"t connect

am 24.03.2006 10:34:24 von Dwi Putra L

Markus Grossrieder wrote:

>....
>
>could be the XP firewall (activated by default),
>try the following:
>- on your server (comp_1), open Control Panel, Network Connections
>- right-click your active connection and select Properties
>

I followed your instruction.

And now ODBC on comp_2 can connect to MySQL server
on comp_1.

Markus, thank you very much.


_dwi.



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org