sql 2005 链接字符串的问题

显示全部楼层 · 2010-7-4 13:13:08

ConnStr = "Provider = Sqloledb; User ID = " & SqlUsername & "; Password = " & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source = " & SqlHostIP & ";"
这个链接字符换哪里有错误？数据库是sql 2005，提示用户** 登陆失败！
谢谢回答！
1楼：传过来的变量没有问题
2楼：提示未找到提供程序。该程序可能未正确安装
3、4楼：我问主机提供商了，他就是让我检查连接字符串，数据库用户名，密码等都没有问题，买了空间一点用途也没有

千问 · 2010-7-4 13:13:08

做telnet 服务器ip 1433 测试，将会看到屏幕一闪之后光标在左上角不停，看看是否可以访问，端口是否开放Dim cn As New ADODB.Connection. . .Dim ServerName As String, DatabaseName As String, _ UserName As String, Password As String' Put text box values into connection variables.ServerName = SqlHostIPDatabaseName = SqlDatabaseNameUserName = SqlUsernamePas

千问 · 2010-7-4 13:13:08

ConnStr = "User ID = " & SqlUsername & "; Password = " & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source = " & SqlHostIP & ";" 这样写看下，应该就好啦！但是要保证你的sql

千问 · 2010-7-4 13:13:08

“3、4楼：我问主机提供商了，他就是让我检查连接字符串，数据库用户名，密码等都没有问题，买了空间一点用途也没有”昏了，你既然能问主机商，那为什么不连同连接字符串一起问她要呢？？？即使是别的语言的，你应该也能看懂的。

千问 · 2010-7-4 13:13:08

ConnStr = "Provider = SQLNCLI.1; User ID = " & strUid & "; Password = " & strPwd & "; Initial Catalog = " & strServer & "; Data Source = " & strDB & ";"

千问 · 2010-7-4 13:13:08

Public Const conn As String = "Provider=SQLOLEDB.1;Password=sa;User ID=sa;Initial Catalog=StudentFiles;Data Source=localhost;"