- 论坛徽章:
- 0
|
SQL>; /
select count(*) from dbo.RESULT0@test
*
ERROR 位于第 1 行:
ORA-28500: 连接 ORACLE 到非 Oracle 系统时返回此信息:
[Generic Connectivity Using ODBC][Microsoft][ODBC SQL Server Driver][SQL
Server]Login failed for user 'SJBADMIN'. (SQL State: 28000; SQL Code: 18456)
ORA-02063: 紧接着2 lines(源于TEST)
我的inittraffic.ora,位于\ora9\hs\admin目录下,内容为
# 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 = traffic
HS_FDS_TRACE_LEVEL = ON
#
# Environment variables required for the non-Oracle system
#
#set <envvar>;=<value>;
traffic已在odbc中做了配置,数据库是mssql
登录到 MSSQL时用的USER与PASS(sa/空)我在ODBC配置中已指定了呀,怎么不起作用,ORACLE在登录到MSSQL时为何用我的ORALCE帐号呀 |
|