ActiveX组件无法创建对象：“ TDApiOle80.TDConnection” [英] ActiveX component can't create object: 'TDApiOle80.TDConnection'
问题描述
我正在尝试使用Excel Macro连接到QCServer。我正在使用64位操作系统，已完成以下操作：
I am trying to connect to QCServer using Excel Macro. I am using a 64-bit operating system with following being done:
- 注册OTAClient.dll
- 安装了HP ALM连接工具
- 添加了要引用的OTA库
我得到以下信息错误：
ActiveX组件无法创建对象：'TDApiOle80.TDConnection'
但是使用VBScript也在运行：
But the same is running using VBScript:
C：\Windows\SysWOW64\Wscript.exe C：\Users **** \Desktop\qcConn.vbs
C:\Windows\SysWOW64\Wscript.exe "C:\Users****\Desktop\qcConn.vbs"
推荐答案
这是由于COM对象问题，您需要在注册表中创建几个Key才能运行它没有问题。
This is due to the COM objects issue, you need to create few Key's in Registry to run it without issues.
1）在HKey_Classes_Root\Wow6432Node\CLSID [GUID]
下找到您的COM对象（TDAPIOLE80）GUID（位于父文件夹中），添加一个新的REG_SZ（字符串）值。名称应为AppID，数据应为您刚刚搜索的COM对象GUID（带有{}）。
1) Locate your COM object (TDAPIOLE80) GUID under the HKey_Classes_Root\Wow6432Node\CLSID[GUID] Once located (in the parent folder) add a new REG_SZ (string) Value. Name should be AppID and data should be the same COM object GUID (Along with {}) you have just searched for.
2）在HKey_Classes_Root\下添加一个新键Wow6432Node\AppID\，新密钥的名称应与com对象GUID相同（伴随{}）
2) Add a new key under HKey_Classes_Root\Wow6432Node\AppID\, the new key should be called the same as the com object GUID (Along with {})
3）在刚刚添加的新密钥下，添加一个新字符串（REG_SZ）值，并将其命名为DllSurrogate，将该值保留为空
3) Under the new key you just added, add a new string (REG_SZ) Value, and call it DllSurrogate, Leave the value empty
4）在HKey_Local_Machine\Software\Classes\下创建一个新键AppID\，同样，新密钥应与COM对象的GUID相同（与{}一起）。
4) Create a new Key under HKey_Local_Machine\Software\Classes\AppID\ , Again the new key should be called the same as the COM object’s GUID (Along with {}). No values are necessary to be added under this key.
有了这个，你应该很好！
With this you should be good!!
干杯!!
这篇关于ActiveX组件无法创建对象：“ TDApiOle80.TDConnection”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
