Accessing remote mysql server behind ISA 2004 Firewall

Hi there,

The setup I have here is as follows: SBS 2003 box running ISA 2004, my
client PC is Win XP running the Microsoft Firewall Client.

I CAN connect to the remote mysql server on port 3306 using the MySQL
Query Browser, so it seems that the port is open. That rules that one
out.

However, when I try and run a local website (so that I can debug etc) I
can't access the remote mysql server, I get two different errors:

1) When using the MySQL Connector: A request to send or receive data
was disallowed because the socket is not connected and (when sending on
a datagram socket using a sendto call) no address was supplied

2) When using the Mysql ODBC driver: ERROR [HYT00] [MySQL][ODBC 3.51
Driver]Can't connect to MySQL server on 'remote.server.name' (10050)

If I bypass the ISA server then it connects fine, so it's obviously
something to do with that. Has anybody come across this before, or have
any ideas how to solve this, as it's a bit of a pain having to upload
the files each time to test, and also to be without debugging.

I could run a local copy of MySQL on the same machine, but I would
rather just have the data in one place.

Thanks in advance

Andy

Cancel that, I've just allowed everyone to route out, rather than just
SBS users - I knew I'd figure it out two minutes after posting, always
the way!!


fools...@yahoo.com wrote:
> Hi there,
>
> The setup I have here is as follows: SBS 2003 box running ISA 2004, my
> client PC is Win XP running the Microsoft Firewall Client.
>
> I CAN connect to the remote mysql server on port 3306 using the MySQL
> Query Browser, so it seems that the port is open. That rules that one
> out.
>
> However, when I try and run a local website (so that I can debug etc) I
> can't access the remote mysql server, I get two different errors:
>
> 1) When using the MySQL Connector: A request to send or receive data
> was disallowed because the socket is not connected and (when sending on
> a datagram socket using a sendto call) no address was supplied
>
> 2) When using the Mysql ODBC driver: ERROR [HYT00] [MySQL][ODBC 3.51
> Driver]Can't connect to MySQL server on 'remote.server.name' (10050)
>
> If I bypass the ISA server then it connects fine, so it's obviously
> something to do with that. Has anybody come across this before, or have
> any ideas how to solve this, as it's a bit of a pain having to upload
> the files each time to test, and also to be without debugging.
>
> I could run a local copy of MySQL on the same machine, but I would
> rather just have the data in one place.
>
> Thanks in advance
>
> Andy