怎么解决这个？ [英] How to solve this?

问题描述

'Microsoft.Jet.OLEDB.12.0'提供商未在本地计算机上注册。



我尝试过：



'Microsoft.Jet.OLEDB.12.0'提供程序未在本地计算机上注册。

OleDbConnection cnn = new OleDbConnection（@ Provider = Microsoft.Jet.OLEDB.4.0; Data Source =+ paths +; Extended Properties = Excel 12.0; IMEX = 1; HDR = YES;）;

OleDbCommand oconn = new OleDbCommand （select * from [Sheet1 $]，cnn）;

cnn.Open（）;

OleDbDataAdapter adp = new OleDbDataAdapter（oconn）;

DataTable dt = new DataTable（）;

adp.Fill（dt）;

if（dt.Rows.Count> 0）

{

var username = dt.Rows [0] [username]。ToString（）;

var id = dt.Rows [0] [ id]。ToString（）;

var password = dt.Rows [0] [password]。ToString（）;



}

The 'Microsoft.Jet.OLEDB.12.0' provider is not registered on the local machine.

What I have tried:

The 'Microsoft.Jet.OLEDB.12.0' provider is not registered on the local machine.
OleDbConnection cnn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + paths + "; Extended Properties=Excel 12.0;IMEX=1;HDR=YES;");
OleDbCommand oconn = new OleDbCommand("select * from [Sheet1$]", cnn);
cnn.Open();
OleDbDataAdapter adp = new OleDbDataAdapter(oconn);
DataTable dt = new DataTable();
adp.Fill(dt);
if (dt.Rows.Count > 0)
{
var username = dt.Rows[0]["username"].ToString();
var id = dt.Rows[0]["id"].ToString();
var password = dt.Rows[0]["password"].ToString();

}

推荐答案

，cnn）;

cnn.Open（） ;

OleDbDataAdapter adp = new OleDbDataAdapter（oconn）;

DataTable dt = new DataTable（）;

adp.Fill（dt）;

if（dt.Rows.Count> 0）

{

var username = dt.Rows [0] [username]。ToString（）;

var id = dt .Rows [0] [id]。ToString（）;

var password = dt.Rows [0] [password]。ToString（）;



}

", cnn);
cnn.Open();
OleDbDataAdapter adp = new OleDbDataAdapter(oconn);
DataTable dt = new DataTable();
adp.Fill(dt);
if (dt.Rows.Count > 0)
{
var username = dt.Rows[0]["username"].ToString();
var id = dt.Rows[0]["id"].ToString();
var password = dt.Rows[0]["password"].ToString();

}

考虑转移到ACE数据库引擎而不是Jet - 它更新，并且支持64位机器和代码，Jet不支持。如果你出于任何原因以x64身份运行 - 而你可能是 - 那么你根本无法访问32位代码，因此Jet无法使用。

Consider moving to the ACE db engine instead of Jet - it's newer, and supports 64 bit machines and code, which Jet doesn't. If you are running as x64 for any reason - and you probably are - then you cannot access 32 bit code at all, so Jet will not be available to you.

这篇关于怎么解决这个？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！