读书人

不能连接SQL server,该怎么解决

发布时间: 2012-02-29 16:44:10 作者: rapoo

不能连接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试试啊

读书人网 >VB Dotnet

热点推荐