trying to connect to sybase but no way!!!!!!!!!!
615451Jan 1 2008 — edited Jan 4 2008hi all
I need to create a link between oracle 10g and sybase I setup getway (10201_gateways_win32) and make the chage in the file but not worked
the listener of the getway work in tnsping but when i try to enter tot the database I found error inn the network
I have oracle client , getway and sysbase on my PC and I TRY TO connent to oracle and sysbase in windows server the connection to the oracle made
successfully but the probelm in the sysbase although i connet to the sybase across odbc successfully
I feel i have some misunderstatnding but I hope to find my soluotion here
infromation:
the oracle client setuped on c:\
and getway on d:\
**************sqlnet. ora
# sqlnet.ora Network Configuration File: d:\oracle\product\10.2.0\tg_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
*****************************listner.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\product\10.2.0\tg_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = mghita.DOMAIN.ITSOFT.COM)(PORT = 1521))
)
)
**************************tnsnames.ora
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
this iformation before adding or modifing any thig
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully