Creating session using ClearQuest API on 64bit-Windows results ActiveX error.(by VBA)
I ran ExcelVBA creating CQsession, and it resulted in ActiveX error.
< VBA Code>
Set objSession = CreateObject("CLEARQUEST.SESSION")
< Error >
429: ActiveX component can't create object
< environment>
Excel 2010
Windows7-64bits
ClearQuest V8.0.1
I found this page below, but the way to resolve didn't work for VBA. (It's for VBScript)
http://www-01.ibm.com/support/docview.wss?uid=swg21447229
Has anyone found a way to create session of CQ from VBA on Windows-64bit?
Thanks,
Ayumi
One answer
Is your Excel 2010 64 bit or 32 bit? If 64 bit, you need to do some debugging to find out your own solution.
You can use the technote as a guideline. Basically the 32 bit executable and 64 bit executable look in different places of the Windows registry, and you need to know where it is looking and how to tell the application to look elsewhere.
Use Process Monitor to identify all the registry keys being read by Excel. Whether you can and/or how to tell Excel to check a different registry key, you will need to ask Microsoft.
Also, this is a ClearQuest question and you'd better ask the question in the ClearQuest forum.
https://www.ibm.com/developerworks/community/forums/html/forum?id=11111111-0000-0000-0000-000000000329
You can use the technote as a guideline. Basically the 32 bit executable and 64 bit executable look in different places of the Windows registry, and you need to know where it is looking and how to tell the application to look elsewhere.
Use Process Monitor to identify all the registry keys being read by Excel. Whether you can and/or how to tell Excel to check a different registry key, you will need to ask Microsoft.
Also, this is a ClearQuest question and you'd better ask the question in the ClearQuest forum.
https://www.ibm.com/developerworks/community/forums/html/forum?id=11111111-0000-0000-0000-000000000329
Comments
My Excel 2010 is 64 bit.
Is C:\Windows\SysWOW64 the right place that the application look in?
And I'll ask the question in the ClearQuest forum.
Thank you.
My Excel 2010 is 64 bit.
Is C:\Windows\SysWOW64 the right place that the application look in?
And I'll ask the question in the ClearQuest forum.