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'"
Dim OleConn As New OleDb.OleDbConnection(Connstr)

报错
在 ConnectionString 中未指定 OLE DB 提供程序。示例为:“Provider=SQLOLEDB;”。

怎么解决？谢谢

Dim Connstr As String = "prorider=Mirosoft.jet.oledb.4.0; data source= '
[解决办法]
DataDirectory
[解决办法]
\AppDate\MKTrade.mdb'"
Dim OleConn As New OleDb.OleDbConnection(Connstr)

请问这是什么

[解决办法]

Dim Connstr As String = "prorider=Mirosoft.jet.oledb.4.0; data source= '
[解决办法]
DataDirectory
[解决办法]
\AppDate\MKTrade.mdb'" 

链接字符串书写有问题。
[解决办法]
data source= '
[解决办法]
DataDirectory
[解决办法]


多了个单引号
[解决办法]
"prorider",不应该是prorider吗？？？