Remove From My Forums

Sql Server Migration Assistant(SSMA) library/Dll error

Question
0

Sign in to vote

I am having my old database in MS Access 2007. I am using this SSMA tool for converting access to sql server 2008. But whenever i try to convert it, i encounter this error.
Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)) An error occurred while loading database information. Conversion finished with 0 errors, 0 warnings, and 0 informational messages. There is nothing to process.

I don't know from where the hell that error is coming.

Here's the snapshot of it.

Tuesday, December 16, 2014 1:35 PM

Answers

0

Sign in to vote
It looks like compatibility issues.

Try this link

http://gaurangpatel.net/access-to-sql-server-migration-and-compatibility-issues

--Prashanth
- Proposed as answer by Donghui Li Wednesday, December 17, 2014 7:45 AM
- Marked as answer by Donghui Li Wednesday, December 24, 2014 1:16 AM
Tuesday, December 16, 2014 5:41 PM

All replies

0

Sign in to vote
I am having my old database in MS Access 2007. I am using this SSMA tool for converting access to sql server 2008. But whenever i try to convert it, i encounter this error.
Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)) An error occurred while loading database information. Conversion finished with 0 errors, 0 warnings, and 0 informational messages. There is nothing to process.

I don't know from where the hell that error is coming.

Here's the snapshot of it.
- Merged by Lydia ZhangMicrosoft contingent staff Wednesday, December 17, 2014 1:21 AM duplicated post
Tuesday, December 16, 2014 1:37 PM
0

Sign in to vote

Can you post the SSMA log message?

It can be found in

%APPDATA%\Microsoft SQL Server Migration Assistant\Access\log\ssma.log

--Prashanth

Tuesday, December 16, 2014 3:29 PM

[Generic: Mandatory] [3568/1] [2014-12-15 19:45:55]: SQL Server Migration Assistant for Access v5.3.0
[Collector: Error] [3568/7] [2014-12-15 19:46:26]: Access Object Collector: An error occurred while loading database content.
[Collector: Error] [3568/7] [2014-12-15 19:46:26]: Exception: Retrieving the COM class factory for component with CLSID {CD7791B9-43FD-42C5-AE42-8DD2811F0419} failed due to the following error: 80040154. This error may be a result of running SSMA as 64-bit application while having only 32-bit connectivity components installed or vice versa. You can run 32-bit SSMA application if you have 32-bit connectivity components or 64-bit SSMA application if you have 64-bit connectivity components, shortcut to both 32-bit and 64-bit SSMA can be found under the Programs menu. You can also consider updating your connectivity components from http://go.microsoft.com/fwlink/?LinkId=197502.
 site: Microsoft.SSMA.Framework.Access.DaoUtils.DaoMdbConnection TryConnectToDatabase(System.String, Boolean, System.String ByRef, Microsoft.SSMA.Framework.Access.DaoUtils.PasswordAsker, System.Nullable`1[Microsoft.SSMA.Framework.Access.DaoUtils.WorkgroupPolicySettings] ByRef, Microsoft.SSMA.Framework.Access.DaoUtils.WorkgroupPolicyAsker)
 source: Microsoft.SSMA.Framework.Access.DaoUtils
   at Microsoft.SSMA.Framework.Access.DaoUtils.DaoUtilities.TryConnectToDatabase(String fileName, Boolean readOnly, String& password, PasswordAsker passwordAsker, Nullable`1& workgroupPolicySettings, WorkgroupPolicyAsker workgroupPolicyAsker)
   at Microsoft.SSMA.Framework.Access.DaoUtils.DaoUtilities.ConnectToDatabase(String fileName, Boolean readOnly, String& password, PasswordAsker passwordAsker, Nullable`1& workgroupPolicySettings, WorkgroupPolicyAsker workgroupPolicyAsker)
   at Microsoft.SSMA.Framework.Access.Generic.AccessConnectionUtilities.ConnectToMdbFile(XNode xMdbFile, Boolean readOnly, IUIAskPasswordProvider askPasswordProvider, IUIWorkgroupPolicyProvider workgroupPolicyProvider)
   at Microsoft.SSMA.Framework.Access.Collector.Loaders.MDBFileLoader.LoadChildren(XNode xNode)
[Generic: Error] [3568/6] [2014-12-15 19:47:38]: Exception: Collection was modified; enumeration operation may not execute.
 site: Void ThrowInvalidOperationException(System.ExceptionResource)
 source: mscorlib
   at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource)
   at System.Collections.Generic.List`1.Enumerator.MoveNextRare()
   at System.Collections.Generic.List`1.Enumerator.MoveNext()
   at Microsoft.SSMA.Framework.Generic.XTree.XNode.ChildrenList.<GetEnumerator>d__1b.MoveNext()
   at Microsoft.SSMA.GUI.Components.Controls.TreeControllerLib.MultiCheckTreeView.GetCountNodes(XNode XNode)
   at Microsoft.SSMA.GUI.Components.Controls.TreeControllerLib.MultiCheckTreeView.InitProgress(XNode node)
   at Microsoft.SSMA.GUI.Components.Controls.TreeControllerLib.MultiCheckTreeView.FillItems(Object node)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading._TimerCallback.PerformTimerCallback(Object state)
[Generic: Error] [3568/6] [2014-12-15 19:47:38]: System.UnhandledExceptionEventArgs
[Generic: Assert] [3568/6] [2014-12-15 19:47:44]: Assertion failed at:    at System.Environment.get_StackTrace()
   at Microsoft.SSMA.Framework.Generic.Logging.Logger.LogAssersionFailed(Logger logger)
   at Microsoft.SSMA.Framework.Generic.Logging.Logger.Assert(Boolean condition)
   at Microsoft.SSMA.GUI.Product.AccessToMsSql.Program.AppDomain_UnhandledException(Object sender, UnhandledExceptionEventArgs e)
   at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource)
   at System.Collections.Generic.List`1.Enumerator.MoveNextRare()
   at System.Collections.Generic.List`1.Enumerator.MoveNext()
   at Microsoft.SSMA.Framework.Generic.XTree.XNode.ChildrenList.<GetEnumerator>d__1b.MoveNext()
   at Microsoft.SSMA.GUI.Components.Controls.TreeControllerLib.MultiCheckTreeView.GetCountNodes(XNode XNode)
   at Microsoft.SSMA.GUI.Components.Controls.TreeControllerLib.MultiCheckTreeView.InitProgress(XNode node)
   at Microsoft.SSMA.GUI.Components.Controls.TreeControllerLib.MultiCheckTreeView.FillItems(Object node)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading._TimerCallback.PerformTimerCallback(Object state)
[Generic: Mandatory] [4236/1] [2014-12-15 19:47:49]: SQL Server Migration Assistant for Access v5.3.0
[Collector: Error] [4236/5] [2014-12-15 19:49:33]: Access Object Collector: An error occurred while loading database content.
[Collector: Error] [4236/5] [2014-12-15 19:49:33]: Exception: Retrieving the COM class factory for component with CLSID {CD7791B9-43FD-42C5-AE42-8DD2811F0419} failed due to the following error: 80040154. This error may be a result of running SSMA as 64-bit application while having only 32-bit connectivity components installed or vice versa. You can run 32-bit SSMA application if you have 32-bit connectivity components or 64-bit SSMA application if you have 64-bit connectivity components, shortcut to both 32-bit and 64-bit SSMA can be found under the Programs menu. You can also consider updating your connectivity components from http://go.microsoft.com/fwlink/?LinkId=197502.
 site: Microsoft.SSMA.Framework.Access.DaoUtils.DaoMdbConnection TryConnectToDatabase(System.String, Boolean, System.String ByRef, Microsoft.SSMA.Framework.Access.DaoUtils.PasswordAsker, System.Nullable`1[Microsoft.SSMA.Framework.Access.DaoUtils.WorkgroupPolicySettings] ByRef, Microsoft.SSMA.Framework.Access.DaoUtils.WorkgroupPolicyAsker)
 source: Microsoft.SSMA.Framework.Access.DaoUtils
   at Microsoft.SSMA.Framework.Access.DaoUtils.DaoUtilities.TryConnectToDatabase(String fileName, Boolean readOnly, String& password, PasswordAsker passwordAsker, Nullable`1& workgroupPolicySettings, WorkgroupPolicyAsker workgroupPolicyAsker)
   at Microsoft.SSMA.Framework.Access.DaoUtils.DaoUtilities.ConnectToDatabase(String fileName, Boolean readOnly, String& password, PasswordAsker passwordAsker, Nullable`1& workgroupPolicySettings, WorkgroupPolicyAsker workgroupPolicyAsker)
   at Microsoft.SSMA.Framework.Access.Generic.AccessConnectionUtilities.ConnectToMdbFile(XNode xMdbFile, Boolean readOnly, IUIAskPasswordProvider askPasswordProvider, IUIWorkgroupPolicyProvider workgroupPolicyProvider)
   at Microsoft.SSMA.Framework.Access.Collector.Loaders.MDBFileLoader.LoadChildren(XNode xNode)
[Generic: Mandatory] [6820/1] [2014-12-15 19:51:35]: SQL Server Migration Assistant for Access v5.3.0
[Generic: Mandatory] [6960/1] [2014-12-15 19:55:32]: SQL Server Migration Assistant for Access v5.3.0
[Collector: Error] [6960/7] [2014-12-15 19:56:56]: Access Object Collector: An error occurred while loading database content.
[Collector: Error] [6960/7] [2014-12-15 19:56:56]: Exception: Retrieving the COM class factory for component with CLSID {CD7791B9-43FD-42C5-AE42-8DD2811F0419} failed due to the following error: 80040154. This error may be a result of running SSMA as 64-bit application while having only 32-bit connectivity components installed or vice versa. You can run 32-bit SSMA application if you have 32-bit connectivity components or 64-bit SSMA application if you have 64-bit connectivity components, shortcut to both 32-bit and 64-bit SSMA can be found under the Programs menu. You can also consider updating your connectivity components from http://go.microsoft.com/fwlink/?LinkId=197502.
 site: Microsoft.SSMA.Framework.Access.DaoUtils.DaoMdbConnection TryConnectToDatabase(System.String, Boolean, System.String ByRef, Microsoft.SSMA.Framework.Access.DaoUtils.PasswordAsker, System.Nullable`1[Microsoft.SSMA.Framework.Access.DaoUtils.WorkgroupPolicySettings] ByRef, Microsoft.SSMA.Framework.Access.DaoUtils.WorkgroupPolicyAsker)
 source: Microsoft.SSMA.Framework.Access.DaoUtils
   at Microsoft.SSMA.Framework.Access.DaoUtils.DaoUtilities.TryConnectToDatabase(String fileName, Boolean readOnly, String& password, PasswordAsker passwordAsker, Nullable`1& workgroupPolicySettings, WorkgroupPolicyAsker workgroupPolicyAsker)
   at Microsoft.SSMA.Framework.Access.DaoUtils.DaoUtilities.ConnectToDatabase(String fileName, Boolean readOnly, String& password, PasswordAsker passwordAsker, Nullable`1& workgroupPolicySettings, WorkgroupPolicyAsker workgroupPolicyAsker)
   at Microsoft.SSMA.Framework.Access.Generic.AccessConnectionUtilities.ConnectToMdbFile(XNode xMdbFile, Boolean readOnly, IUIAskPasswordProvider askPasswordProvider, IUIWorkgroupPolicyProvider workgroupPolicyProvider)
   at Microsoft.SSMA.Framework.Access.Collector.Loaders.MDBFileLoader.LoadChildren(XNode xNode)
[Generic: Mandatory] [4664/1] [2014-12-16 18:04:58]: SQL Server Migration Assistant for Access v5.3.0
[Collector: Error] [4664/7] [2014-12-16 18:06:58]: Access Object Collector: An error occurred while loading database information.
[Collector: Error] [4664/7] [2014-12-16 18:06:59]: Exception: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY))
 site: System.Object get_Value()
 source: Microsoft.Office.Interop.Access.Dao
 error code: -2147312566
   at Microsoft.Office.Interop.Access.Dao.Property.get_Value()
   at Microsoft.SSMA.Framework.Access.Collector.Loaders.MDBFileLoader.LoadDatabaseInfo(Database database, XNode xMdbFile)
   at Microsoft.SSMA.Framework.Access.Collector.Loaders.MDBFileLoader.LoadContent(XNode xNode)
[Gui: Error] [4664/7] [2014-12-16 18:07:02]: LowLevelAdapter.ConvertTree : Convert error: Microsoft.SSMA.Framework.Generic.Factories.Utils.NothingToProcessException: There is nothing to process.
   at Microsoft.SSMA.Framework.Generic.Factories.Utils.TreeTraverser`2.TraverseTree(TContext context, TState state, XNode sourceNode)
   at Microsoft.SSMA.Framework.Generic.Factories.Utils.OpTreeTraverser`2.TraverseTree(TContext context, TState state, XNode sourceNode)
   at Microsoft.SSMA.Framework.Access.SqlServerTreeConverter.Access2SqlServerTreeConverter.TraverseTree(ITreeConversionContext context, TreeConversionState state, XNode sourceNode)
   at Microsoft.SSMA.Framework.Generic.TreeConverters.Default.DefaultTreeConverter.ConvertTree(XNode sourceNode, ITreeConversionContext context)
   at Microsoft.SSMA.GUI.Generic.LowLevel.AppCommandProcessing.Commands.SsmaAppConvertCommand.StartConvert(Object context).
[Gui: Error] [4664/7] [2014-12-16 18:07:02]: Exception: There is nothing to process.
 site: Void TraverseTree(TContext, TState, Microsoft.SSMA.Framework.Generic.XTree.XNode)
 source: Microsoft.SSMA.Framework.Generic.Factories
   at Microsoft.SSMA.Framework.Generic.Factories.Utils.TreeTraverser`2.TraverseTree(TContext context, TState state, XNode sourceNode)
   at Microsoft.SSMA.Framework.Generic.Factories.Utils.OpTreeTraverser`2.TraverseTree(TContext context, TState state, XNode sourceNode)
   at Microsoft.SSMA.Framework.Access.SqlServerTreeConverter.Access2SqlServerTreeConverter.TraverseTree(ITreeConversionContext context, TreeConversionState state, XNode sourceNode)
   at Microsoft.SSMA.Framework.Generic.TreeConverters.Default.DefaultTreeConverter.ConvertTree(XNode sourceNode, ITreeConversionContext context)
   at Microsoft.SSMA.GUI.Generic.LowLevel.AppCommandProcessing.Commands.SsmaAppConvertCommand.StartConvert(Object context)
[Generic: Mandatory] [5740/1] [2014-12-16 18:10:09]: SQL Server Migration Assistant for Access v5.3.0
[Generic: Mandatory] [3436/1] [2014-12-16 18:10:26]: SQL Server Migration Assistant for Access v5.3.0
[Collector: Error] [3436/7] [2014-12-16 18:13:21]: Access Object Collector: An error occurred while loading database information.
[Collector: Error] [3436/7] [2014-12-16 18:13:21]: Exception: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY))
 site: System.Object get_Value()
 source: Microsoft.Office.Interop.Access.Dao
 error code: -2147312566
   at Microsoft.Office.Interop.Access.Dao.Property.get_Value()
   at Microsoft.SSMA.Framework.Access.Collector.Loaders.MDBFileLoader.LoadDatabaseInfo(Database database, XNode xMdbFile)
   at Microsoft.SSMA.Framework.Access.Collector.Loaders.MDBFileLoader.LoadContent(XNode xNode)
[Generic: Mandatory] [3944/1] [2014-12-16 18:13:27]: SQL Server Migration Assistant for Access v5.3.0
[Generic: Mandatory] [5228/1] [2014-12-16 18:17:56]: SQL Server Migration Assistant for Access v5.3.0

Tuesday, December 16, 2014 4:31 PM

0

Sign in to vote
It looks like compatibility issues.

Try this link

http://gaurangpatel.net/access-to-sql-server-migration-and-compatibility-issues

--Prashanth
- Proposed as answer by Donghui Li Wednesday, December 17, 2014 7:45 AM
- Marked as answer by Donghui Li Wednesday, December 24, 2014 1:16 AM
Tuesday, December 16, 2014 5:41 PM

Answered by:

Sql Server Migration Assistant(SSMA) library/Dll error

Question

Answers

All replies