Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2006
    Posts
    2

    Unanswered: Problems in a connection Oracle-Sybase (is long)

    I ran into dbforums looking for a solution to a problem in my new job. I know, it is my job, my problem, but I am new and I would really appreciate your help in my three months trial period.
    The problem I am faced with is to communicate an Oracle server with Sybase. This Oracle is talking to a MSSQL-Server without problems, and was (supposedly) already talking with Sybase until the communication was cut.
    They have in the server
     A file named TNSNAMES.ORA containing
    EntryForMyOracleServer =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SynonymOflocalhost)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = IdenticalToEntryForMyOracleServer)
    )
    )

    ------ long list of entries ------

    EntryForServer1 =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
    (SID = NameOfServer1))
    (HS = OK)
    )

    EntryForServer2 =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
    (SID = NameOfServer2))
    (HS = OK)
    )

     A file named LISTENER.ORA containing
    SID_LIST_LISTENER =
    ------ long list of entries ------
    (SID_DESC =
    (SID_NAME = NameOfServer1)
    (ORACLE_HOME = D:\Oracle\EtcEtc)
    (PROGRAM = hsodbc)
    )
    (SID_DESC =
    (SID_NAME = NameOfServer2)
    (ORACLE_HOME = D:\Oracle\EtcEtc)
    (PROGRAM = hsodbc)
    )
    LISTENER = 0
    (DESCRIPTION_LIST =
    (DESCRIPTION
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = OneName)(PORT = 1521)))
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    )
    )

     An entry in ODBC, accessed thru the ODBC data source administrator, for each connection that I need to establish.
     Two files (one for each server I want to connect to) named InitNameOfServer1.ora and InitNameOfServer2.ora containing each the name of the entry in the ODBC file DSN list and a parameter HS_FDS_TRACE_LEVEL put in zero (ON? OFF?)
     I am using TOAD connected to my Oracle server to configure and tune all the circuit. Each time I try the connection with server 1 I receive an immediate answer, when I try server 2 the TOAD dies. It looks like a truck on a flesh and blood toad.

    The questions are,
    1) What can I change and try without having to restart the server?
    2) Am I missing something that impedes me to connect?
    3) Does anybody have any idea?


    THANKS IN ADVANCE

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    Maybe these instructions in the manual could help you.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Jun 2006
    Posts
    2

    Solved!

    Thanks!
    It's solved!

    The ODBC driver I was using was a trial of a third partie provider. Using it from Excel it gave a window message telling that the trial will end in a few days. Using it from Oracle the emision of the window was ignored, the OK button was not clicked and Oracle kept waiting for the table.
    We changed the driver and, after a new problem, it is working.
    Unfortunatelly for me (I'm still in my three month trial period) it wasn't me who solved the issue.

Posting Permissions

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