Skip to Content
0
Aug 01, 2016 at 12:55 AM

DIAPI Connection from SSIS Package failing 9.2 PL03

48 Views

Hi all,

I have an issue with a DI-API connection from an SSIS Package.

The error is: -111 "Unable to access SBO-Common database"

I have resolved this issue many times in the past and have done all the things like clearing SM_OBS_DLL folder from %TEMP% etc.

I have created another very basic app that does a DI-API connection using the exact same credentials and settings which is working fine.

The only difference between the two connections is the Interop.SAPbobsCOM.dll file

For the SSIS package I created a strong named version of the Interop library which is required to allow SSIS to work with external libraries. This was working pre-upgrade to version 9.2 PL03.

Has anyone else come across (and hopefully solved) this issue?

The fact that I am getting valid SAP Business One DI-API messages back regarding the failure suggests that the Interop.SAPbobsCOM.dll that is used by the SSIS Package is being called ok.

Cheers,
Sean