VS2019 Oracle连接在SSIS中不起作用

发布于 2025-02-05 18:10:48 字数 1119 浏览 1 评论 0原文

我已经安装了Visual Studio 2019的专业版本,并且无法使用Microsoft Connector连接到Oracle DB源。我遇到以下错误。有人可以帮忙吗?

TITLE: Microsoft Visual Studio
------------------------------

There was an error trying to establish an Oracle connection with the database server.

------------------------------

以下是所有版本信息

sql Server版本信息

SQL Server Management Studio 15.0.18410.0
SQL Server Management Objects (SMO) 16.100.47008.0
Microsoft Analysis Services Client Tools 15.0.19750.0
Microsoft Data Access Components (MDAC) 10.0.17763.1
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.17763
Oracle Client version installed 12

Visual Studio版本INFO

Microsoft Visual Studio Professional 2019 (2)
Version 16.11.15


Microsoft SQL Server Integration Services Designer
Version 15.0.2000.123

已安装连接器

Attunity connector v5 installed but not visible in the SSIS toolbox

Microsoft Connector for Oracle v1 Installed and visible

I have installed the Professional version of Visual Studio 2019 and I am unable to connect to Oracle DB Source using the Microsoft connector. I am getting the below error. Can someone please help with this?

TITLE: Microsoft Visual Studio
------------------------------

There was an error trying to establish an Oracle connection with the database server.

------------------------------

Below is all the version information

SQL Server Version Info

SQL Server Management Studio 15.0.18410.0
SQL Server Management Objects (SMO) 16.100.47008.0
Microsoft Analysis Services Client Tools 15.0.19750.0
Microsoft Data Access Components (MDAC) 10.0.17763.1
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.17763
Oracle Client version installed 12

Visual Studio Version Info

Microsoft Visual Studio Professional 2019 (2)
Version 16.11.15


Microsoft SQL Server Integration Services Designer
Version 15.0.2000.123

Connectors installed

Attunity connector v5 installed but not visible in the SSIS toolbox

Microsoft Connector for Oracle v1 Installed and visible

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

扫码二维码加入Web技术交流群

发布评论

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

评论(1

浅笑依然 2025-02-12 18:10:48

该解决方案根本不起作用。

The solution did not work at all.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文