|
|
|
connects to HO.WORLD
|
|||
|---|---|---|---|
|
#18+
ODBCREN - ODBC источник в SYSTEM DSN на другую не-Oracle БД. Вот sqlnet.ora NAMES.DEFAULT_DOMAIN =COI.I.COM.UA SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES) Вот listener.ora (SID_DESC = (PROGRAM = hsodbc) (SID_NAME = ODBCREN) (ORACLE_HOME = D:\Oracle\ora81) ) Вот TNSNAMES.ORA ODBCREN.COI.I.COM.UA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = PENTIUM4)(PORT = 1521)) ) (CONNECT_DATA = (SID =ODBCREN ) ) (HS = OK) ) Вот линк create public database link ODBCREN.COI.I.COM.UA connect to "SYSDBA" identified by "sysadmin" using 'ODBCREN'; Вот запрос select * from paycode@ODBCREN.COI.I.COM.UA Вот ответ ORA-02085: database link ODBCREN.COI.I.COM.UA connects to HO.WORLD В чем проблема? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 23.12.2002, 17:23 |
|
||
|
connects to HO.WORLD
|
|||
|---|---|---|---|
|
#18+
а описание ошибки как обычно лень прочитать? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 23.12.2002, 17:30 |
|
||
|
connects to HO.WORLD
|
|||
|---|---|---|---|
|
#18+
ORA-02085: database link name connects to name Cause: The database link attempted to connect to a database with a different name. The name of the database link must be the same name as the name of the database. Action: Create a database link with the same name as the database to which it connects И че? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 23.12.2002, 18:10 |
|
||
|
connects to HO.WORLD
|
|||
|---|---|---|---|
|
#18+
create public database link ODBCREN connect to "SYSDBA" identified by "sysadmin" using 'ODBCREN'; ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 23.12.2002, 18:20 |
|
||
|
connects to HO.WORLD
|
|||
|---|---|---|---|
|
#18+
Когда пишешь такое вот, как советует dba create public database link ODBCREN connect to "SYSDBA" identified by "sysadmin" using 'ODBCREN'; Создается линк ODBCREN.US.ORACLE.COM и понятное дело с запросом ничего не выходит. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 23.12.2002, 19:11 |
|
||
|
|

start [/forum/topic.php?fid=52&msg=32083325&tid=1992373]: |
0ms |
get settings: |
10ms |
get forum list: |
15ms |
check forum access: |
5ms |
check topic access: |
5ms |
track hit: |
196ms |
get topic data: |
12ms |
get forum data: |
3ms |
get page messages: |
64ms |
get tp. blocked users: |
2ms |
| others: | 245ms |
| total: | 557ms |

| 0 / 0 |
