Извините, еще раз о наболевшем...
Надо связать Оракл с СКЛ-ом. Эта тема уже подымалась, но, к сожалению, не помогло.
Оба сервера на Win2000.

tnsnames.ora:

hsmsql =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <имя_хоста>)( PORT = 1521))
)
(CONNECT_DATA =
(SID = msql)
)
(HS=OK)
)

listener.ora:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = <ора_хоум>)
(PROGRAM = extproc)
)
...
(SID_DESC =
(PROGRAM = hsodbc)
(SID_NAME = msql)
(ORACLE_HOME = <ора_хоум>)
)
)

<ора_хоум>\hs\admin\initmsql.ora:

HS_FDS_CONNECT_INFO = msql
HS_FDS_TRACE_LEVEL = 0
HS_FDS_TRACE_FILE_NAME = hsmsql.trc

ODBC-источник msql создан, протестирован.

создан дб-линк:

create database link msql
connect to "sa" identified by "пароль sa" using 'hsmsql';

при попытке обратиться:

select * from <таблица на SQL>@msql

выдает:

: (Error): ORA-28522: error initializing heterogeneous capabilities ORA-28522: error initializing heterogeneous capabilities ORA-28559: FDS_CLASS_NAME is ODBC65, FDS_INST_NAME is msql ORA-02063: preceding 3 lines from MSQL ORA-00604: error occurred at recursive SQL level 1 ORA-24274: no row exists in the HS$_BASE_CAPS table for these parameters ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86 ORA-06512: at "SYS.DBMS_HS_UTL", line 691 ORA-06512: at "SYS.DBMS_HS_CHK", line 51 ORA-06512: at "SYS.DBMS_HS_UTL", line 200 ORA-06512: at "SYS.DBMS_HS", line 38 ORA-06512: at line 1

Подскажите, плз, в чем ошибка?

to dba:

public не помог...