MDM Import Manager - Error Connecting to Source

Hi All,

Earlier my MDM5.5 installed in same server as that of Database server, so I was able to import the data from XML input files in MDM.

Now DB is migrated to different server, after completion of this activity, I was asked to test server functionality.

I am facing problem in Import manager, when i do manually I can able to import the data, when I tried to execute from DB server I am getting following error:

<Trace ts="2013/12/16 10:35:23.538 GMT" tid="9976" entry-no="0">Import Server job started</Trace> <Trace ts="2013/12/16 10:35:23.538 GMT" tid="9976" entry-no="1">Command line parsed</Trace> <Trace ts="2013/12/16 10:35:23.538 GMT" tid="9976" entry-no="2">OLE and socket initialized</Trace> <Trace ts="2013/12/16 10:35:25.897 GMT" tid="9976" entry-no="3">Connected to repository</Trace> <Failure ts="2013/12/16 10:35:25.959 GMT" tid="9976" entry-no="4" operation="Cannot load XML file.<LINE-FEED/>Error:<LINE-FEED/>COM error 80040154 Class not registered<LINE-FEED/>Source = <Trace ts="2013/12/16 10:35:25.959 GMT" tid="9976" entry-no="5">ImportManager Batch End</Trace>

Please let me know how to trouble shoot it. DO I need to make ODBC connection between the systems to work this.

Thanks,

Ganesh Mani.K