vb.net连接access数据库不对
代码是这样的
Dim Connstr As String = "prorider=Mirosoft.jet.oledb.4.0; data source= '|DataDirectory|\AppDate\MKTrade.mdb'"
Dim OleConn As New OleDb.OleDbConnection(Connstr)
报错
在 ConnectionString 中未指定 OLE DB 提供程序。示例为:“Provider=SQLOLEDB;”。
怎么解决？谢谢 VB.NET
[解决办法]
Dim?Connstr?As?String
Connstr?= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "\MainDB.mdb;Jet OLEDB:Database Password=" + MdbPassword + ""
Dim oleconn As New OleDb.OleDbConnection(Connstr)
dim SQLString as string
SQLString = "SELECT * FROM tbTest"
Dim cmd As OleDb.OleDbCommand = New OleDb.OleDbCommand(SQLString, oleconn)
cmd.CommandType = CommandType.Text
If oleconn.State <> ConnectionState.Open Then
oleconn.Open()
End If
cmd.ExecuteNonQuery()
If oleconn.State <> ConnectionState.Closed Then
oleconn.Close()
End If
Dim Connstr As String = "prorider=Mirosoft.jet.oledb.4.0; data source= '
[解决办法]
DataDirectory
[解决办法]
\AppDate\MKTrade.mdb'"
