[SOLUCIONADO] Problema con C# y MYSQL

omar0989 · #1 (**permalink**) 21/11/2012, 07:57

Hola, tengo un problema, intento conectarme a una base de datos en mysql en un servidor remoto, en la computadora del usuario tengo un túnel SSH con PuTty, supuesta mente, conectándome desde el localhost me conecta al servidor, pero no es así C# Arroja que la excepción OVERFLOW no ha sido controlada y que la operación aritmética a provocado un desbordamiento.

Código:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data.MySqlClient;

namespace ConsoleApplication2
{
    class Program
    {
        static void Main(string[] args)
        {

            MySqlConnection Conexion = new MySqlConnection("Server=localhost; Database = administracion; Uid=admin; Pwd=mypassword;");
            try
            {
                Conexion.Open();
            }
            catch (MySqlException ex)
            {
                MessageBox.Show(Convert.ToString(ex));
            }

        }
    }
}

Esto es la ventana de inmediato.

Primera excepción del tipo 'System.OverflowException' en MySql.Data.dll
System.Transactions Critical: 0 : <TraceRecord xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord" Severity="Critical"><TraceIdentifier>http://msdn.microsoft.com/TraceCodes/System/ActivityTracing/2004/07/Reliability/Exception/Unhandled</TraceIdentifier><Description>Excepción no controlada</Description><AppDomain>ConsoleApplication2.vshost. exe</AppDomain><Exception><ExceptionType>System.Overflo wException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType><Message>La operación aritmética ha provocado un desbordamiento.</Message><StackTrace> en MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.HandleAuthChange(MySqlPacket packet)
en MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.Authenticate(Boolean reset)
en MySql.Data.MySqlClient.NativeDriver.Authenticate(S tring authMethod, Boolean reset)
en MySql.Data.MySqlClient.NativeDriver.Open()
en MySql.Data.MySqlClient.Driver.Open()
en MySql.Data.MySqlClient.Driver.Create(MySqlConnecti onStringBuilder settings)
en MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on()
en MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
en MySql.Data.MySqlClient.MySqlPool.GetConnection()
en MySql.Data.MySqlClient.MySqlConnection.Open()
en ConsoleApplication2.Program.Main(String[] args) en c:\Users\Admin\Documents\Visual Studio 2012\Projects\ConsoleApplication2\ConsoleApplicati on2\Program.cs:línea 19
en System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
en System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
en Microsoft.VisualStudio.HostingProcess.HostProc.Run UsersAssembly()
en System.Threading.ThreadHelper.ThreadStart_Context( Object state)
en System.Threading.ExecutionContext.RunInternal(Exec utionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
en System.Threading.ExecutionContext.Run(ExecutionCon text executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
en System.Threading.ExecutionContext.Run(ExecutionCon text executionContext, ContextCallback callback, Object state)
en System.Threading.ThreadHelper.ThreadStart()</StackTrace><ExceptionString>System.OverflowExcepti on: La operación aritmética ha provocado un desbordamiento.
en MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.HandleAuthChange(MySqlPacket packet)
en MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.Authenticate(Boolean reset)
en MySql.Data.MySqlClient.NativeDriver.Authenticate(S tring authMethod, Boolean reset)
en MySql.Data.MySqlClient.NativeDriver.Open()
en MySql.Data.MySqlClient.Driver.Open()
en MySql.Data.MySqlClient.Driver.Create(MySqlConnecti onStringBuilder settings)
en MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on()
en MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
en MySql.Data.MySqlClient.MySqlPool.GetConnection()
en MySql.Data.MySqlClient.MySqlConnection.Open()
en ConsoleApplication2.Program.Main(String[] args) en c:\Users\Admin\Documents\Visual Studio 2012\Projects\ConsoleApplication2\ConsoleApplicati on2\Program.cs:línea 19
en System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
en System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
en Microsoft.VisualStudio.HostingProcess.HostProc.Run UsersAssembly()
en System.Threading.ThreadHelper.ThreadStart_Context( Object state)
en System.Threading.ExecutionContext.RunInternal(Exec utionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
en System.Threading.ExecutionContext.Run(ExecutionCon text executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
en System.Threading.ExecutionContext.Run(ExecutionCon text executionContext, ContextCallback callback, Object state)
en System.Threading.ThreadHelper.ThreadStart()</ExceptionString></Exception></TraceRecord>
ConsoleApplication2.vshost.exe Error: 0 : La operación aritmética ha provocado un desbordamiento.
Primera excepción del tipo 'System.OverflowException' en MySql.Data.dll
System.Transactions Critical: 0 : <TraceRecord xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord" Severity="Critical"><TraceIdentifier>http://msdn.microsoft.com/TraceCodes/System/ActivityTracing/2004/07/Reliability/Exception/Unhandled</TraceIdentifier><Description>Excepción no controlada</Description><AppDomain>ConsoleApplication2.vshost. exe</AppDomain><Exception><ExceptionType>System.Overflo wException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType><Message>La operación aritmética ha provocado un desbordamiento.</Message><StackTrace> en MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.HandleAuthChange(MySqlPacket packet)
en MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.Authenticate(Boolean reset)
en MySql.Data.MySqlClient.NativeDriver.Authenticate(S tring authMethod, Boolean reset)
en MySql.Data.MySqlClient.NativeDriver.Open()
en MySql.Data.MySqlClient.Driver.Open()
en MySql.Data.MySqlClient.Driver.Create(MySqlConnecti onStringBuilder settings)
en MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on()
en MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
en MySql.Data.MySqlClient.MySqlPool.GetConnection()
en MySql.Data.MySqlClient.MySqlConnection.Open()
en ConsoleApplication2.Program.Main(String[] args) en c:\Users\Admin\Documents\Visual Studio 2012\Projects\ConsoleApplication2\ConsoleApplicati on2\Program.cs:línea 19
en System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
en System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
en Microsoft.VisualStudio.HostingProcess.HostProc.Run UsersAssembly()
en System.Threading.ThreadHelper.ThreadStart_Context( Object state)
en System.Threading.ExecutionContext.RunInternal(Exec utionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
en System.Threading.ExecutionContext.Run(ExecutionCon text executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
en System.Threading.ExecutionContext.Run(ExecutionCon text executionContext, ContextCallback callback, Object state)
en System.Threading.ThreadHelper.ThreadStart()</StackTrace><ExceptionString>System.OverflowExcepti on: La operación aritmética ha provocado un desbordamiento.
en MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.HandleAuthChange(MySqlPacket packet)
en MySql.Data.MySqlClient.Authentication.MySqlAuthent icationPlugin.Authenticate(Boolean reset)
en MySql.Data.MySqlClient.NativeDriver.Authenticate(S tring authMethod, Boolean reset)
en MySql.Data.MySqlClient.NativeDriver.Open()
en MySql.Data.MySqlClient.Driver.Open()
en MySql.Data.MySqlClient.Driver.Create(MySqlConnecti onStringBuilder settings)
en MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on()
en MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
en MySql.Data.MySqlClient.MySqlPool.GetConnection()
en MySql.Data.MySqlClient.MySqlConnection.Open()
en ConsoleApplication2.Program.Main(String[] args) en c:\Users\Admin\Documents\Visual Studio 2012\Projects\ConsoleApplication2\ConsoleApplicati on2\Program.cs:línea 19
en System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
en System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
en Microsoft.VisualStudio.HostingProcess.HostProc.Run UsersAssembly()
en System.Threading.ThreadHelper.ThreadStart_Context( Object state)
en System.Threading.ExecutionContext.RunInternal(Exec utionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
en System.Threading.ExecutionContext.Run(ExecutionCon text executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
en System.Threading.ExecutionContext.Run(ExecutionCon text executionContext, ContextCallback callback, Object state)
en System.Threading.ThreadHelper.ThreadStart()</ExceptionString></Exception></TraceRecord>

De antemano gracias.