oracle连接sql2005

Oracle连接sql2005 odbc设置

 

 

测试完成。

 F:\oracle\product\10.2.0\db_1\hs\admin中新添inithsexam.ora和inithsmsql.ora

inithsexam.ora:

HS_FDS_CONNECT_INFO = exam

HS_FDS_TRACE_LEVEL = off

inithsmsql.ora:

HS_FDS_CONNECT_INFO = ora2msql

HS_FDS_TRACE_LEVEL = off

 

 F:\oracle\product\10.2.0\db_1\network\ADMIN中修改listener.ora和tnsnames.ora文件

 Listener.ora:

(SID_DESC =

      (SID_NAME = hsmsql)

      (ORACLE_HOME = f:\oracle\product\10.2.0\db_1)

      (PROGRAM = hsodbc)

)

 (SID_DESC =

         (SID_NAME = hsexam)

         (ORACLE_HOME = f:\oracle\product\10.2.0\db_1)

         (PROGRAM = hsodbc)

)

 

 tnsnames.ora:

ora2msql =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = LOCALHOST)(PORT = 1521))

    (CONNECT_DATA = (SID = hsmsql))

    (hs=ok)

    )

 

exam =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = LOCALHOST)(PORT = 1521))

    (CONNECT_DATA = (SID = hsexam))

    (hs=ok)

)

 

 两个DBLink，DBLink设置（要区分大小写）：

create public database link "exam" connect to "hengqi" identified by "hengqi" using 'exam'

create public database link "ora2msql" connect to "hengqi" identified by "hengqi" using 'ora2msql'