Results 1 to 5 of 5

Thread: Help needed for Heterogenous Service from Oracle to Sql server

  1. #1
    Join Date
    Oct 2008
    Posts
    3

    Unhappy Help needed for Heterogenous Service from Oracle to Sql server

    hi,

    When i am trying to connect from oracle to Sql server through db_link following error is showing. Please try to help me out in this regard.

    SQL> desc temp_empbankacc_gpms@sqltest
    ERROR:
    ORA-28545: error diagnosed by Net8 when connecting to an agent
    Unable to retrieve text of NETWORK/NCR message 65535
    ORA-02063: preceding 2 lines from SQLTEST

    Heterogenous Configuration Details
    ------------------------------------
    ODBC.ini
    ----------

    [sqltest]
    Driver = TDS
    Description = MS SQL Test
    Trace = No
    Servername = MSTEST
    Database = VDPMASTER
    UID =
    Port = 1433

    odbcinst.ini
    ------------

    [TDS]
    Description = v0.62.3 with protocol v4.2
    Driver = /usr/local/lib/libtdsodbc.so
    Setup = /usr/local/lib/libtdsodbc.so
    FileUsage = 1
    CPUTimeout =
    CPReuse =

    [ODBC]
    Trace = Yes
    TraceFile = /tmp/freetds.log
    ForceTrace = Yes
    Pooling = No


    freetds.conf
    --------------
    [MSTEST]
    host = 172.27.42.179
    port = 1433
    tds version = 8.0

    initSQLTEST.ora
    ----------------

    # needed for an ODBC Agent.

    #
    # HS init parameters
    #

    HS_FDS_CONNECT_INFO = sqltest

    HS_FDS_TRACE_LEVEL = 0

    following is Added in my existing listener.ora
    -------------------------------------------


    (SID_DESC =
    (ORACLE_HOME=/u01/payroll/oracle/product/10.2.0.1)
    (PROGRAM=hsodbc)
    (SID_NAME=sqltest)

    following is Added in my existing tnsnames.ora
    -------------------------------------------
    SQLTEST =
    (DESCRIPTION=
    (ADDRESS_LIST=
    (ADDRESS=
    (PROTOCOL=TCP) # edit to point to your LISTENER
    (HOST=172.16.189.186) # edit to point to your LISTENER
    (PORT=1522) # edit to point to your LISTENER
    )
    )
    (CONNECT_DATA=(SID=sqltest))
    (HS=OK)

    I can able to connect with isql and tsql...

    but i am unble to connect with db_link

    SQL> CREATE PUBLIC DATABASE LINK sqltest connect to "payrolluser" IDENTIFIED by "user@payroll" using 'sqltest';

    Database link created.
    SQL> desc temp_empbankacc_gpms@sqltest
    ERROR:
    ORA-28545: error diagnosed by Net8 when connecting to an agent
    Unable to retrieve text of NETWORK/NCR message 65535
    ORA-02063: preceding 2 lines from SQLTEST


    where i would have gone wrong. Please help me.


    Thanks in Advance.
    Rama.

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,922
    Are you on 32-bit or 64-bit platform for sql server? ODBC does not work on 64-bit.

  3. #3
    Join Date
    Oct 2008
    Posts
    3
    Thanks for your reply ...

    I am Working on 64 bit platform ....Is there any alternative to work with ODBC in 64 Bit platform? Please Help me.

  4. #4
    Join Date
    Oct 2008
    Posts
    3
    hi,

    clarification for the above query...

    I am trying to connect from oracle 64 bit to 32 bit sqlserver and oracle 64 bit to 64 bit sql server.

    Which is compatible to connect with ODBC?

  5. #5
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,922
    There is 64-bit ODBC driver in windows. Try OLEDB.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •