Question

C#winform程序连接ACCESS数据库字符串.

"Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+file
报错 error 未发现数据源名称并且未指定默认驱动程序

Answer 1

C#连接连接Access程序代码:
using System.Data;using System.Data.OleDb;
......
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";strConnection+=@"Data Source=C:\BegASPNET\Northwind.mdb";
OleDbConnection objConnection=new OleDbConnection(strConnection);
......
objConnection.Open();objConnection.Close();

Answer 2

C# 和Access2000、2003还是07连得，如果是2007 Provider=Microsoft.ACE.OLEDB.4.0

Answer 3

如：public static string connstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.Web.HttpContext.Current.Server.MapPath("~/App_Data/web.mdb");
注：~ 采用的相对路径
App_Data是项目中存放数据库的文件夹

Answer 4

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
Application.StartupPath + @"/db/dbtest.mdb"