c#Á¬½Óaccess ±¨´í ²»Ö§³Ö¹Ø¼ü×Ö: ¡°provider¡±

ÎÊÌâÈçÌ⣬
´úÂëÈçÏÂ
string constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=eworld.mdb;Jet OLEDB:Database Password=''";
SqlConnection conn = new SqlConnection(constr);//½øÐÐÁ¬½Óʱ¾Í»á±¨´í ²»Ö§³Ö¹Ø¼ü×Ö: ¡°provider¡±¡£

Á¬½Ó´®ÊÇ ÓÃ.net×Ô´øµÄÊý¾Ý×齨Éú³ÉµÄ¡£

µ½ÍøÂçÉÏËÑ£¬ÓÐÈË˵ÊÇÐèÒª°²×° MDAC.inf¡£ °´ÕÕÌáʾ°²×°ÁËÖ®ºó»¹ÊDZ¨Õâ¸ö´íÎó¡£

²»ÖªµÀÓÐûÓиßÊÖÄÜ°ïæ½â¾ö¡£

---

http://www.cftea.com/c/2007/07/V5CXEBU0V5VDJ3D5.asp

---

Â¥ÉϸøµÄÍøÖ·Ìáʾȥµô Provider,
µ«ÊÇÈ¥µôÖ®ºó±¨´í²»Ö§³Ö¹Ø¼ü×Ö: ¡°jet oledb:database password¡±¡£
»¹ÊDz»ÐÐ

---

°ïÄ㶥ÏÂ

---

ÄÄλ´óÏÀÀ´°ï°ïÎÒ°¡£¬·ÖÊý²»¹»ÎÒ¿ÉÒÔÔÙ¼Ó

---

ÊÔÊÔ
C# code:
region Access 2007
Console.WriteLine("Access 2007");
string strConnection = "Provider=Microsoft.ACE.OLEDB.12.0;";
strConnection += @"Data Source=C:\Documents and Settings\v-changl\My Documents\Database1.accdb;";
strConnection += "Persist Security Info=False";
using (OleDbConnection objConnection = new OleDbConnection(strConnection))
{
objConnection.Open();
OleDbDataAdapter myCommandd = new OleDbDataAdapter("select * from Couse", objConnection);