Losing connection to server during query



Lo all,

We have recently just moved the db from a socket connection
on the same machine to a port connection on another machine.
The network is a LAN.

I'm getting this error:

Unable to connect to database:DBI
connect('database=tm;host=mysqldb;port=3307','tm',...) failed: Lost
connection to MySQL server during query

I'm not quite sure why it says during the query as it happens during
my connect subroutine which only issues a connect. Anyway, how
might I stop this happening and what server variables (if any) might
I change.
The server is a SMP with 1gb memory, so I have some room for
manouvre.
Any clue, pointers to rtfm much appreciated.

John

.



Relevant Pages

  • RE: Problems with Permissions
    ... And SBS server is only take ... the role of an internal server. ... they are all configured to connected to internal network. ... g. Run the Configure Email and Internet Connection Wizard on SBS server. ...
    (microsoft.public.windows.server.sbs)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Networking Question - VLANs on SBS 2003 Premium SP1
    ... be sure you do not enable any DHCP server in internal network. ... You do not get any issue when you connect the SBS to the old router, ... On the Connection Type page, click Broadband, and then click Next. ...
    (microsoft.public.windows.server.sbs)
  • Re: Is yahoo being hijacked?
    ... I get no server response when query ... > Connection: close ...
    (misc.invest.stocks)
  • Re: Is yahoo being hijacked?
    ... I get no server response when query ... > Connection: close ...
    (misc.invest.stocks)