I would suggest using recordset with DI API −SAPbobsCOM.Recordset rs = ((SAPbobsCOM.Company)oCompany.GetDICompany()).GetBusinessObject(BoObjectTypes.BoRecordset); rs.DoQuery("SELECT DocEntry, DocNum, DocDate, TaxDate, CardCode, CardName, DocTotal    FROM OPOR ORDER BY DocDate ASC"); while (!rs.EoF) {    int DocEntry = rs.Fields.Item("DocEntry").Value;    //OR    DocEntry = rs.Fields.Item(0).Value;    rs.MoveNext(); }

The answer lies within the exception message itself. The connection string that you are using to connect to the Business object server is wrongly configured. Check for each parameter, you will find something must be wrong and hence why you are receiving this error message.

In SAP Business One, SBO-Common is only used in functionality handling or following your company database. Normal day to day business functions happens entirely in the company database. You can create a new set of sample database SBO-COMMON by reinstalling SAP B1 server. SBO-Common database holds this information − DB List (DB's which having SAP DB Structures) DB Details like Version, Upgrade Details License Details For more details about SBO-COMMON database, you can refer below link − https://archive.sap.com/discussions/thread/1447063

This looks like an issue with Join in queries. Try replacing Inner join with Left join like this. I ran this query and it is working fine:select T0.DocNum as 'Payment Number', T0.DocDate 'Payment Date', T0.CardCode, T0.CardName 'Customer Name', T1.BankCode 'Bankcode', T3.BankName 'Bank Name', T2.Phone1 , T0.CreditSum, T0.CashSum, T0.TrsfrSum, t0.CheckSum, t1.CheckNum as 'Check Number', t1.DueDate as 'check date', t6.VoucherNum as 'Voucher Number', t0.TrsfrRef as 'Transfer No', t0.TrsfrDate AS 'Transfer Date', ousr.USER_code as 'user code', T5.DocNum, t11.U_P_BuildingName as 'Building Name', CASE when T5.DocNum is null then 'On Account' else 'Paid For Invoice' END AS 'Payment Status', CASE when T5.DocStatus = 'O' then ... Read More

Try deleting all the files under this location - %UserProfile%\AppData\Local\SAP\SAP Business One\Log\DIAPIWhen you delete all files, it will speed up the connection process.