Devart Forums

Hi
I need help, i am developing a project, i try to insert values into a mysql database but when i execute the instruction i get an error


Dim cn As New MySqlConnection()
Dim myCommand As New MySql.Data.MySqlClient.MySqlCommand

cn.ConnectionString = "Server=0.0.0.0;Port=3306;Database=test;Uid=x;Pwd=x"
cn.Open()


Try
myCommand.CommandText = "INSERT INTO rechazos values ('Prueba Lulu 4')"
myCommand.ExecuteNonQuery()

Catch ed As Exception
MsgBox(ed.Message, MsgBoxStyle.Critical, "Error de conexion")
Finally
cn.Close()
End Try

And the error is

"Connection must be valid and open"

Is misssing me something ???

Thanks

Thanks so muuuuchhhhh !!!!!!!!!!!!!!!!!!
I had not copied dll to the pocket, so, i placed Devart.Data.Mysql.dll with the exe file in the pocket and it works ...!!!!!!!!!!!
I believed with only exe file must be works, but i was wrong .......
that means if i build the project , assemblies are not in the exe ???

Lulú

Hi, thanks for your help, but i did what you said and a got the same error.
So, i created a new project and i added Devart.Data.Mysql to my references, and also copied it to the folder (release) with the assembly program, built the proyect and copied cnxmysql.exe to my pocket , run cnxmysql.exe and a got the same error:

No se encontró el nombre de archivo o ensamblado 'Devart.Data.Mysql, Version=5.0.22.1, Culture=neutral,publicKeyToken=09AF7300EEC23701' o una de sus dependencias.

Now i just want to make the connection to my server but i can´t.

This is the code of my proyect to make the connection:

Imports System
Imports System.Data
Imports System.Drawing
Imports System.Windows.Forms
Imports Devart.Data.MySql

Public Class Form1

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

Dim cn As New MySqlConnection()
cn.ConnectionString = "Server=xx.x.x.x;Port=3306;Database=name;Uid=lulu;Pwd=myPassword;"
cn.Open()
MessageBox.Show("Conectado al servidor")
cn.Close()

Catch ex As Exception
MsgBox(ex.Message, MsgBoxStyle.Critical, "Error de conexion")
Application.Exit()
End Try

End Sub
End Class

Is like .dll not included in the proyect, but when i built the proyect doesn´t show an error.

Shalex wrote:To deploy applications written with dotConnect Mobile for MySQL you should register run-time assemblies Devart.Data.MySql.dll and Devart.Data.dll at Global Assembly Cache (GAC) for appropriate framework or place them in the folder of your application. You can find these assemblies in the installation folder of dotConnect Mobile for MySQL (by default: ..\Program Files\Devart\dotConnect Mobile\MySQL\..). For more information, please refer to our online documentation: http://www.devart.com/dotconnect/mysql/ ... yment.html .

Please notify us if you have resolved the problem.

Hi, the application it doesn't work, or somethinfg is wrong .....I want to run the sample project (VB) on my pocket pc , what do i have to do??

Lulú

Hi, i´m from México, so i´m going to explain the problem as well as i can.
I have de trial version of dotconnect Mobile for Mysql, and a run the example in my pocket (plug it to my pc) and it works, but i want to run the example in my pocket without plug it to my pc, so, i rebuild the solution (Visual Studio 2005) whit the "Pocket PC 2003" and i copied the .exe file to my pocket and when i run the application show this:

No se encontró el nombre de archivo o ensamblado 'Devart.Data.Mysql, Version=5.0.22.1, Culture=neutral,publicKeyToken=09AF7300EEC23701' o una de sus dependencias.

I just copy the StoreProc.exe to my pocket. I need to copy anything else??
The pocket has wifi , Windows Mobile and it works, is there something i need to install in the pocket also??

Thanks
Lulú