问题描述
我正在尝试从SQL Server Reporting Services访问第三方Oracle数据库.我已经将它用于SQL Server和Oracle ODAC的早期版本，但是已经有好几年了.我现在被迫进行升级，当我尝试在SSRS中创建数据源时，出现以下错误:
I'm trying to access a third party Oracle database from SQL Server Reporting Services. I had it working on previous versions of SQL Server and Oracle ODAC, but it's been several years. I'm now being forced into an upgrade, and when I try to create the data source in SSRS, I get the following error:
- 网络传输:解析钱包位置时SSL失败
我创建了ODBC连接，并且能够成功测试该连接，因此我知道tnsnames.ora和sqlnet.ora中的所有设置都是正确的.我知道SSRS正在查看正确的文件，因为通过将连接标识符更改为组成的内容，我可能会遇到其他错误.钱包位于tnsnames文件的子目录中.我尝试将钱包位置放置在两个文件中，但是似乎没有任何组合.
I created an ODBC connection and am able to successfully test the connection, so I know all of the settings in tnsnames.ora and sqlnet.ora are correct. I know SSRS is looking at the correct files because I can get a different error by changing the connect identifier to something made up. The wallet is in a sub-directory of the tnsnames file. I have tried placing the wallet location in both files, but no combination seems to work.
tnsnames.ora
tnsnames.ora
<Connect Identifier> =
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCPS)(HOST = <host>)(PORT = <port>)))
(CONNECT_DATA = (SID = <SID>)(SERVER = DEDICATED))
(SECURITY = (MY_WALLET_DIRECTORY = D:\Oracle\wallet))
)
sqlnet.ora
sqlnet.ora
WALLET_LOCATION= (SOURCE=
(METHOD=file)
(METHOD_DATA=(DIRECTORY=D:\Oracle\wallet)))
当前配置
- Windows Server 2016
- Microsoft SQL Server 2016
- 64位ODAC 12.2c
推荐答案
解决此问题的方法是，每次更改SQLORA.NET文件时，都必须重新启动SRSS Windows Service.
The take away to solving this problem is each time you change the SQLORA.NET file you have to restart the SRSS Windows Service.
这篇关于尝试从SSRS访问Oracle DB的SSL/钱包错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！