2 messages in com.mysql.lists.dotnetsocket error when connecting to my se...
FromSent OnAttachments
Steve Klett03 Sep 2006 13:14 
Steve Klett04 Sep 2006 17:44 
Subject:socket error when connecting to my server over the internet
From:Steve Klett (skl@pmddirect.com)
Date:09/03/2006 01:14:20 PM
List:com.mysql.lists.dotnet

MySql 5 Running Windows Server 2003 .Net connector 2 .Net 2

I've been happily developing on the LAN with our MySql server. I recently tried to run our application which uses the MySql server for it's back end outside the LAN and I'm getting the following exception: e = {"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"}

I have what I believe to be the correct ports opened up on our router and I can connect to the server with MySql Administrator and MySql QueryBrowser over the internet.

I've googled the exception with the added text "MySql" and found VERY few results. One result was a thread from this list that states: "not a driver problem your mysql server is listening to localhost only so can't be accessed remotly"

I have mixed feeling on this. If I can connect via QueryBrowser wouldn't this indicate that networking is enabled on the server? Plus I have checked the server settings and from what I can tell networking is enabled.

I'm not a seasoned DBA and am very new to MySql, so this could be something basic.

Hopefully someone will have a suggestion for me to get this problem solved.

Thanks For reading, Steve