Hi, I recently wrote an ASP.Net web application in VS2005 and published
(using VS2005 Publish feature) it to a relatively clean machine with
ASP.Net 2.0 and MDAC 2.8 installed on it. However, when I try to create
my SQL connection in the code-behind, I get the following error. I
tried to register the DLL using regsvr32 but that errored out saying,
"dllregisterser ver entry point was not found". Any ideas?
Retrieving the COM class factory for component with CLSID
{2206CDB2-19C1-11D1-89E0-00C04FD7A829} failed due to the following
error: 8007007f.
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.
Exception Details: System.Runtime. InteropServices .COMException:
Retrieving the COM class factory for component with CLSID
{2206CDB2-19C1-11D1-89E0-00C04FD7A829} failed due to the following
error: 8007007f.
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.
Stack Trace:
[COMException (0x8007007f): Retrieving the COM class factory for
component with CLSID {2206CDB2-19C1-11D1-89E0-00C04FD7A829} failed due
to the following error: 8007007f.]
System.RuntimeT ypeHandle.Creat eInstance(Runti meType type, Boolean
publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHa ndle&
ctor, Boolean& bNeedSecurityCh eck) +0
System.RuntimeT ype.CreateInsta nceSlow(Boolean publicOnly, Boolean
fillCache) +103
System.RuntimeT ype.CreateInsta nceImpl(Boolean publicOnly, Boolean
skipVisibilityC hecks, Boolean fillCache) +261
System.RuntimeT ype.CreateInsta nceImpl(Boolean publicOnly) +14
System.RuntimeT ype.CreateInsta nceImpl(Binding Flags bindingAttr,
Binder binder, Object[] args, CultureInfo culture, Object[]
activationAttri butes) +1036
System.Activato r.CreateInstanc e(Type type, BindingFlags bindingAttr,
Binder binder, Object[] args, CultureInfo culture, Object[]
activationAttri butes) +114
System.Data.Ole Db.OleDbConnect ionInternal.Cre ateInstanceData Links()
+96
System.Data.Ole Db.OleDbConnect ionInternal.Get ObjectPool() +130
[InvalidOperatio nException: The .Net Framework Data Providers require
Microsoft Data Access Components(MDAC ). Please install Microsoft Data
Access Components(MDAC ) version 2.6 or later.]
System.Data.Ole Db.OleDbConnect ionInternal.Get ObjectPool() +166
System.Data.Ole Db.OleDbConnect ionInternal..ct or(OleDbConnect ionString
constr, OleDbConnection connection) +51
System.Data.Ole Db.OleDbConnect ionFactory.Crea teConnection(Db ConnectionOptio ns
options, Object poolGroupProvid erInfo, DbConnectionPoo l pool,
DbConnection owningObject) +53
System.Data.Pro viderBase.DbCon nectionFactory. CreateNonPooled Connection(DbCo nnection
owningConnectio n, DbConnectionPoo lGroup poolGroup) +27
System.Data.Pro viderBase.DbCon nectionFactory. GetConnection(D bConnection
owningConnectio n) +47
System.Data.Pro viderBase.DbCon nectionClosed.O penConnection(D bConnection
outerConnection , DbConnectionFac tory connectionFacto ry) +105
System.Data.Ole Db.OleDbConnect ion.Open() +37
System.Data.Com mon.DbDataAdapt er.FillInternal (DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +137
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet) +86
search.Page_Loa d(Object sender, EventArgs e) +1404
System.Web.UI.C ontrol.OnLoad(E ventArgs e) +99
System.Web.UI.C ontrol.LoadRecu rsive() +47
System.Web.UI.P age.ProcessRequ estMain(Boolean
includeStagesBe foreAsyncPoint, Boolean includeStagesAf terAsyncPoint)
+1061
(using VS2005 Publish feature) it to a relatively clean machine with
ASP.Net 2.0 and MDAC 2.8 installed on it. However, when I try to create
my SQL connection in the code-behind, I get the following error. I
tried to register the DLL using regsvr32 but that errored out saying,
"dllregisterser ver entry point was not found". Any ideas?
Retrieving the COM class factory for component with CLSID
{2206CDB2-19C1-11D1-89E0-00C04FD7A829} failed due to the following
error: 8007007f.
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.
Exception Details: System.Runtime. InteropServices .COMException:
Retrieving the COM class factory for component with CLSID
{2206CDB2-19C1-11D1-89E0-00C04FD7A829} failed due to the following
error: 8007007f.
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.
Stack Trace:
[COMException (0x8007007f): Retrieving the COM class factory for
component with CLSID {2206CDB2-19C1-11D1-89E0-00C04FD7A829} failed due
to the following error: 8007007f.]
System.RuntimeT ypeHandle.Creat eInstance(Runti meType type, Boolean
publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHa ndle&
ctor, Boolean& bNeedSecurityCh eck) +0
System.RuntimeT ype.CreateInsta nceSlow(Boolean publicOnly, Boolean
fillCache) +103
System.RuntimeT ype.CreateInsta nceImpl(Boolean publicOnly, Boolean
skipVisibilityC hecks, Boolean fillCache) +261
System.RuntimeT ype.CreateInsta nceImpl(Boolean publicOnly) +14
System.RuntimeT ype.CreateInsta nceImpl(Binding Flags bindingAttr,
Binder binder, Object[] args, CultureInfo culture, Object[]
activationAttri butes) +1036
System.Activato r.CreateInstanc e(Type type, BindingFlags bindingAttr,
Binder binder, Object[] args, CultureInfo culture, Object[]
activationAttri butes) +114
System.Data.Ole Db.OleDbConnect ionInternal.Cre ateInstanceData Links()
+96
System.Data.Ole Db.OleDbConnect ionInternal.Get ObjectPool() +130
[InvalidOperatio nException: The .Net Framework Data Providers require
Microsoft Data Access Components(MDAC ). Please install Microsoft Data
Access Components(MDAC ) version 2.6 or later.]
System.Data.Ole Db.OleDbConnect ionInternal.Get ObjectPool() +166
System.Data.Ole Db.OleDbConnect ionInternal..ct or(OleDbConnect ionString
constr, OleDbConnection connection) +51
System.Data.Ole Db.OleDbConnect ionFactory.Crea teConnection(Db ConnectionOptio ns
options, Object poolGroupProvid erInfo, DbConnectionPoo l pool,
DbConnection owningObject) +53
System.Data.Pro viderBase.DbCon nectionFactory. CreateNonPooled Connection(DbCo nnection
owningConnectio n, DbConnectionPoo lGroup poolGroup) +27
System.Data.Pro viderBase.DbCon nectionFactory. GetConnection(D bConnection
owningConnectio n) +47
System.Data.Pro viderBase.DbCon nectionClosed.O penConnection(D bConnection
outerConnection , DbConnectionFac tory connectionFacto ry) +105
System.Data.Ole Db.OleDbConnect ion.Open() +37
System.Data.Com mon.DbDataAdapt er.FillInternal (DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +137
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet) +86
search.Page_Loa d(Object sender, EventArgs e) +1404
System.Web.UI.C ontrol.OnLoad(E ventArgs e) +99
System.Web.UI.C ontrol.LoadRecu rsive() +47
System.Web.UI.P age.ProcessRequ estMain(Boolean
includeStagesBe foreAsyncPoint, Boolean includeStagesAf terAsyncPoint)
+1061