Problems MySQLDirect.NET Mobile

Problems MySQLDirect.NET Mobile

Postby Korku » Thu 15 Mar 2007 10:01

Hello,

Code: Select all
Imports CoreLab.MySql

Dim oMySqlConn As MySqlConnection = New MySqlConnection()
oMySqlConn.ConnectionString = _
    "User ID=root;" & _
    "Password=;" & _
    "Host=192.168.0.1;" & _
    "Port=3306;" & _
    "Database=test;" & _
    "Direct=true;" & _
    "Protocol=TCP;" & _
    "Compress=false;" & _
    "Pooling=true;" & _
    "Min Pool Size=0;" & _
    "Max Pool Size=100;" & _
    "Connection Lifetime=0"
oMySqlConn.Open ()


¿Is correct?

It does not work me. Attempt to connect Pocket PC with the laptop by means of AD-HOC (I have access LAN and Internet) but does not connect to me. I have open port 3306

Greetings
Korku
 
Posts: 27
Joined: Wed 14 Mar 2007 14:40
Location: Spain

Postby Alexey » Thu 15 Mar 2007 10:29

Please describe the problem in detail. The connection string you provided is OK. Check your hardware connection.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Korku » Thu 15 Mar 2007 23:51

I obtained It! The solution is grant leave with this syntax:

Code: Select all
GRANT ALL ON *.* TO root IDENTIFIED BY '';


Greetings
Korku
 
Posts: 27
Joined: Wed 14 Mar 2007 14:40
Location: Spain

Postby Alexey » Fri 16 Mar 2007 07:31

Well done!
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Korku » Fri 16 Mar 2007 17:12

I am testing and I have found an error...

When I have the database ignited shows to me that it is connected but I extinguish it says to me that is connected (it would have to say to me that it is disconnected).

Another serious error, having the database extinguished, I open the application and when trying to connect closes the program, error: NullReferenceException.

The code is the following one:

In module:

Code: Select all
Imports System
Imports System.Drawing
Imports System.Collections
Imports System.Windows.Forms
Imports System.Data
Imports System.Data.Common
Imports System.IO
Imports System.Runtime.InteropServices
Imports CoreLab.MySql

Module basPublico
    Public conn As New MySqlConnection("User ID=root;Password=;Host=192.168.0.1;Port=3306;Database=k008;")

    Public Sub ArrancarConexion()

        Try
            conn.Open()
            MsgBox("Ok!", MsgBoxStyle.Information, "")
        Catch ex As MySqlException
            MsgBox(ex.Message, MsgBoxStyle.Critical, "")
        End Try

    End Sub
End Module


In Form:

Code: Select all
Public Class Form1
    Inherits System.Windows.Forms.Form
    Friend WithEvents Button1 As System.Windows.Forms.Button
    Friend WithEvents MainMenu1 As System.Windows.Forms.MainMenu

#Region " Código generado por el Diseñador de Windows Forms "

    Public Sub New()
        MyBase.New()

        'El Diseñador de Windows Forms requiere esta llamada.
        InitializeComponent()

        'Agregar cualquier inicialización después de la llamada a InitializeComponent()

    End Sub

    'Form reemplaza a Dispose para limpiar la lista de componentes.
    Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
        MyBase.Dispose(disposing)
    End Sub

    'NOTA: el Diseñador de Windows Forms requiere el siguiente procedimiento
    'Puede modificarse utilizando el Diseñador de Windows Forms.
    'No lo modifique con el editor de código.
    Friend WithEvents Button2 As System.Windows.Forms.Button
    Private Sub InitializeComponent()
        Me.MainMenu1 = New System.Windows.Forms.MainMenu
        Me.Button1 = New System.Windows.Forms.Button
        Me.Button2 = New System.Windows.Forms.Button
        '
        'Button1
        '
        Me.Button1.Location = New System.Drawing.Point(32, 88)
        Me.Button1.Size = New System.Drawing.Size(176, 56)
        Me.Button1.Text = "Conect"
        '
        'Button2
        '
        Me.Button2.Location = New System.Drawing.Point(96, 216)
        Me.Button2.Text = "Exit"
        '
        'Form1
        '
        Me.Controls.Add(Me.Button2)
        Me.Controls.Add(Me.Button1)
        Me.Menu = Me.MainMenu1
        Me.Text = "Form1"

    End Sub

#End Region

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

        ArrancarConexion()

    End Sub

    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click

        Application.Exit()

    End Sub
End Class


A greeting
Korku
 
Posts: 27
Joined: Wed 14 Mar 2007 14:40
Location: Spain

Postby Alexey » Fri 16 Mar 2007 17:55

Do you use a device or an emulator? What is your OS? What is the full version of MySQLDirect .NET you use?
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Korku » Fri 16 Mar 2007 18:06

Alexey wrote:Do you use a device or an emulator? What is your OS? What is the full version of MySQLDirect .NET you use?


I use a device: Fujitsu Siemens N560
Operating system: Windows Mobile 5
MySQLDirect .NET Mobile Version: 3.55
I use Visual Studio .NET 2003
Korku
 
Posts: 27
Joined: Wed 14 Mar 2007 14:40
Location: Spain

Postby Alexey » Mon 19 Mar 2007 08:11

Please provide us with call stack when NullReferenceException occurs.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Korku » Wed 21 Mar 2007 00:56

I am going you to explain the situation:

Pocket PC WIFI ON - MySQL Start = OK :D
Pocket PC WIFI OFF - MySQL Start = BUG :cry:
Pocket PC WIFI ON - MySQL Stop = BUG :cry:
Pocket PC WIFI OFF - MySQL Stop = BUG :cry:

Description of the bug:

Unexpected error in prueba.exe. Select Exit and you reinitiate the application or you select Details to obtain more information.

prueba.exe
NullReferenceException

Application::Run+0xf
Form1::Main+0xd


I think that it does not control the exceptions well because theoretically it would have to appear a message of error without closing the application. The source code is correct?
Korku
 
Posts: 27
Joined: Wed 14 Mar 2007 14:40
Location: Spain

Postby Alexey » Wed 21 Mar 2007 12:20

We have reproduced NullReferenceException. Now we are investigating this problem. Look forward to hearing from us again.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Alexey » Thu 22 Mar 2007 11:18

We have fixed this problem for you.
Look forward to the next build.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Korku » Thu 22 Mar 2007 12:59

Already is solved the problem? 8)
Korku
 
Posts: 27
Joined: Wed 14 Mar 2007 14:40
Location: Spain

Postby Alexey » Thu 22 Mar 2007 13:02

Yeah, we've been quick.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Korku » Thu 22 Mar 2007 14:44

Perfect. When it is the next update?
Korku
 
Posts: 27
Joined: Wed 14 Mar 2007 14:40
Location: Spain

Postby Alexey » Fri 23 Mar 2007 08:09

Hopefully, next week.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Next

Return to dotConnect for MySQL