 Urgence,Issue about transparent gateway to MSSQLServer [message #404995] |
Tue, 26 May 2009 00:46  |
wqq_chen
Messages: 2
Registered: May 2009
|
Junior Member |
|
|
Envirenment:windowsxp + oracle 10.2.0.1 + oracle gateways:192.168.1.44
sqlserver2000:192.168.1.215
I installed the TG4MSQL in my windows XP,and the configuration showed below:
listener.ora
(SID_DESC =
(SID_NAME = sql2000)
(ORACLE_HOME = d:\oracle\product\10.2.0\db_1)
(PROGRAM = tg4msql)
)
tnsnames.ora
sql2k =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.44)(PORT=1521))
(CONNECT_DATA=(sid=sql2000))
(HS=OK)
)
initsql2000.ora
HS_FDS_CONNECT_INFO="SERVER=192.168.1.215;DATABASE=sql2000"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
There is no problem while reload listener,and tnsping is ok.And I do the below steps:
SQL>create database link sql2000 connect to "sa" identified by "123456" using 'sql2k';
database link created
SQL>select count(*) from dbo.sysobjects@sql2000;
when I run the count script,there is response,and it's always in the runing state.
But I got the below error message from alert_primary.ora:
HS: Unable to update ORACLE DD to upload Foreign Data Store info
HS: FDS class = 'MSSQL10.2.0.1.0_200', FDS instance = 'sql2000'
HS: Failure occurred on create_fds_class() or create_fds_inst()
Is there Anyone could give some suggestions about the running state and the alert message?
And how to solve?
Thanks,waiting online.
|
|
|
|
|
|
|
|
| Re: Urgence,Issue about transparent gateway to MSSQLServer [message #405215 is a reply to message #405149] |
Wed, 27 May 2009 01:04  |
wqq_chen
Messages: 2
Registered: May 2009
|
Junior Member |
|
|
| gentlebabu wrote on Tue, 26 May 2009 10:18 |
www dba-oracle com/t_heterogeneous_database_connections_sql_server.htm
Babu
|
Hello,gentlebabu
Thanks a lot for your article ,The issue has been solved.But I'm doubt about the part of ODBC installation.I'm not sure whether installing ODBC is nessesary,because I didn't do this step in my case,and this is not a problem.
Thanks again.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
