MyODBC across Firewall

MyODBC across Firewall

am 19.04.2005 00:44:48 von Daniel Kolm

------=_NextPart_000_002F_01C5444F.14B15BC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear,

I tried to use the MySQL ODBC 3.51 driver on Windows XP and across a =
ZoneAlarm Firewall, and it pass on conection test (Test button), but =
failed on selecting the database.

When the Firewall is turned off, the ODBC connector works fine.

I think the problem can be a TCP port used by ODBC on client computer =
wich has been blocked.

Anybody may help me, please?

Thanks,

Daniel
------=_NextPart_000_002F_01C5444F.14B15BC0--

Re: MyODBC across Firewall

am 19.04.2005 05:55:15 von Joe Bloggs

Daniel Kolm wrote:
> Dear,
>
> I tried to use the MySQL ODBC 3.51 driver on Windows XP and across a ZoneAlarm Firewall, and it pass on conection test (Test button), but failed on selecting the database.
>
> When the Firewall is turned off, the ODBC connector works fine.
>
> I think the problem can be a TCP port used by ODBC on client computer wich has been blocked.
>
> Anybody may help me, please?
>
> Thanks,
>
> Daniel
Try opening tcp port 3306 on the firewall, or alternately, making MyODBC
a "trusted" application and giving it full access. I would advise making
sure that there are passwords on all your MySQL databases first though.
I don't use ZoneAlarm, so I couldn't tell you how to allow MyODBC to
have free reign, but there should be some information in the help.

Good luck


--
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: MyODBC across Firewall

am 19.04.2005 09:52:05 von Shaoul Jacobson - TELLINK

Hi,

> Try opening tcp port 3306 on the firewall, or alternately,
> making MyODBC a "trusted" application and giving it full access.

Last possibility, make the server a trusted host.
And all those advices together.

Regards,

Shaoul Jacobson
Senior VoIP Consultant
Tellink
Tel : +32 3 201 96 36
Fax : +32 3 227 09 81
e-mail shaoul@tellink.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