其他地方的连接Access数据库,都不能根据应用程序是x86还是x64自适应。
public bool Connect(string file, string password)
{
bool ret = false;
try
{
string connectionString;
if (Environment.Is64BitProcess)
{
connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Jet OLEDB:Database Password={1}", file, password);
}
else
{
connectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Jet OLEDB:Database Password={1}", file, password);
}
OleDbConnection oleDbConnection = new OleDbConnection(connectionString);
oleDbConnection.Open();
ret = true;
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
return ret;
}