Oracle 连Informix

最新推荐文章于 2022-10-19 09:38:34 发布

crc_2013

最新推荐文章于 2022-10-19 09:38:34 发布

阅读量333

点赞数

文章标签：数据库网络操作系统

oracle连informix,   help me
你好,我用odbc及一些网上资料配置成功了oracle建与INFORMIX的连接(create database link),且能select *  from goods没问题,但select goodsid  from goods就报无效列名.请问怎么解决,我发誓一定有goodsid字段

请一定帮帮我,我太需要了.谢谢. 不然我这个月会被炒了.

有兴趣的朋友可研究下,我提供些资料
1.设置odbc数据源 frominformix
2.oracle安装路径下/network/admin/下tnsnames.ora文件添加

Link2Informix =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.15.113)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = hs4Informix)
    )
    (HS = OK)
  )

3.oracle安装路径下/network/admin/下listener.ora文件

在SID_LIST_LISTENER的SID_LIST中添加
    (SID_DESC =
      (SID_NAME = hs4Informix)
      (ORACLE_HOME = D:\oracle\ora92)--为您的ORACLE安装目录
      (PROGRAM = hsodbc)
    )

4.oracle安装路径下/hs/admin/添iniths4Informix.ora
# This is a sample agent init file that contains the HS parameters that are
# needed for an ODBC Agent.

#
# HS init parameters
#
HS_FDS_CONNECT_INFO = frominformix
HS_FDS_TRACE_LEVEL = 1

#
# Environment variables required for the non-Oracle system
#
#set =

5.在cmd窗口下
sqlplus test/test@lydb

---设置全局变量无效
alter system set global_names = false;

--------创建DBLINK
create database link rt connect to "informix" identified by "bbgxxb103" using 'LinkInformix';
-------取数据
insert into T_IndLbtNew select * from goods@rt;

oracle访问informix的问题

数据库版本是：oracle10.2.0
操作系统为：windows2003

想通过ORACLE的异构服务功能与sqlserver2000和informix连接。sqlserver2000l连接成功。但是访问informix的时候，用informix 2.80 32 bit的配置，建立数据连接提示错误：
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][Informix][Odbc Informix Driver][Informix]Incorrect password or user INFORMIX. is not known on the database server. (SQL State: S1000; SQL Code: -951)
ORA-02063: preceding 2 lines from HS4INF

而实际上用户名和密码都是正确的

若是用intersolv 3.01 32-bit informix 建立ODBC，在ORACLE中建数据库连接后使用提示错误：
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC]由于系统错误 126 (INTERSOLV 3.01 32-BIT INFORMIX)，指定驱动程序无法加载。 (SQL State: IM003; SQL Code: 160)
ORA-02063: preceding 2 lines from HS4INF