重新安装SYBASE oledb提供程序后，它不会出现在SSIS连接管理器中 [英] After reinstall SYBASE oledb provider it does not appear in SSIS connection manager

问题描述

我已经重新安装了Sybase Adaptive Server Enterprise PC客户端12.5.4. 之后，它会从SSIS连接管理器中完全消失.

I have reinstalled Sybase Adaptive Server Enterprise PC Client 12.5.4. After that it's completely disappeared from SSIS connection manager.

我该如何解决?

推荐答案

使用ADO.Net而不是OLEDB

当您需要连接到Sybase时，必须添加一个ADO.Net连接而不是OLEDB:

Use ADO.Net not OLEDB

When you need to connect to Sybase you have to add an ADO.Net connection not OLEDB:

在以下

可以将Adaptive Server ADO.NET数据提供程序集成到SQL Server集成服务(SSIS)中，从而允许对ADO.NET数据提供程序功能的本机访问. 通过集成，您可以将Adaptive Server用作:

Adaptive Server ADO.NET Data Provider can be integrated into SQL Server Integration Services (SSIS), allowing for native access to ADO.NET Data Provider functions.
With the integration, you can use Adaptive Server as an:

• ADO.NET连接管理器
• ADO.NET源数据流组件
• ADO.NET目标数据流组件

• ADO.NET Connection Manager
• ADO.NET Source data flow component
• ADO.NET Destination data flow component

也在官方下载页面中，他们没有提到OLEDB提供程序，但他们提到了ADO.NET

Also in the official download page, they didn't mentioned OLEDB provider but they mentioned ADO.NET

此外，您可以查看网上找到的许多文章，它们描述了从Sybase导入数据的整个过程，它们都提到您必须使用ADO.Net而不是OLEDB:

In addition, you can check many articles found on the web describing the whole process to import data from Sybase, they all mentioned that you must use ADO.Net not OLEDB:

• 查看全文