Mobile Ver.

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Victor

Mobile Ver.

Post by Victor » Sun 14 Nov 2004 14:06

I try to use mobile version for my VB.NET and PDA
It's Ok when I run in VB.NET
but, after I copy .exe to PDA and run program
Nothing to happend
In program, I try to test each line(because no any error messages)
imports is ok
when I enter like " dim conn as Mysql.MysqlDataConnection"
It's working nothing.
hope anybody know what I mean.
Execuse my poor english. and help me, please.

Oleg
Devart Team
Posts: 264
Joined: Thu 28 Oct 2004 13:56

Re: Mobile Ver.

Post by Oleg » Mon 15 Nov 2004 15:23

Please check that you copy corelab.mysql.dll to your mobile device with your application. Test this problem on the emulator. If you cannot connect to MySQL database, try to set host IP address instead of name of the server.

Guest

Re: Mobile Ver.

Post by Guest » Mon 15 Nov 2004 15:42

thank you for your reply
I did. I copied dll file to both windows and app dir but It still run nothing.
I test it on the emulator, It's perfect.
I don't think it's connect to MySQL database
because I only put both line as following in my program (this)

Imports CoreLab <---- 1
......
+Windows form
Dim conn As CoreLab.MySql.MySqlConnection <---- 2

First line is ok
when I type second line in my program, It's working nothing.
I don't thing, It's connecting already.

Please help me. thanks a lot. :(

Oleg
Devart Team
Posts: 264
Joined: Thu 28 Oct 2004 13:56

Re: Mobile Ver.

Post by Oleg » Tue 16 Nov 2004 08:59

In your code row 2 .NET Framework tries to load corelab.mysql.dll assembly. Check once more that you correctly deploy your application with corelab.mysql.dll.

Guest

Re: Mobile Ver.

Post by Guest » Tue 16 Nov 2004 10:56

I don't understand your mean clear.
"I test it on the emulator, It's perfect. "
enclosed parts of code for your reference.
(I remark some code for my testing)

--------------------- code -----------------------------------
Imports CoreLab
Imports System
Imports System.Data
Imports System.Data.Common

-Public Class Form1
Inherits System.Windows.Forms.Form
Friend WithEvents txtName As System.Windows.Forms.TextBox
Friend WithEvents MainMenu1 As System.Windows.Forms.MainMenu

+Windows Form ....................

'Dim conn As MySql.MySqlConnection
Dim conn As CoreLab.MySql.MySqlConnection
'Dim adFileList As MySql.MySqlDataAdapter
'Dim dvFileList As DataView
'Dim dsFileList As DataSet = New DataSet
'Dim strSqlFileList As String

- Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'conn.ConnectionString = "User ID=xxxx;" & _
'"Password=xxxx;" & _
'"Host=xxx.xxx.xx.xxx;" & _
'"Port=3306;" & _
'"Database=family;" & _
'"Direct=true;" & _
'"Protocol=TCP;" & _
'"Compress=false;" & _
'"Pooling=true;" & _
'"Min Pool Size=0;" & _
'"Max Pool Size=100;" & _
'"Connection Lifetime=0"
Try
'If conn.State = ConnectionState.Closed Then
'conn.Open()
'End If

strSqlFileList = "select file_name,descp,file_author from files;"
'adFileList = New MySql.MySqlDataAdapter(strSqlFileList, conn)
'adFileList.Fill(dsFileList, "files")
'dgFileList.DataSource = dsFileList.Tables("files")

Catch ex As Exception
MessageBox.Show(ex.ToString)
Finally
'If conn.State = ConnectionState.Open Then
'conn.Close()
'End If
End Try


End Sub

Guest

Re: Mobile Ver.

Post by Guest » Tue 16 Nov 2004 11:41

thank you for your help.
after I copy CoreLab.MySql.dll to app dir
It's working now.

Post Reply