Question Re: ActiveX component can't create object - error 429 in Technology Q&A

ActiveX component can't create object - error 429

Vijay — Mon, 24 Aug 2020 15:42:45 GMT

stefan.schnell , sandra.rossi

Hi,

I am trying to call SAP Functions in Excel for MS Office 365 (64bit) and getting the error "ActiveX component can't create object - error 429" on execution.

I tried the registry hacks as are suggested by Stefan here , but still getting the error.

Below are the steps i performed.

Locate your COM object GUID under the HKey_Classes_Root\Wow6432Node\CLSID\[GUID]
Once located add a new REG_SZ (string) Value. Name should be AppID and data should be the same COM object GUID you have just searched for

Add a new key under HKey_Classes_Root\Wow6432Node\AppID\
The new key should be called the same as the com object GUID
Under the new key you just added, add a new REG_SZ (string) Value, and call it DllSurrogate. Leave the value empty

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. No values are necessary to be added under this key. (This entry was already existing with below values. I Guess automatically generated?? and with string Name DllSurrogate... Do i need to delete DllSurrogate entry from here?)

Below is the VB code i am trying with

Option Explicit


Public Functions As SAPFunctionsOCX.SAPFunctions
Private LogonControl As SAPLogonCtrl.SAPLogonControl
Private R3Connection As SAPLogonCtrl.Connection
Public TableFactory As SAPTableFactory
Dim Func As SAPFunctionsOCX.Function
Dim objBAPIControl, objgetaddress As Object

----------------------------------------------------------
Sub Button1_Click()
Dim retcd        As Boolean
Dim SilentLogon  As Boolean


' Set Connection
Set LogonControl = CreateObject("SAP.LogonControl.1")
Set objBAPIControl = CreateObject("SAP.Functions")
Set R3Connection = LogonControl.NewConnection
R3Connection.Client = "100"
R3Connection.ApplicationServer = "<saphost>"
R3Connection.Language = "EN"
R3Connection.User = "<username>"
R3Connection.Password = "<password>"
R3Connection.System = "<SID>"
R3Connection.SystemNumber = "<SNUMBER>"
R3Connection.UseSAPLogonIni = False
SilentLogon = False
retcd = R3Connection.Logon(0, SilentLogon)
If retcd <> True Then MsgBox "Logon failed": Exit Sub
objBAPIControl.Connection = R3Connection
End Sub

and below is the error i am getting

Re: ActiveX component can't create object - error 429

Sandra_Rossi — Mon, 24 Aug 2020 15:46:21 GMT

You must do it for all DLLs used. You did it for SAP Functions but you also use Logon.

Re: ActiveX component can't create object - error 429

Vijay — Mon, 24 Aug 2020 16:50:29 GMT

sandra.rossi

Thanks Sandra for your response. I did it for Logon also, but still the same error :(.

The only deviation i see from the mentioned steps is the entry under " HKEY_LOCAL_MACHINE\WOW6432Node\AppID". When i tried to create a new Key with GUID of control, it stops me as entry exist. I can find entry but along with Value "DllSurrogate" inside it (as shown in screen sot above) , which should be blank according to the steps. Do i need to delete this dllsurrogate entry from this node?

Thanks for your help Sandra.

Vijay

Re: ActiveX component can't create object - error 429

Sandra_Rossi — Mon, 24 Aug 2020 16:58:43 GMT

No it's fine, this is an automatic copy of what you entered first.

Re: ActiveX component can't create object - error 429

Sandra_Rossi — Mon, 24 Aug 2020 18:16:40 GMT

I didn't see that you also use SAPTableFactory, do you need it? If no, remove it. If yes, do the DllSurrogate.

Re: ActiveX component can't create object - error 429

Vijay — Tue, 25 Aug 2020 08:21:13 GMT

sandra.rossi

No, for now i don't need SAPTableFactory as i am trying to set up the connection first. I deleted the declaration also, but even after that i am getting the same error.

Re: ActiveX component can't create object - error 429

Sandra_Rossi — Tue, 25 Aug 2020 08:45:29 GMT

On which line do you have the error?

Re: ActiveX component can't create object - error 429

Stefan-Schnell — Tue, 25 Aug 2020 09:53:45 GMT

Hello vijay.sharma4,

your first AppID entry is at the wrong position. AppID value must be direct set at the GUID key, not in InprocServer32 key as in your case.

I tried it with wdtfuncu.ocx, the unicode variant of wdtfuncs.ocx, and it works as described.
It it not necessary to delete the DllSurrogate value at HKLM hive, as Sandra wrote, it is an automatic copy which does not hinder the function. After all, the description is more than six years old, I assume that the automatic duplication of entries in the registry did not exist at this time yet.

Best regards
Stefan

Re: ActiveX component can't create object - error 429

Vijay — Tue, 25 Aug 2020 09:57:40 GMT

sandra.rossi

On logonControl create object

Re: ActiveX component can't create object - error 429

Vijay — Tue, 25 Aug 2020 11:37:39 GMT

Thanks stefan.schnell for coming in for rescue :).

The correction that you mentioned fixed the object creation issue, but still not able to connect to SAP . getting the below exception.

Re: ActiveX component can't create object - error 429

Sandra_Rossi — Tue, 25 Aug 2020 12:12:38 GMT

vijay.sharma4 Please open a new question and close this one after marking it "accepted". I guess the error is on R3Connection.Logon. Also mention what you get if you don't log in silently.

Re: ActiveX component can't create object - error 429

Vijay — Tue, 25 Aug 2020 12:35:15 GMT

Sure sandra.rossi and thanks for your help with this. I am opening a new issue for connection error. Will loop you in that.