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