The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
2021년도에 Microsoft.ACE.OLEDB.12.0 제공자를 다루게 되는군요. ^^;
우선, 해당 제공자는 기본적으로 설치되어 있지 않기 때문에 관련 프로그램을 실행하면 다음과 같은 예외가 발생합니다.
System.InvalidOperationException: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at ConsoleApp1.Program.Main(String[] args)
지난 글에 정리해 둔 것처럼,
C# - 오피스 엑셀 97-2003 .xls 파일에 대해 32비트/64비트 상관없이 접근 방법
; https://www.sysnet.pe.kr/2/0/11329
Access DB에 대한 32bit/64bit OLE DB Provider 관련 오류
; https://www.sysnet.pe.kr/2/0/1036
적절한 플랫폼의 "
Microsoft Access Database Engine 2010 Redistributable"을 설치해야 합니다.
위의 내용에서는 "Microsoft Access Database Engine"으로 엑셀(Excel) 파일을 다루는 방법을 소개했는데요, 사실 이름에서처럼 "Access" 데이터베이스를 다루는 엔진이기 때문에 mdb 확장자를 가진 Access Database에 대한 쿼리도 가능합니다.
그런데 쿼리 사용 중에 다음과 같은 오류가 발생한다면?
System.Data.OleDb.OleDbException
HResult=0x80040E10
Message=No value given for one or more required parameters.
Source=System.Data
StackTrace:
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
at ConsoleApp1.Program.Main(String[] args)
This exception was originally thrown at this call stack:
System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(System.Data.OleDb.OleDbHResult)
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(System.Data.OleDb.tagDBPARAMS, out object)
System.Data.OleDb.OleDbCommand.ExecuteCommandText(out object)
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(System.Data.CommandBehavior, string)
System.Data.OleDb.OleDbCommand.ExecuteReader(System.Data.CommandBehavior)
System.Data.Common.DbDataAdapter.FillInternal(System.Data.DataSet, System.Data.DataTable[], int, int, string, System.Data.IDbCommand, System.Data.CommandBehavior)
System.Data.Common.DbDataAdapter.Fill(System.Data.DataSet, int, int, string, System.Data.IDbCommand, System.Data.CommandBehavior)
System.Data.Common.DbDataAdapter.Fill(System.Data.DataSet, string)
...
[Call Stack Truncated]
쿼리 문에 지정한 DB 필드명과 Access의 테이블에 있는 쿼리 명이 일치하는지 주의 깊게 확인하면... 오타가 있을 것입니다. ^^
[이 글에 대해서 여러분들과 의견을 공유하고 싶습니다. 틀리거나 미흡한 부분 또는 의문 사항이 있으시면 언제든 댓글 남겨주십시오.]