Skip to Content
avatar image
Former Member

ODBC VS OLEDB In Designer

Hi All,

I'm using OLEBD provider for oracle connection in universe.The problem is BO is not fetching all the data from the DB.

If i use the ODBC connection in the same universe its fetching all the data.

What could be the reason for this weird behavior of BO, Please suggest some solution or workarounds.

I dont want to use ODBC connection,i want to get entire data using OLDEB connection only.

Regards,

Ravichandra K

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 16, 2009 at 12:37 PM

    Hello Ravichandra,

    the ODBC and OLEDB middleware is not supported for Oracle in Universe Designer.

    I don't know why you obtain different results but SAP Business Objects never tested that configuration.

    To access Oracle from a universe you should use JDBC or the Oracle Net middleware.

    Best regards

    PPaolo

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      The problem was fixed by SAP support Professional.

      We had to change the Oracle.prm file on the server.

      Regards,

      Ravichandra K