I dont have a clue why my config dont work, so i need you help:
I connect from SLES 64 bit to a MSSQL 2008R2 Server my system odbc is calles MSSQL and works wit isql -v mssql <user> <pw>.
I can see an error in my /hs/log like this
Oracle Corporation --- THURSDAY FEB 09 2012 15:45:07.202
Heterogeneous Agent Release
11.2.0.1.0
HS Agent diagnosed error on initial communication,
probable cause is an error in network administration
Network error 2: NCR-00002: NCR: Invalid usage
HS Gateway: NULL connection context at exit
Here my config files:
initdg4odbc.ora
# This is a sample agent init file that contains the HS parameters that are
# needed for the Database Gateway for ODBC
#
# HS init parameters
#
HS_FDS_CONNECT_INFO = mssql
HS_FDS_TRACE_LEVEL = 4
##HS_FDS_SHAREABLE_NAME=/usr/local/lib/libtdsodbc.so
#HS_FDS_SHAREABLE_NAME = <full path name of odbc driver manager or driver>
#
# ODBC specific environment variables
#
##set ODBCINI=<full path name of the odbc initilization file>
#
# Environment variables required for the non-Oracle system
#
##set <envvar>=<value>
##set LIBPATH=/usr/local/lib:
sqlnet.ora:
# sqlnet.ora Network Configuration File: /opt/oracle/product/11gR1/db/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NONE)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
ADR_BASE = /opt/oracle
listener.ora
# listener.ora Network Configuration File: /opt/oracle/product/11gR1/db/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle.internal.netlogix.de)(PORT = 1521))
)
)
SID_LIST_LISTENER=(SID_DESC=(SID_NAME=orcl)(PROGRAM=dg4odbc))
ADR_BASE_LISTENER = /opt/oracle
tnsnames.ora
# tnsnames.ora Network Configuration File: /opt/oracle/product/11gR1/db/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =(ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = oracle.internal.netlogix.de)(PORT = 1521)))(CONNECT_DATA= (SID=orcl))(HS=OK))
tnsping orcl resolves like this:
tnsping orcl
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 09-FEB-2012 15:54:40
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
/opt/oracle/product/11gR1/db/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION =(ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = oracle.internal.netlogix.de)(PORT = 1521)))(CONNECT_DATA= (SID=orcl))(HS=OK))
OK (0 msec)
Hope anyone can find my typo. im no oracle guru.
Tank you