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.
Mobile Ver.
Re: Mobile Ver.
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.
Re: Mobile Ver.
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.
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.
Re: Mobile Ver.
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.
Re: Mobile Ver.
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
"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
Re: Mobile Ver.
thank you for your help.
after I copy CoreLab.MySql.dll to app dir
It's working now.
after I copy CoreLab.MySql.dll to app dir
It's working now.