SAP 在 64 位 WIN 和 OFFICE 上查询 RFC 连接“ActiveX 组件无法创建对象" [英] SAP query RFC connection on 64bit WIN and OFFICE "ActiveX component can't create object"
问题描述
我们曾经在 32 位 WIN 和 OFFICE 上使用对象SAP.LogonControl.1"的 SAP 查询在 excel (VBA) 中使用 RFC 连接.现在我们安装了 64 位版本的 WIN 和 OFFICE，我们遇到了ActiveX 组件无法创建对象"的问题.这是这条线，它是秋天:Set functionCtrl = CreateObject("SAP.LogonControl.1")有人有什么解决办法吗?不需要安装到 32 位.
We used to use RFC connection in excel (VBA) from SAP query with object "SAP.LogonControl.1" on 32 bit WIN and OFFICE. Now we installed 64 bit version of WIN and OFFICE and we have a problem with "ActiveX component can't create object". Here is the line, where it was fall: Set functionCtrl = CreateObject("SAP.LogonControl.1") Somebody some solution? Installation to 32bit is unwanted.
推荐答案
日期:2020-11-26有一个 SAP Support OSS Note (‘2724656’)，SAP 说他们不支持 Office 64 位直到明年(2021 年)SAPgui 770 的到来(因此 SAPgui 760 还没有)
Date: 2020-11-26 There is a SAP Support OSS Note (‘2724656’), Where SAP is saying they are not supporting Office 64 bits till next year (2021) with the arrival of SAPgui 770 (Thus NOT yet with SAPgui 760)
上面提供的代理解决方案适用于 SAPgui 750 和 760但它只涵盖了实际的 4 个 ActiveX 控件中的 1 个
The Surrogate solution provided above works fine with both SAPgui 750 and 760 but it covers only 1 of the actual 4 ActiveX controls
这是 4 个控件的完整解决方案，如果您将它们放在与下面相同的路径中:
Here is the full solution for the 4 Controls if you have them in same path as here below:
c:\program files (x86)\sap\frontend\sapgui\wdtaocx.ocx (SAP Table Factory)
c:\program files (x86)\sap\frontend\sapgui\wdobapi.ocx (SAP BAPI Control)
C:\Program Files (x86)\Common Files\SAP Shared\wdtlog.ocx (SAP Logon Control)
c:\program files (x86)\sap\frontend\sapgui\wdtfuncs.ocx (SAP Remote Function Call Control)
解决方案，创建一个 *.reg 文件并将其合并到您的 Windows 注册表:(首先在测试系统上执行此操作) - *.reg 文件的内容:
Solution, create a *.reg file and Merge it to your Windows Registry: (do this first on a test system) - Content of the *.reg file:
Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{2E9A4698-F0EE-11CF-AC55-080009D213D2}]
@="SAP BAPI"
"AppID"="{2E9A4698-F0EE-11CF-AC55-080009D213D2}"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{5B076C03-2F26-11CF-9AE5-0800096E19F4}]
@="SAP Remote Function Call"
"AppID"="{5B076C03-2F26-11CF-9AE5-0800096E19F4}"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{B24944D6-1501-11CF-8981-0000E8A49FA0}]
@="SAP Logon Control"
"AppID"="{B24944D6-1501-11CF-8981-0000E8A49FA0}"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{87D2850E-6B43-101C-92CE-10005AF5DF4D}]
@="SAP Table Factory"
"AppID"="{87D2850E-6B43-101C-92CE-10005AF5DF4D}"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{2E9A4698-F0EE-11CF-AC55-080009D213D2}\Control]
@=""
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{5B076C03-2F26-11CF-9AE5-0800096E19F4}\Control]
@=""
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{B24944D6-1501-11CF-8981-0000E8A49FA0}\Control]
@=""
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{87D2850E-6B43-101C-92CE-10005AF5DF4D}\Control]
@=""
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{2E9A4698-F0EE-11CF-AC55-080009D213D2}\InprocServer32]
@="c:\program files (x86)\sap\frontend\sapgui\wdobapi.ocx"
"ThreadingModel"="Apartment"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{5B076C03-2F26-11CF-9AE5-0800096E19F4}\InprocServer32]
@="c:\program files (x86)\sap\frontend\sapgui\wdtfuncs.ocx"
"ThreadingModel"="Apartment"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{B24944D6-1501-11CF-8981-0000E8A49FA0}\InprocServer32]
@="C:\Program Files (x86)\Common Files\SAP Shared\wdtlog.ocx"
"ThreadingModel"="both"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{87D2850E-6B43-101C-92CE-10005AF5DF4D}\InprocServer32]
@="c:\program files (x86)\sap\frontend\sapgui\wdtaocx.ocx"
"ThreadingModel"="Apartment"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{2E9A4698-F0EE-11CF-AC55-080009D213D2}\MiscStatus]
@="0"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{2E9A4698-F0EE-11CF-AC55-080009D213D2}\MiscStatus\1]
@="131474"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{5B076C03-2F26-11CF-9AE5-0800096E19F4}\MiscStatus]
@="0"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{5B076C03-2F26-11CF-9AE5-0800096E19F4}\MiscStatus\1]
@="132241"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{B24944D6-1501-11CF-8981-0000E8A49FA0}\MiscStatus]
@="0"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{B24944D6-1501-11CF-8981-0000E8A49FA0}\MiscStatus\1]
@="135569"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{87D2850E-6B43-101C-92CE-10005AF5DF4D}\MiscStatus]
@="0"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{87D2850E-6B43-101C-92CE-10005AF5DF4D}\MiscStatus\1]
@="132498"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{2E9A4698-F0EE-11CF-AC55-080009D213D2}\ProgID]
@="SAP.BAPI.1"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{5B076C03-2F26-11CF-9AE5-0800096E19F4}\ProgID]
@="SAP.Functions"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{B24944D6-1501-11CF-8981-0000E8A49FA0}\ProgID]
@="SAP.LogonControl.1"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{87D2850E-6B43-101C-92CE-10005AF5DF4D}\ProgID]
@="SAP.TableFactory.1"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{2E9A4698-F0EE-11CF-AC55-080009D213D2}\ToolboxBitmap32]
@="c:\program files (x86)\sap\frontend\sapgui\wdobapi.ocx, 200"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{5B076C03-2F26-11CF-9AE5-0800096E19F4}\ToolboxBitmap32]
@="c:\program files (x86)\sap\frontend\sapgui\wdtfuncs.ocx, 1"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{B24944D6-1501-11CF-8981-0000E8A49FA0}\ToolboxBitmap32]
@="C:\Program Files (x86)\Common Files\SAP Shared\wdtlog.ocx, 1001"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{87D2850E-6B43-101C-92CE-10005AF5DF4D}\ToolboxBitmap32]
@="c:\program files (x86)\sap\frontend\sapgui\wdtaocx.ocx, 2002"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{2E9A4698-F0EE-11CF-AC55-080009D213D2}\TypeLib]
@="{2E9A4698-F0EE-11CF-AC55-080009D213D2}"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{5B076C03-2F26-11CF-9AE5-0800096E19F4}\TypeLib]
@="{5B076C00-2F26-11CF-9AE5-0800096E19F4}"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{B24944D6-1501-11CF-8981-0000E8A49FA0}\TypeLib]
@="{B24944D6-1501-11CF-8981-0000E8A49FA0}"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{87D2850E-6B43-101C-92CE-10005AF5DF4D}\TypeLib]
@="{87D2850E-6B43-101C-92CE-10005AF5DF4D}"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{2E9A4698-F0EE-11CF-AC55-080009D213D2}\Version]
@="1.2"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{5B076C03-2F26-11CF-9AE5-0800096E19F4}\Version]
@="5.0"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{B24944D6-1501-11CF-8981-0000E8A49FA0}\Version]
@="1.1"
[HKEY_CLASSES_ROOT\WOW6432Node\CLSID\{87D2850E-6B43-101C-92CE-10005AF5DF4D}\Version]
@="1.1"
[HKEY_CLASSES_ROOT\WOW6432Node\AppID\{2E9A4698-F0EE-11CF-AC55-080009D213D2}]
"DllSurrogate"=""
[HKEY_CLASSES_ROOT\WOW6432Node\AppID\{5B076C03-2F26-11CF-9AE5-0800096E19F4}]
"DllSurrogate"=""
[HKEY_CLASSES_ROOT\WOW6432Node\AppID\{B24944D6-1501-11CF-8981-0000E8A49FA0}]
"DllSurrogate"=""
[HKEY_CLASSES_ROOT\WOW6432Node\AppID\{87D2850E-6B43-101C-92CE-10005AF5DF4D}]
"DllSurrogate"=""
这篇关于SAP 在 64 位 WIN 和 OFFICE 上查询 RFC 连接“ActiveX 组件无法创建对象"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
