如何通过hsodbc连sqlserver?

26856649

win2003 32
oracle 11.1.0.6.0
按网上查询的方法配制如下：
E:\app\Administrator\product\11.1.0\db_1\hs\admin\inithzyl_sql.ora# This is a sample agent init file that contains the HS parameters that are
# needed for an OLEDB Agent.
#
# HS init parameters
#
HS_FDS_CONNECT_INFO=hzyl_sql
HS_FDS_TRACE_LEVEL=0
#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>

listener.ora
# listener.ora Network Configuration File: E:\app\Administrator\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ORCL)
      (ORACLE_HOME = F:\app\Administrator\product\11.1.0\db_1)
      (GLOBAL_NAME = ORCL)
    )
    (SID_DESC =
      (ORACLE_HOME = F:\app\Administrator\product\11.1.0\db_1)
      (SID_NAME = hzyl_sql)
      (PROGRAM = hsodbc)
    )
  )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.253.5)(PORT = 1521))
    )
  )

# tnsnames.ora Network Configuration File: E:\app\Administrator\product\11.1.0\db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL248 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.253.248)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )
ORCL05 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.253.5)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )
hzyl_sql =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.253.5)(PORT = 1521))
    )
    (CONNECT_DATA= (SID=hzyl_sql))
    (HS=OK)
    )
  )

重启监听后
SQL> conn [url=]/@hzyl_sql[/url] as sysdba
ERROR:
ORA-12518: TNS: 监听程序无法分发客户机连接

teapot

没有sqlserver环境，帮你找了篇文档

26856649

必须要下载安装透明网关？