ITPub博客

1、安装 Microsoft Data Access Components (MDAC)SDK ODBC driver 2、test whether CATHS has run.connect to the Oracle server as schema "SYSTEM" and do "DESCRIBE SYS.HS_FDS_CLASS". If it does not exist, connect as SYS (or internal) and run the CATHS script. (ORACLE_HOMERDBMSADMINCATHS.SQL) 3、建立 SQL SERVER 数据源 TEST_SQLSERVER 4、配置tnsnames.ora. (ORACLE_HOMENETWORKADMIN) TEST_SQLSERVER = (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=<IP地址>) (PORT=1521) ) (CONNECT_DATA