I'm getting an error code of -111 (Failed to connect to SBOCommon) when running BasicOperations.exe. I've seen that a number of others have experienced the same problem, but I haven't found the suggested solutions have worked in my case. (I didn't know whether I should post on the end of a previously resolved post or not, so apologies if this is in the wrong place)
I've deleted and re-added a reference to SAPbobsCOM using Visual Basic 2010, installed on my workstation, with the SAP licence server and DB server on different hardware on the network, hostname 'SQL1'. The version of SAP B1 is 2007 A (8.00.230) SP1 PL5. And SQL is v2005.
oCompany.Server = "SQL1"
oCompany.CompanyDB = "SBODemoUK"
oCompany.UserName = "manager"
oCompany.Password = "manager"
oCompany.language = SAPbobsCOM.BoSuppLangs.ln_English
oCompany.DbServerType = SAPbobsCOM.BoDataServerTypes.dst_MSSQL2005
oCompany.UseTrusted = False
lRetCode = oCompany.Connect
I've tried the latest DIAPI patch (the same DLL as on the server), using the server's IP instead of hostname, using the DB credentials instead of the SBO credentials, setting 'UseTrusted' to True, and also running the EXE on the server hardware itself to eliminate potential network restrictions.
I've been searching through the forums and SDK help files, but haven't been able to make any progress. Is anyone able to see where I'm going wrong.
Thank you in advance!