Ciao ragazzi, ho cercato su internet ma non ho trovato quello che fa al mio caso...
Vorrei collegare il form1 al database mysql di altervista per un select,
ho aperto la connessione con
codice:
Imports MySql.Data.MySqlClient
Public Class Form3
Dim ServerString As String = "Server=****.altervista.org; User Id=****;Password=*****;Database=*****"
Dim SQLConnection As MySqlConnection = New MySqlConnection
Private Sub Form3_Load(sender As Object, e As EventArgs) Handles MyBase.Load
SQLConnection.ConnectionString = ServerString
Try
If SQLConnection.State = ConnectionState.Closed Then
SQLConnection.Open()
MsgBox("Connesso")
Else
SQLConnection.Close()
MsgBox("Disconnesso")
End If
Catch ex As Exception
MsgBox(ex.ToString)
End Try
End Sub
ma quando avvio la connessione, da sempre questo errore...
-------
MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts. in MySql.Data.MySqlClient.NativeDriver.Open() in MySql.Data.MySqlClient.Driver.Create(MySqlConnecti onStringBuilder settings) in MySql.Data.MySqlClient.MySqlPool.CreateNewPooledCo nnection() in MySql.Data.MySqlClient.MySqlPool.GetPooledConnecti on() in MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() in MySql.Data.MySqlClient.MySqlPool.GetConnection() in MySql.Data.MySqlClient.MySqlConnection.Open() in screenLoadCapture.Form3.Form3_Load(Object sender, EventArgs e) in C:\Users\****\Documents\Visual Studio 2013\Projects\screenLoadCapture\screenLoadCapture\ Form3.vb:riga 13
----
come posso fare?
a cosa è dovuto questo errore?