5 messages in com.mysql.lists.dotnetRe: Unhandled Exception: System.Net.S...| From | Sent On | Attachments |
|---|---|---|
| André Pinheiro | 01 Aug 2006 04:43 | |
| Jorge Bastos | 01 Aug 2006 05:52 | |
| André Pinheiro | 01 Aug 2006 06:41 | |
| Jorge Bastos | 01 Aug 2006 06:47 | |
| Jorge Bastos | 01 Aug 2006 07:00 |
| Subject: | Re: Unhandled Exception: System.Net.Sockets.SocketException: |
|---|---|
| From: | André Pinheiro (aemp...@gmail.com) |
| Date: | 08/01/2006 06:41:52 AM |
| List: | com.mysql.lists.dotnet |
i tried using a local mysql server and it did work... so I'll have a talk with my MySQL Server administrator, thanks!
Obrigado Jorge, André Pinheiro
On 8/1/06, Jorge Bastos <mysq...@decimal.pt> wrote:
not a driver problem your mysql server is listening to localhost only so can't be accessed remotly
----- Original Message ----- From: "André Pinheiro" < aemp...@gmail.com> To: <dot...@lists.mysql.com> Sent: Tuesday, August 01, 2006 12:43 PM Subject: Unhandled Exception: System.Net.Sockets.SocketException :
I have a weird error with using C# with MySQL Connector/NET 1.0.7, using .NET 2.0.50727 on Windows XP SP2. I get the following error in all machines except the development machine where all runs smoothly.
Unhandled Exception: System.Net.Sockets.SocketException: 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 at System.Net.Sockets.Socket.Shutdown(SocketShutdown how) at MySql.Data.Common.SocketStream.Read(Byte[] buffer, Int32 offset, Int32 count) at System.IO.BufferedStream.ReadByte() at MySql.Data.MySqlClient.PacketReader.ReadHeader() at MySql.Data.MySqlClient.PacketReader.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.Open () at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection() at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() at MySql.Data.MySqlClient.MySqlPool.GetConnection() at MySql.Data.MySqlClient.MySqlPoolManager.GetConnection (MySqlConnectionString settings ) at MySql.Data.MySqlClient.MySqlConnection.Open() at SQL.SQL_Broker.selectRows(DataSet dataset, String query) in C:\Documents and Setting
s\l52345\Desktop\ListaEspera\framework\dataStorage\sql\SQL_Broker.cs:line
46 at SQL.SQLUtilizador.readLogin(String login) in C:\Documents and Settings\l52345\Deskto p\ListaEspera\framework\dataStorage\sql\SQLUtilizador.cs:line 16 at ListaEspera.ListaEspera.Main(String[] args)
The code that produces this output is just a connection open... as I said it works in the development machine, which the only difference is that it has a 141MB .NET instalation vs the 88MB instalation in the non-working machines, my thought is that the .NET in the development machine is the SDK so it must be bigger.
Anyone has thoughts on this? Don't think the code is necessary as it works on the development machine (which isn't the DB machine), it's just a conn.Open().
Please help or I'll have to change my code to try the ODBC aproach... which I didn't want...