Dim cnA As ADOConnection = New ADOConnection Dim cmA As ADOCommand = New ADOCommand 中的ADOConnection ,ADOCommand 改为: SqlConnection,SqlCommand
多谢~我已经把ADO全部都改成OLEDB了,不过还是有错误: 编译器错误信息: BC30526: 属性“Provider”为“ReadOnly”。源错误: 行 12: Dim cnA As OledbConnection = New OledbConnection 行 13: Dim cmA As OledbCommand = New OledbCommand 行 14: cnA.Provider="Microsoft.Jet.OLEDB.4.0" 行 15: cnA.DataSource="C:\Inetpub\wwwroot\cr\ch05\MyWeb.mdb" 行 16: CnA.UserID="Admin"这个应该怎么解决啊?
改成这样: Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Inetpub\wwwroot\cr\ch05\MyWeb.mdb; User ID=MyUserName;Password=MyPassword;" Dim cn As New OleDbConnection(strConn)
Dim cmA As ADOCommand = New ADOCommand
中的ADOConnection ,ADOCommand 改为:
SqlConnection,SqlCommand
编译器错误信息: BC30526: 属性“Provider”为“ReadOnly”。源错误:
行 12: Dim cnA As OledbConnection = New OledbConnection
行 13: Dim cmA As OledbCommand = New OledbCommand
行 14: cnA.Provider="Microsoft.Jet.OLEDB.4.0"
行 15: cnA.DataSource="C:\Inetpub\wwwroot\cr\ch05\MyWeb.mdb"
行 16: CnA.UserID="Admin"这个应该怎么解决啊?
Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:\Inetpub\wwwroot\cr\ch05\MyWeb.mdb;
User ID=MyUserName;Password=MyPassword;"
Dim cn As New OleDbConnection(strConn)