connecter une application VB.NET a une base de donnees MYSQL distante
Bonjour,
Je cherche a connecter mon application VB.NET a une base de donnees MYSQL distante mais ça ne marche.
Mon programme
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
| Imports MySql.Data.MySqlClient
Imports System.Data
Public Class test
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
'code
Try
Dim myConnectionString As String
myConnectionString = "Server=XXX.XXX.XXX.XXX;Database=test;UID=banki;Password=banki"
Dim myConnection As New MySqlConnection(myConnectionString)
myConnection.Open()
MsgBox("ok")
Catch ex As Exception
TextBox2.Text = "An exception occurred:" & vbCrLf & ex.Message
End Try
End Sub |
Erreurs
Citation:
MySql.Data.MySqlClient.MySqlException: #28000Access denied for user 'ficotech_toc'@'197.149.195.107' (using password: YES)
à MySql.Data.MySqlClient.PacketReader.CheckForError()
à MySql.Data.MySqlClient.PacketReader.ReadHeader()
à MySql.Data.MySqlClient.PacketReader.OpenPacket()
à MySql.Data.MySqlClient.NativeDriver.Authenticate411()
à MySql.Data.MySqlClient.NativeDriver.Authenticate()
à MySql.Data.MySqlClient.NativeDriver.Open()
à MySql.Data.MySqlClient.Driver.Create(MySqlConnectionString settings)
à MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
à MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
à MySql.Data.MySqlClient.MySqlPool.GetConnection()
à MySql.Data.MySqlClient.MySqlPoolManager.GetConnection(MySqlConnectionStringsettings)
à MySql.Data.MySqlClient.MySqlConnection.Open()
à WindowsApplication1.Form1.Button1_Click(Object sender, EventArgse) dans C:\Users\sad\Downloads\WindowsApplication1\WindowsApplication1\Form1.vb:ligne 10
Merci d'avance.
