Skip to Content
avatar image
Former Member

Reconnect to DI API

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 23, 2016 at 12:24 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 23, 2016 at 01:29 PM

    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

    Add comment
    10|10000 characters needed characters exceeded