Oracle连接SQL Server时提示NTS-03505 未能分解名称,为什么,急等解决! ( 积分: 200 )

不知道为什么老是不行,网上这方面的帖子很多找了但都没有用,和我的设置一样但不知道为什么就是不行,高手给看一下,我把的配置文件能帖出来<br>listener.ora文件里这样设置<br>&nbsp;&nbsp;&nbsp;&nbsp;(SID_DESC&nbsp;=&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(SID_NAME&nbsp;=&nbsp;HsSql)&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(ORACLE_HOME&nbsp;=&nbsp;d:/oracle/ora90)&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;(PROGRAM&nbsp;=&nbsp;HsSql)&nbsp&nbsp;&nbsp;<br><br><br>tnsnames.ora文件里这样设置<br>HSODBC&nbsp;=<br>&nbsp;&nbsp;(DESCRIPTION&nbsp;=<br>&nbsp;&nbsp;&nbsp;&nbsp;(ADDRESS_LIST&nbsp;=<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(ADDRESS&nbsp;=&nbsp;(PROTOCOL&nbsp;=&nbsp;TCP)(HOST&nbsp;=&nbsp;192.168.0.10)(PORT&nbsp;=&nbsp;1521))<br>&nbsp;&nbsp;&nbsp;&nbsp<br>&nbsp;&nbsp;&nbsp;&nbsp;(CONNECT_DATA&nbsp;=<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(SID_NAME&nbsp;=&nbsp;HsSql))<br>&nbsp;&nbsp;&nbsp;&nbsp;(HS=OK)<br>&nbsp;&nbsp<br>inittg4msql.ora文件里这样设置<br>HS_FDS_CONNECT_INFO=192.168.0.10.puds<br>HS_FDS_TRACE_LEVEL=OFF<br>HS_FDS_RECOVERY_ACCOUNT=RECOVER<br>HS_FDS_RECOVERY_PWD=RECOVER<br>sqlnet.ora里这样设置<br>SQLNET.AUTHENTICATION_SERVICES=&nbsp;(NTS)<br>NAMES.DIRECTORY_PATH=&nbsp;(TNSNAMES,&nbsp;ONAMES,&nbsp;HOSTNAME)<br>当TNSPING&nbsp;HSODBC时出现NTS-03505&nbsp;未能分解名称,这是为什么呀,是不是跟机子的设置有关呀

sql&nbsp;server&nbsp;Port&nbsp;默认1433

我用1433的端口也不行试过啦,都不行

1、确保透明网关安装正确<br>2、检查inittg4msql.ora确保<br>&nbsp;&nbsp;HS_FDS_CONNECT_INFO=&quot;Server=xxx;&nbsp;Database=xxx&quot;<br>3、检查tnsnames.ora里面&nbsp;确保那个HOST地址是透明网关的地址，SID和listener.ora里<br>的相同<br>HSODBC&nbsp;=<br>&nbsp;&nbsp;(DESCRIPTION&nbsp;=<br>&nbsp;&nbsp;&nbsp;&nbsp;(ADDRESS_LIST&nbsp;=<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(ADDRESS&nbsp;=&nbsp;(PROTOCOL&nbsp;=&nbsp;TCP)(HOST&nbsp;=&nbsp;192.168.0.10)(PORT&nbsp;=&nbsp;1521))<br>&nbsp;&nbsp;&nbsp;&nbsp<br>&nbsp;&nbsp;&nbsp;&nbsp;(CONNECT_DATA&nbsp;=<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(SID_NAME&nbsp;=&nbsp;HsSql))<br>&nbsp;&nbsp;&nbsp;&nbsp;(HS=OK)<br>&nbsp;&nbsp<br><br>4、确保改变配置后重新启动了数据库

这种方法我也度过啦,还是不行

透明网关装在哪台机子上了？IP多少？有没有防火墙？

我在把代码给贴出来<br>本机ORALCE&nbsp;IP&nbsp;192.168.0.10&nbsp;端口1521<br>别台机SQL&nbsp;SERVER&nbsp;IP&nbsp;192.168.0.3&nbsp;端口1521<br>listener.ora文件里这样设置<br>&nbsp;&nbsp;&nbsp;&nbsp;(SID_DESC&nbsp;=&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(SID_NAME&nbsp;=&nbsp;HsSql)&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(ORACLE_HOME&nbsp;=&nbsp;d:/oracle/ora90)&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;(PROGRAM&nbsp;=&nbsp;HsSql)&nbsp&nbsp;&nbsp;<br>tnsnames.ora文件里这样设置<br>HSODBC&nbsp;=<br>&nbsp;&nbsp;(DESCRIPTION&nbsp;=<br>&nbsp;&nbsp;&nbsp;&nbsp;(ADDRESS_LIST&nbsp;=<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(ADDRESS&nbsp;=&nbsp;(PROTOCOL&nbsp;=&nbsp;TCP)(HOST&nbsp;=&nbsp;192.168.0.10)(PORT&nbsp;=&nbsp;1521))<br>&nbsp;&nbsp;&nbsp;&nbsp<br>&nbsp;&nbsp;&nbsp;&nbsp;(CONNECT_DATA&nbsp;=<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(SID_NAME&nbsp;=&nbsp;HsSql))<br>&nbsp;&nbsp;&nbsp;&nbsp;(HS=OK)<br>&nbsp;&nbsp<br>initHsSql.ora文件里这样设置<br>HS_FDS_CONNECT_INFO=&quot;Server=192.168.0.3;&nbsp;Database=pubs&quot;<br>HS_FDS_TRACE_LEVEL=OFF<br>HS_FDS_RECOVERY_ACCOUNT=RECOVER<br>HS_FDS_RECOVERY_PWD=RECOVER<br>sqlnet.ora里这样设置<br>SQLNET.AUTHENTICATION_SERVICES=&nbsp;(NTS)<br>NAMES.DIRECTORY_PATH=&nbsp;(TNSNAMES,&nbsp;ONAMES,&nbsp;HOSTNAME)<br>防火墙也关啦,还是不能打开SQL&nbsp;SERVER数据库&nbsp;我用ODBC建连接就能打开SQL数据库,不知道为什么

&gt;别台机SQL&nbsp;SERVER&nbsp;IP&nbsp;192.168.0.3&nbsp;端口1521<br>除了SqlServer端口不是用的默认的，没什么不一样的<br>现在只能考虑是不是什么低级错误了，比如修改的tnsnames.ora不是用的那个，[]

多人接受答案了。