不能连接SQL server
Imports MySql.Data.MySqlClient
Public Class Form1
Dim conn As MySqlConnection
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Try
conn.ConnectionString = "Data Source=arduwehf.com.cn;Initial Catalog=test;Persist Security Info=ture;User ID=<555>;Password=<666>"
conn.Open()
Catch myerror As Exception
MsgBox("无法连接:" & myerror.Message)
Me.Close()
End Try
End Sub
End Class
如何解决？？
[解决办法]
用户名和密码都带有<>这两个符号？
[解决办法]
id=*****;password=*****;
用户名和密码都是直接输入,你输入<555>的话,会认为密码中包含<和>
[解决办法]
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Try
conn.ConnectionString = "Data Source=arduwehf.com.cn;Initial Catalog=test;Persist Security Info=ture;User ID=555;Password=666"
conn.Open()
Catch myerror As Exception
MsgBox("无法连接:" & myerror.Message)
Me.Close()
End Try
End Sub
[解决办法]
Data Source 改为ip试试啊
