[ 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 |