Forum Stats

  • 3,768,187 Users
  • 2,252,756 Discussions
  • 7,874,485 Comments

Discussions

Configure Heterogeneous Connectivity between SQL Server x Oracle

1235»

Comments

  • Mkirtley-Oracle
    Mkirtley-Oracle Member Posts: 1,859
    Hi Denis,
    Glad you have it working now.

    Dg4ODBC maps ODBC datatypes to Oracle datatypes and this depend on the data type passed to it by the ODBC driver.
    This detailed in the documentation -

    Oracle® Database Gateway for ODBC
    User’s Guide
    11g Release 2 (11.2)

    in the section -

    Mapping ODBC Data Types to Oracle Data Types

    For example -

    ODBC Oracle
    SQL_BIGINT NUMBER(19,0)
    SQL_BINARY RAW
    SQL_CHAR CHAR

    If you have problems we need to know -

    - the datatype of the column in the SAP table, that is the column type in the create table statement
    - the datatype that this is translated to by the ODBC driver - which should be shown in an ODBC trace
    - the datatype that is seen by the gateway and the datatype to which it is mapped - shown by a gateway debug or 255 level trace

    Regards,
    Mike
  • DenisGomes
    DenisGomes Member Posts: 77
    Mike,
    I created a synonym to [email protected]

    CREATE PUBLIC SYNONYM sefcli
    FOR [email protected];

    I tried to execute select from sefcli;* by SAP Application. It's return an error "Syntax error in generated propram: The field string "TY_DATA" contains no fields ".

    Thanks,
    Denis
  • Kgronau-Oracle
    Kgronau-Oracle Posts: 2,550 Employee
    Are you able to select from SAP the table with the at command?
    select * from [email protected];
    Which SAP Application are you using and does it work with SQL*Plus?
This discussion has been closed.