Reconnect to DI API

[Former Member]

The service is running permanently as a interface for a webshop, but loses connection to DI API from time to time.

So I try to reconnect after the connection is lost. It tells me that the connection is ok(oCompany != null && oCompany.Connected) but after a Recordset it always gives this error:

System.Runtime.InteropServices.COMException (0xFFFFF830): 1). [SAP AG][LIBODBCHDB32 DLL][HDBODBC32] Base table or view not found;259 invalid table name: Could not find table/view OCRD in
bei SAPbobsCOM.IRecordset.DoQuery(String QueryStr)

The reconnection is done the same way as the first connection. Even to disconnect the Connection and set oCompany to null did not help to solve this issue.

If anyone has a solution to this I would highly appreciate it.

[Former Member]

Hi Pedro,

thank you for your answere I will try this.

Still I find it strange that it works fine on the first connection.

Best Regards,

Thomas Thutewohl

[pedro_magueija]

Hi Thomas,

The HANA library has some issues (such as some unsupported features, etc...).

You can try to run a query to set the schema (user "name_of_schema";). But note that this has to be done by itself (not together with your other query).

If it still doesn't work, I'd open a ticket with SAP.

Pedro Magueija

LinkedIn | Twitter | Blog