bonjour à tous
J'ai une erreur qui apparait lorsque je souhaite me connecter a ma base de donne MySql. Voila le code que j'utilise :
Imports MySql.Data.MySqlClient
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim ConnnectionStr As String = "Database=(lspsp);Data Source=ftpperso.free.fr;User ID=lspsp;Password=LS07Vis"
Dim oConnection As New MySqlConnection
oConnection.ConnectionString = "Database=(lspsp);Data Source=ftpperso.free.fr;User ID=lspsp;Password=LS07Vis"
Try
oConnection.Open()
Dim MySQLCmd As String
MySQLCmd = ("CREATE TABLE `tu_table` (`id` INT( 10 ) NOT NULL ,`comment` VARCHAR( 255 ) NOT NULL ,PRIMARY KEY ( `id` ));")
Dim SelectCommand = New MySqlCommand(MySQLCmd, oConnection)
Dim oReader As MySqlDataReader = SelectCommand.ExecuteReader()
Catch Ex As Exception 'Intercepte l'erreur en cas de pb
MsgBox(Ex.ToString)
End Try
oConnection.Close()
End Sub
End Class
l'erreur est disponible a : http://lspsp.free.fr/erreur.JPG
Merci d'avance