当为一个Gridview添加access数据源.accdb时会出现"Database schema could not be retrieved for this connection...无法识别数据源类型
access2007采用ACE.OLEDB provider,原来的 Jet4 不再起作用。
仍可采用以下三种连接方式:
windows 验证方式:
Provider=
Microsoft.ACE.OLEDB.12.0;
Data Source=
C:/myFolder/myAccess2007file.accdb;
Persist Security Info=
False;
设置密码保护时:
Provider=
Microsoft.ACE.OLEDB.12.0;
Data Source=
C:/myFolder/myAccess2007file.accdb;
Jet OLEDB:Database Password=
MyDbPassword;
DataDirectory functionality:
Provider=
Microsoft.ACE.OLEDB.12.0;
Data Source=
|DataDirectory|/myAccess2007file.accdb;
Persist Security Info=
False;