MS Access 的 ODBC Oracle 连接错误

发布于 2024-09-26 15:33:50 字数 323 浏览 6 评论 0原文

我当前支持使用 Microsoft ODBC Driver for Oracle 进行链接连接的 MS Access 数据库。我可以毫无问题地连接到当前的链接表，但出于安全原因，我们需要更改访问服务器的帐户的密码。

我已成功更改密码，但现在当我尝试重新链接表时出现错误：

ODBC--call failed
Microsoft ODBC driver for ORacle ORA-12154: TNS could not resolve service name

这些表是关键应用程序的一部分，现在我们无法连接。关于如何解决这个问题有什么建议吗？

原文

I currently support an MS Access database that has linked connections using the Microsoft ODBC Driver for Oracle. I can connect to the current linked tables without any issues, but we are required for security reasons to change the password on the account accessing the Server.

I have changed the password successfully but now when I attempt to relink the tables I get the error:

ODBC--call failed
Microsoft ODBC driver for ORacle ORA-12154: TNS could not resolve service name

These tables are part of a critical application and now we can't connect. Any suggestions on how to resolve this?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

孤凫 2024-10-03 15:33:50

ORA-12154 错误表明您指定的 TNS 别名无法解析。您是否使用 DSN 来连接到 Oracle？如果是这样，您在那里指定的 TNS 别名是什么？您的 tnsnames.ora 文件中是否存在该别名？客户端上是否有多个tnsnames.ora文件？

tnsnames.ora 文件位于安装 Access 的客户端计算机上。在不知道安装了哪个版本的 Oracle 客户端的情况下，找出正在使用哪个 tnsnames.ora 文件的最简单方法可能是打开 DOS 提示符并输入“tnsping service_name”，其中 `service_name”是您的 DSN 中指定的任何 TNS 别名。您将得到类似的信息。

C:\Users\jcave>tnsping fuddy_duddy

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 07-OCT-2
010 08:10:51

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

Used parameter files:
C:\oracle\product\11.1.0\db_1\NETWORK\ADMIN\sqlnet.ora

TNS-03505: Failed to resolve name

“使用的参数文件”行告诉您存储 TNS 相关文件的目录，其中应该有一个 tnsnames.ora 和一个 sqlnet.ora 文件。目录。

The ORA-12154 error indicates that you are specifying a TNS alias that is not resolving. Are you using a DSN for your connection to Oracle? If so, what is the TNS alias you're specifying there? Does that alias exist in your tnsnames.ora file? Are there multiple tnsnames.ora files on the client?

The tnsnames.ora file is on the client machine where Access is installed. Without knowing what version of the Oracle client is installed, the simplest way to find out which tnsnames.ora file is being used is probably to open up a DOS prompt and type "tnsping service_name" where `service_name" is whatever TNS alias is specified in your DSN. You'll get something like

C:\Users\jcave>tnsping fuddy_duddy

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 07-OCT-2
010 08:10:51

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

Used parameter files:
C:\oracle\product\11.1.0\db_1\NETWORK\ADMIN\sqlnet.ora

TNS-03505: Failed to resolve name

The "Used parameter files" line tells you the directory where the TNS related files are stored. There should be a tnsnames.ora and a sqlnet.ora file in that directory.

回复收藏 0 原文

~没有更多了~