DTW-Could not load file or assembly'ADODB,Version=7.0.3300

[Former Member]

Hi All,

I am facing an error from importing files by using DTW. I have search in the SAP Notes 865191 - Data Transfer Workbench (DTW) Troubleshooting Guide. The recommendation of the notes is to reinstall .NetFrameWork. Also i have try to uninstall DTW and DIAPI, it doesnt help.

For my case i have already try to uninstall the .netframework from client server, it not able to solve this issue. Also this method will create extra issue on SAP client, its very risky for me to proceed with this recommendation.

Does anyone have any idea on solving this issue without uninstall the .netframework?

[ANKIT_CHAUHAN · Accepted solution]

Hi,

In addition to the answer above:

You can download the Primary Interop Assemblies (PIA) from the following link:

Primary Interop Assemblies Redistributable

Kind regards,

ANKIT CHAUHAN

SAP SME Support

[Former Member · Accepted solution]

Hi Ankit and Nagarajan,

My client is using Server 2012, we cannot reinstall the .Net Frame Work and Primary Interop Assemblies directly from the software. In Server 2012 we will not able to find .netframework in control panel because the structure of Window Server are different with normal Window.

I have tried to reinstall the .netframework in Server Manager, however it create extra issue for me, which my user are no longer able to use remote etc.

So i am thinking if there's other solution to solve this issue without reinstall the .netframework?

Thanks.

Regards,

Yiu Chern

[kothandaraman_nagarajan · Accepted solution]

Hi,

Escalate to SAP to fix this issue.

Regards,

Nagarajan

[ANKIT_CHAUHAN · Accepted solution]

Hi Yiu,

You should have installed Primary Interop Assemblies (PIA) only and I cannot relate how users are not able to remote access the system just because of .Net Framework.

Kind regards,

ANKIT CHAUHAN

SAP SME Support

[fredpena · Accepted solution]

Thank you; This option worked perfectly for me.

[kothandaraman_nagarajan]

Hi,

As per SAP note 865191,

• This issue occurs if adodb.dll file is missing in C:\Program Files (x86)\Microsoft.NET\Primary Interop Assemblies\ and/or C:\Windows\assembly. Please reinstall .Net Framework 4.0 and verifiy that adodb.dll file exists in the above locations. Reinstalling Office Primary Interop Assemblies is also required in few cases.

Regards,

Nagarajan

[former_member631450]

As ankit.chauhan1 told.

I have installed the complement and it creates the folder that kothandaraman.nagarajan wrote:

• C:\Program Files (x86)\microsoft.NET\Primary Interop Assemblies\adodb.dll

Solved!

[former_member540234]

OK procedimento realizado com sucesso!