Problems MySQLDirect.NET Mobile

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Korku
Posts: 27
Joined: Wed 14 Mar 2007 14:40
Location: Spain

Post by Korku » Fri 23 Mar 2007 08:52

Ok :wink:

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

Post by Korku » Fri 23 Mar 2007 08:59

It is important control the falls of connections when the application is open considering the situations like:

Outside cover WIFI
MySQL Server OFF
Loss connection
Etc.

The project that I am developing goes to work much in network. It is an application for restaurants whose objective is the kitchen note management. For that reason it is necessary control these situations.

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 23 Mar 2007 09:11

We are doing our best.

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

Post by Korku » Tue 27 Mar 2007 08:03

What day of this week will be ready the update?

It is that I need it... :cry:

Thank you

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Tue 27 Mar 2007 08:13

Hopefully, on Friday.

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

Post by Korku » Tue 27 Mar 2007 08:18

ok... there is no problem... you prove thoroughly hahahaha :lol:

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

Post by Korku » Thu 29 Mar 2007 22:56

I see that there is an update and I have one doubts...

Uninstall the old version and install the new version or reinstall?

Thank you...

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 30 Mar 2007 05:58

Uninstall the old version and install the new one.

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

Post by Korku » Fri 30 Mar 2007 12:01

there is a bug, the situation is the following one:

with the open application...

MySQL Start & Pocket PC WIFI ON -> MSGBOX = “Conect” CORRECT

MySQL Stop & Pocket PC WIFI ON -> MSGBOX = “Conect” NOT CORRECT

The code:

MySQLDirect .NET Data Provider Mobile Standard version 3.55.22

In module:

Code: Select all

Imports CoreLab.MySql

Module basConect
    Public conn As New MySqlConnection("User ID=root;Password=;Host=192.168.0.3;Port=3306;Database=test;")
    Public Sub ConectMySQL()

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

    End Sub
End Module
In form:

Code: Select all

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

        ConectMySQL()

    End Sub

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 30 Mar 2007 13:37

Try to use the following code for your module:

Code: Select all

Imports CoreLab.MySql

Module basConect
    Public conn As New MySqlConnection("User ID=root;Password=root;Host=192.168.0.123;Port=3308;Database=test;pooling=false")
    Public Sub ConectMySQL()

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

    End Sub
End Module
Spot the connection pooling is off and Close() method was called.

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

Post by Korku » Fri 30 Mar 2007 15:26

it works perfectly 8)

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 30 Mar 2007 15:35

Are you satisfied?

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

Post by Korku » Fri 30 Mar 2007 15:41

yes but I continue proving :lol:

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 30 Mar 2007 15:45

Good luck:)

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

Post by Korku » Wed 25 Apr 2007 17:02

I see that there is a new version (4) but I will have to wait for because the previous version one is bought recently :(

Post Reply