工程--->引用--->Microsoft ActiveX Data Object 2.x(版本号) Dim CN As New ADODB.Connection '定义数据库的连接 Dim Rs As New ADODB.Recordset CN.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\NWIND.MDB;Persist Security Info=False" CN.Open
先从菜单中选引用。工程->引用 Microsoft ActiveX Data Objects Library 2.6 dim cn as adodb.connection dim rs as adodb.recordset
dim connectionString as String connectionString="Provider=Microsoft .Jet.OlEDB.4.0 or SQLOlDB.... cn.open connectionString rs.open SQL,cn,adOpenKeyset,adLockOptimistic
Dim Rs As New ADODB.Recordset CN.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\NWIND.MDB;Persist Security Info=False"
CN.Open
dim cn as adodb.connection
dim rs as adodb.recordset
未找到提供程序。该程序可能示正确安装。怎么办?
connectionString="Provider=Microsoft .Jet.OlEDB.4.0 or SQLOlDB....
cn.open connectionString
rs.open SQL,cn,adOpenKeyset,adLockOptimistic
灵了,why?
lihonggen0(李洪根,用.NET,标准答案来了) :
为什么设计时采用adodc,运行时却要用其它?难道设计与运行不能一致的?