RFA C++ 8.2.2 Win: Session request through Excel COM Add-in failing

Vijay Krishnasamy

I am trying to migrate our Excel COM add-in x86 build using RFA 7 to x64 using RFA 8.2.2. New COM component works during Unit Test (while making call directly), but when we run via Excel, it fails to send out connection request. No request going out on the wire either.
All I see in the log is:

[Tue Oct 8 11:43:30 2024]: (ComponentName) Connections: (Severity) Error: Failed to load the library "Connection_RSSL", the system error message is "The specified module could not be found.

Error Code: 126 Mode File: RFA8_RSSL_Cons_Adapter"

[Tue Oct 8 11:43:30 2024]: (ComponentName) Connections: (Severity) Error: Failed to create connection : "Error acquiring Connection (acquire returns null) - Connection_RSSL".

Jirapongse

@Vijay Krishnasamy

Thank you for reaching out to us.

I got the same error message if I deletes the RFA8_RSSL_Cons_Adapter143_x64.dll file from the working directly. Therefore, the RFA API can't find this file.

[Wed Oct  9 10:31:33 2024]: (ComponentName) Connections: (Severity) Error: Failed to load the library "Connection_RSSL", the system error message is "The specified module could not be found.
 Error Code: 126 Mode File: RFA8_RSSL_Cons_Adapter"

[Wed Oct  9 10:31:33 2024]: (ComponentName) Connections: (Severity) Error: Failed to create connection :  "Error acquiring Connection (acquire returns null) - Connection_RSSL"

You need to check the working directory used by Excel COM Add-ins and make sure that the RFA DLL files are in that directory. Otherwise, you may copy the RFA DLL files to the c:\windows\system32 directory.

Vijay Krishnasamy

Many thanks @Jirapongse for getting back. I already have all the dlls in the directory. I tried to compare my add-in connection request with the unit test and this is what I found and might help to identify what could be the issue here:

One of the thread try to acquire connection making calls to

sessionLayer::acquireSASS3_Connection in Unit Test and sessionLayer::acquireRSSL_Connection in Excel Add-in.

My configurations are in registry and expect both to use it. If they are, why is this different and what configuration should I check. Also why acquireSASS3_Connection load RSSL_cons _* dlls, but acquireRSSL_Connection fails to load?

Vijay Krishnasamy

@Jirapongse, on back of your suggestion I tried adding RFA directory to path and it worked. Many thanks for your help. Looks like as it is operating through Excel, indirectly loading dlls need to be on path. This wasn't the case with x86 working with Excel 2016.