SQL2000的数据库怎么老是连接不上呢？

[蜗牛水里爬]

Dim connStr, selectName, selectCmd As String
selectName = InputBox("请输入查询字", "查询数据")
selectCmd = "SELECT * FROM SCORE WHERE name = '" & selectName & "'"
connStr = "Server=localhost; database=图书管理; uid=Administrator; pwd=butterfly;"
Dim conn As SqlConnection, cmd As SqlCommand, myReader As SqlDataReader
conn = New SqlConnection(connStr)
conn.Open()
cmd = New SqlCommand(selectCmd, conn)
myReader = cmd.ExecuteReader()
我用这个就可以连接数据库Me.SqlDataAdapter1.Fill(DataSet11)
用上面的怎么就不行了啊~？

[BearRui]

有没有提示什么错误！！！

[skyeenet]

连接字符串 是 ID 不是 UID 吧 ~~~

[xiaohutushen]

connStr = "data source=.; initial catalog =图书管理; uid=Administrator; pwd=butterfly;"

[delphi6net]

肯定是连接字符串写错了。 你好好看格式。应该能自己解决。
connStr = "data source=.; initial catalog =图书管理; uid=Administrator; pwd=butterfly provider=oledb.1;"

[p4cpu]

Server=localhost localhost改成具体的计算机名试试

[mark44404]

把sql2000设为与你的计算机共同登陆。再把Server=localhost localhost改成具体的计算机名