[ Petar_Veliki @ 13.03.2006. 10:20 ] @
Pozdrav svima
Pokusavam da iz ORACLE 10.1.04 preko ODBC dodjem do tabela koje su u MS-SQL
Postavio sam u TNSNAMES.ORA sledece:
ime_ODBC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ime_racunara)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ime_ODBC)
)
(HS=OK)
)

zatim LISTENER.ORA
(SID_DESC =
(SID_NAME = ime_sql)
(ORACLE_HOME = D:\OraHome_1)
(PROGRAM = ime_ODBC)
)
i na kraju INITHSODBC.ORA
HS_FDS_CONNECT_INFO = ime_ODBC

HS_FDS_TRACE_LEVEL = off

kada napisem tnsping=ime_ODBC
dobijem odgovor za 10 ms
postoji i jedan db_link
sql-select
select * from all_tables@db_link

ERROR at line 1:
ORA-28545: Von Net8 bei der Verbindung zu einem Agenten diagnostizierter Fehler
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: vorherige 2 lines von db_link

zna li neko o cemu se radi.
Hvala