You’re offline. This is a read only version of the page.
Greetings -
I am relatively new to Dynamics, so please forgive me if I get some of this wrong.
I am setting up my first company in dynamics and I ran into an issue. Everything appears to be installed correctly, and I am having no problems setting up the mappings. I am using an advanced ODBC map with a sql statement as the source and the chart of accounts as the destination. The map is VERY simple (this is just a test).
When I start the integration I get this wonderfully helpful error:
The destination could not be initialized due to the following problem:
- Unable to cast COM object of type 'System.__ComObject' to interface type 'Dynamics.Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{6D016638-BA35-11CF-827E-00001B27AB13}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).
Then I found this:
https://support.microsoft.com/en-us/kb/942750
It said to run this command: regsvr32 C:\Windows\sysWOW64\MSScript.ocx
I did everything it said, but I get the same error. Does anyone have any idea what is going on here? Thanks for any help.
*This post is locked for comments
Thanks Sean - I got this to work finally. For anyone else who runs into this, here is what I did.
1. I used the domain admin to install GP. However, the domain admin was not in the local administrators group. I added the domain admins group to the local administrator group
2. I uninstalled GP completely along with IM.
3. I reinstalled GP - and yes, it was a bit of a pain. All of my companies disappeared. I am not well enough versed in GP to figure out how to re-add them. Be warned if you do this step and have a bunch you need.
4. I reinstalled IM.
After all that, I got the integration with the advanced ODBC connection to work. I have errors, but those are related to structure of the file.
I have not tested the web client or anything else yet, so I might have to redo that as well.
Thanks again for the help Sean and Richard!
I would uninstall Integration Manager and then re-install IM from the GP2015 installation screen.
A bit more information - the DEX.DIC file that gets created is dated 12/6/2012. That is probably not the one I want.....
Where does that come from?
No, there is not. I am thinking about uninstalling everything (GP and IM) and reinstalling. Do you think that would help?
BTW, I am opening GP to the company I wish to process the COA.
Tom -
On the server where IM is installed, under the Microsoft Dynamics folder, is there an old GP2013 folder?
Thanks Sean - I will try this once I resolve the above error.
I do appreciate the help - this has been a wonderful learning experience!
Ok, a bit more information.
First, I had to add the domain admin to the local administrator group on the server. That got past the old error message sort of.
Now I get an error that says DEX.DIC version 12.00.0196.000 is not compatible with executable versio9n 16.00.0027.000. I do not have GP 2013 on this machine, so I haven't the foggiest idea where that DEX.DIC file came from. I saw where I should be able to rename this file and have it just recreate it by repairing GP. That did not work though.
Any ideas on what to do from here? Is there a way to see if somehow an old GP2013 version is still installed? I do not see it in programs or anything but perhaps there is a registry setting?
Tom,
I'm going to ask this question, just to make sure and mean no offense, but you are opening Dynamics GP to the company you want to integrate the data into before running the integration - correct?
If you've done everything else Richard and I have suggested, I would try a CSV file again using a simple Text ODBC driver. Create your CSV file with the following columns:
Populate your data and then create your text ODBC/DSN and see if this works. There's should be a need to use an Advanced ODBC trying to connect to a SQL table to load a chart of accounts. Just a suggestion.
Richard, I have tried running Integration manager and GP as administrator. That did not work.
Sean,
I tried to load with a CSV - that did not work either. I also made sure that the user I had had full access to all dynamics folders, again that did not help. I get this error message if it helps:
The destination could not be initialized due to the following problem:
- Unable to cast COM object of type 'System.__ComObject' to interface type 'Dynamics.Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{6D016638-BA35-11CF-827E-00001B27AB13}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,188
Super User 2024 Season 2
#2
Martin Dráb
230,030
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (