| connectivity of sql server into oracle through heterogenius services [message #516194] |
Fri, 15 July 2011 07:55  |
lancer26
Messages: 52
Registered: May 2006
Location: Pakistan
|
Member |
|
|
dear all,
i want to update table based on sql server view daily basis, for this, i did following steps
1. configure system dsn odbc named "ASMSQL"
2. create inithsodbc.ora file in hs/admin folder,
set parameter as
HS_FDS_CONNECT_INFO = ASMSQL
HS_FDS_TRACE_LEVEL = 0
complete file is attached.
3.edit TNSNAMES.ORA file in network/admin folder as following
hsodbc =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL=TCP)(HOST=localhost)(PORT=1521))
)
(CONNECT_DATA =(SID=hsodbc)
)
(HS=OK)
)
4. edit listener.ora file as following
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = hsodbc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = hsodbc)
)
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = developer-fpr.azgard9.com)(PORT = 1521))
)
)
5. finally create db link as following
CREATE PUBLIC DATABASE LINK "TESTSQL.REGRESS.RDBMS.DEV.US.ORACLE.COM"
CONNECT TO ORAFPR
IDENTIFIED BY <PWD>
USING 'hsodbc';
when i select data from that db link i got following error
*********************************************************************
Link : "TESTSQL.REGRESS.RDBMS.DEV.US.ORACLE.COM"
Error : ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'ORAFPR'. Reason: Not associated with a trusted SQL Server connection. (SQL State: 28000; SQL Code: 18452)
ORA-02063: preceding 2 lines from TESTSQL
*********************************************************************
through sql server client it's working fine but created error through oracle, kindly help.....
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
