SSIS 无法连接到 AS400 上的 DB2 数据库 [COMException (0x80040E14)]

发布于 2024-11-17 22:16:33 字数 1615 浏览 2 评论 0原文

我已经使用 .NET OLEDB Provider 在 AS400 上设置了与 DB2 数据库的连接。当我测试连接时,我收到一条成功消息。但是当我尝试通过数据读取器使用连接时,出现以下错误。我用谷歌搜索了这个并没有找到任何有用的东西。以前有人见过这样的事情吗?

谢谢!

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

SSIS package "DownloadData.dtsx" starting.
Information: 0x4004300A at DownloadData From XXxXXX, DTS.Pipeline: Validation phase is beginning.
Error: 0xC0047062 at DownloadData From XXxXXX, AS400Conn [1]: System.Runtime.InteropServices.COMException (0x80040E14): Exception from HRESULT: 0x80040E14
   at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager90.AcquireConnection(Object pTransaction)
   at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction)
   at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper90 wrapper, Object transaction)
Error: 0xC0047017 at DownloadData From XXxXXX, DTS.Pipeline: component "Blah" (1) failed validation and returned error code 0x80040E14.
Error: 0xC004700C at DownloadData From XXxXXX, DTS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at DownloadData From XXxXXX: There were errors during task validation.
Warning: 0x80019002 at DownloadData: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.  The Execution method succeeded, but the number of errors raised (5) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "DownloadData.dtsx" finished: Failure.

I have setup a connection to a DB2 database on an AS400 using the .NET OLEDB Provider. When I test the connection, I get a successful message. but when I try to use the connection through a data reader, I get the below error. I've Googled this and come up with nothing helpful. Has anyone seen anything like this before?

Thanks!

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

SSIS package "DownloadData.dtsx" starting.
Information: 0x4004300A at DownloadData From XXxXXX, DTS.Pipeline: Validation phase is beginning.
Error: 0xC0047062 at DownloadData From XXxXXX, AS400Conn [1]: System.Runtime.InteropServices.COMException (0x80040E14): Exception from HRESULT: 0x80040E14
   at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager90.AcquireConnection(Object pTransaction)
   at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction)
   at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper90 wrapper, Object transaction)
Error: 0xC0047017 at DownloadData From XXxXXX, DTS.Pipeline: component "Blah" (1) failed validation and returned error code 0x80040E14.
Error: 0xC004700C at DownloadData From XXxXXX, DTS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at DownloadData From XXxXXX: There were errors during task validation.
Warning: 0x80019002 at DownloadData: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.  The Execution method succeeded, but the number of errors raised (5) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "DownloadData.dtsx" finished: Failure.

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

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

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。
列表为空,暂无数据
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文