Problems MySQLDirect.NET Mobile

Postby Korku » Fri 23 Mar 2007 08:52

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

Postby 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.
Korku
 
Posts: 27
Joined: Wed 14 Mar 2007 14:40
Location: Spain

Postby Alexey » Fri 23 Mar 2007 09:11

We are doing our best.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby 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
Korku
 
Posts: 27
Joined: Wed 14 Mar 2007 14:40
Location: Spain

Postby Alexey » Tue 27 Mar 2007 08:13

Hopefully, on Friday.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby 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

Postby 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...
Korku
 
Posts: 27
Joined: Wed 14 Mar 2007 14:40
Location: Spain

Postby Alexey » Fri 30 Mar 2007 05:58

Uninstall the old version and install the new one.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby 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
Korku
 
Posts: 27
Joined: Wed 14 Mar 2007 14:40
Location: Spain

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Korku » Fri 30 Mar 2007 15:26

it works perfectly 8)
Korku
 
Posts: 27
Joined: Wed 14 Mar 2007 14:40
Location: Spain

Postby Alexey » Fri 30 Mar 2007 15:35

Are you satisfied?
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Korku » Fri 30 Mar 2007 15:41

yes but I continue proving :lol:
Korku
 
Posts: 27
Joined: Wed 14 Mar 2007 14:40
Location: Spain

Postby Alexey » Fri 30 Mar 2007 15:45

Good luck:)
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby 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 :(
Korku
 
Posts: 27
Joined: Wed 14 Mar 2007 14:40
Location: Spain

PreviousNext

Return to dotConnect for MySQL