Pular para o conteúdo

Fóruns Banco de dados Oracle Usar o hsodbc.exe Usar o hsodbc.exe

#92315
airoosp
Participante

    Segue abaixo os arquivos que foram alterados:

    LISTERNER.ORA

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = TESTEBD)(PORT = 1521))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = e:oracleora92)
    (PROGRAM = extproc)
    (ENVS = “EXTPROC_DLLS=ANY”)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = ORCL)
    (ORACLE_HOME = e:oracleora92)
    (SID_NAME = ORCL)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = ORCLREST)
    (ORACLE_HOME = e:oracleora92)
    (SID_NAME = ORCLREST)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = ctginst1)
    (ORACLE_HOME = e:oracleora92)
    (SID_NAME = ctginst1)
    )
    (SID_DESC =
    (SID_NAME = ACESSO1)
    (ORACLE_HOME = e:oracleora92)
    (PROGRAM = hsodbc)
    )
    )

    TNSNAMES.ORA

    ACESSO1 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.5.14)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SID = ACESSO1)
    (HS=OK)
    )
    )

    SQLNET.ORA

    SQLNET.ORA Network Configuration File: e:oracleora92networkadminsqlnet.ora

    Generated by Oracle configuration tools.

    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

    initACESSO1.ORA

    This is a sample agent init file that contains the HS parameters that are

    needed for an ODBC Agent.

    #

    HS init parameters

    #
    HS_FDS_CONNECT_INFO = ACESSO1
    HS_FDS_TRACE_LEVEL = off
    #

    Environment variables required for the non-Oracle system

    #
    #set =

    Há alguma configuração errada? Será que pode ser a versão do driver ODBC para o Sql Server?

    Obrigado.

    Airton