VB.Net无法连接到SQL

debugcn 发表于 Dev

布兰登

Private Sub Button5_Click_1(sender As Object, e As EventArgs) Handles Button5.Click
    Dim connetionString As String
    Dim cnn As SqlConnection
    connetionString = "Server=localhost;Initial Catalog=acernis;User ID=root;Password=password"
    cnn = New SqlConnection(connetionString)
    Try
        cnn.Open()
        MsgBox("Connection Open ! ")
        cnn.Close()
    Catch ex As Exception
        MsgBox("Can not open connection ! ")
    End Try
End Sub

当前在我的代码中，我在SQL用户名上方有代码，并且传递和DB一样正确。我正在运行WAMP，并且正在使用Navicat来确保可以连接。怎么了？

人

如果您使用的是MS SQL Server，则问题出在连接字符串上。试试这个：

connetionString = "Server=localhost;Database=acernis;User ID=root;Password=password"

但是，如果您的意思是MySQL，则您不仅需要更改connectio字符串，还需要进行更多更改

尝试这个：

Private Sub Button5_Click_1(sender As Object, e As EventArgs) Handles Button5.Click
    Dim connetionString As String
    connetionString = "Server=localhost;Database=acernis;Uid=root;Pwd=password;"

    Dim conn As New MySqlConnection(connetionString)
    Try
        conn.Open()
        MsgBox("Connection Open ! ")
    Catch ex As MySqlException
        MsgBox("Can not open connection Error: " & ex.ToString())
    Finally
        conn.Close()
    End Try
End Sub

找出最适合您的网站的连接字符串是什么

http://www.connectionstrings.com/

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。