Question

asp.net(用visual studio 2010写的)，和Access(office2010)的数据库进行oledb连接,连接不上去啊…………

不知道哪里出问题，现在office2010的access的保存格式改为了*.accdb,结果:
行 10: objCon = New OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & Server.MapPath("ybjaa.accdb"))
行 11: cmd = New OleDbCommand("selcet * from ybjaa", objCon)
行 12: objCon.Open()
行 13: Dim dr As OleDbDataReader = cmd.ExecuteReader()
行 14: End Sub

然后就说不可识别的数据库格式…………
[OleDbException (0x80004005): 不可识别的数据库格式 'd:\Users\Administrator\Documents\Visual Studio 2010\WebSites\WebSite2\ybjaa.accdb'。]
System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) +351
System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +86
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +31
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +76
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +126
System.Data.OleDb.OleDbConnection.Open() +43
Data01.Page_Load(Object sender, EventArgs e) in d:\Users\Administrator\Documents\Visual Studio 2010\WebSites\WebSite2\Data01.aspx.vb:12
System.Web.UI.Control.OnLoad(EventArgs e) +91
System.Web.UI.Control.LoadRecursive() +74
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207

本人新手，求助啊

Answer 1

连接数据库字符串出错,应该是版本没有对应

Answer 2

使用sqldatasource 就可以
vs提供的有图形界面配置
很简单

Answer 3

“provider=Microsoft.Jet.OLEDB.4.0;”，这里出错