在菜单中单击“工程”菜单,单击“引用”,然后选择Microsoft Remote Date Object,确定即可,不过我建议你用ADO
为什么 是不是 rdo 不好呀 ado 好像连接服务器不行呀?
能不能给我一段 程序看看 是怎么和 服务器的 sql server 连接的。
引用microsoft Activex Data Objects 2.5 Libray Dim Cn As New ADODB.ConnectionPrivate Sub Form_Load() Dim sSQL As String sSQL = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=pubs;Data Source=wa\wa" Cn.Open sSQL End Sub
应该是这样的:Dim Cn As New ADODB.ConnectionPrivate Sub Form_Load() Dim sSQL As String sSQL = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=pubs;Data Source=wa\wa" Cn.ConnectString=sSQL '加上这句 Cn.Open End Sub
Dim Cn As New ADODB.ConnectionPrivate Sub Form_Load()
Dim sSQL As String
sSQL = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=pubs;Data Source=wa\wa"
Cn.Open sSQL
End Sub
Dim sSQL As String
sSQL = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=pubs;Data Source=wa\wa"
Cn.ConnectString=sSQL '加上这句
Cn.Open
End Sub