MySQL Forums :: MySQL for Visual Studio :: VB.Net & MySQL connection problem


Advanced Search

VB.Net & MySQL connection problem
Posted by: Pyay Phyo Kyaw ()
Date: October 18, 2016 10:09PM

Hello guys,

I am trying to develop VB.Net application with online MySQL database. MySQL Connector version is 6.9.5

I can able to connect VB.Net with Local Host database. But I can't connect with Online MySQL database. The error code is
----------------------------------------------
"Authentication with old password no longer supported, use 4.1 style passwords."
----------------------------------------------

My VB code is
----------------------------------------------
Dim DatabaseName As String = "aaa"
Dim server As String = "1.1.1.1"
Dim userName As String = "bbb"
Dim password As String = "123"

If Not conn Is Nothing Then conn.Close()

conn.ConnectionString = String.Format("server={0}; user id={1}; password={2}; database={3}; pooling=false", server, userName, password, DatabaseName)

Try
conn.Open()

MsgBox("Connected")
Catch ex As Exception
'txtID.Text = ex.ToString
MsgBox(ex.Message)
End Try
conn.Close()
----------------------------------------------


help me guys

Options: ReplyQuote


Subject Views Written By Posted
VB.Net & MySQL connection problem 436 Pyay Phyo Kyaw 10/18/2016 10:09PM
Re: VB.Net & MySQL connection problem 259 Javier TreviƱo 10/20/2016 02:05PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.