Sybase ASE ADO.net 2.0 提供商？
我正在寻找一个 ADO.net 2.0 或更高版本的 Sybase 数据库提供程序，该数据库似乎被称为 Sybase ASE。 澄清一下，我对 ASE 感兴趣，而不是 SQL Anywhere。 希望该提供程序将包含在数据库中，或者免费。
我可以找到 ADO.net 1.1 提供程序的提及； 那不是我想要的。
我可以找到有关 ODBC 驱动程序和 OLEDB 提供程序的提及； 那不是我想要的。
我找到了付费的 DataDirect ADO.net 提供商； 我想这就是后备位置。
感谢您的帮助
I'm looking for an ADO.net 2.0 or later provider for Sybase database which seems to be known as Sybase ASE. To clarify, I'm interested in ASE, and not SQL Anywhere. Hopefully the provider will be included with the database, or free.
I can find mention of an ADO.net 1.1 provider; that's not what I want.
I can find mention of ODBC drivers and OLEDB providers; that's not what I want.
I've found the DataDirect ADO.net providers which are paid for; I guess that's the fallback position.
Thanks for your help
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（5）
我自己最近也走过这条路，我只能建议你通过网络搜索找不到答案。 如果您要连接到 ASE 服务器，那么您就有客户技术联系人。 使用该人员，要求他们下载前面提到的 Sybase 15 #ESD10。
根据我的经验（我坦白承认，这是一次糟糕的经历）；
Sybase 仅向付费客户提供此类开发人员资源。
下载后，将包含一大堆您不需要的额外内容。 我仍然认为 PowerDesigner 是一个很棒的实用程序，但我认为其中包含的是试用版，长期价值有限。 我相信您想要的就是安装 OpenClient，选择 ADO.NET 功能。
我发现了整个体验，从获取开发人员资源（仅确定正确的下载就很困难），到从数百个已安装文件中分离出必需的两个文件，再到安装破坏了我现有的 RapidSql 和 DbArtisan 安装，最后，当前版本仅支持 ADO.NET 2 提供程序（例如，您不会获得 EF 连接），这确实令人沮丧。
毫不奇怪，我也无法使用 nHibernate 或 subsonic 找到对 ASE 的太多支持。
Having recently been down this road myself, I can only suggest that you wont find the answer through searching the net. If you are connecting to an ASE server, then you have a customer technical contact. Use that person, asking them to download the earlier mentioned Sybase 15 #ESD10.
From my experience (which I freely admit, was a bad one);
Sybase makes this sort of developer resource available to paying customers only.
The download, once you have it, will include a whole bunch of extras that you wont need. I still think that PowerDesigner is a great utility, but I think that what is included is a trial version, of limited long term value. I believe that what you want from the set is the OpenClient install, selecting the ADO.NET features.
I found the whole experience, from acquiring the developer resources (just identifying the right download was a struggle), to isolating out the two files necessary from the hundreds of installed files, to the fact that the install broke my existing RapidSql and DbArtisan installs, and finally that the current version goes no further than ADO.NET 2 provider support (you wont get EF wiring for example), to be truly frustrating.
No surprise then that I have not been able to find much support for ASE using nHibernate or subsonic either.
这个问题相当老了，但获得 ADO 连接器似乎变得更容易了。
http://scn.sap.com/community/developer-center/oltp-db
然后，您应该能够按照此处的说明在 .NET 中执行查询、更新等：
http://infocenter .sybase.com/help/index.jsp?topic=/com.sybase.help.sdk_12.5.1.adonet/html/adonet/DAFJEFIF.htm
This question is fairly old but it seems to have gotten easier to get the ADO Connector.
http://scn.sap.com/community/developer-center/oltp-db
You should then be able perform queries, updates etc. in .NET by following the directions from here:
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.sdk_12.5.1.adonet/html/adonet/DAFJEFIF.htm
作为 SAP/Sybase 驱动程序的替代方案，我们为 ASE 开发了自己的 ADO.NET Core 驱动程序：
https: //github.com/DataAction/AdoNetCore.AseClient
.NET Core 对我们来说是一项关键技术 - 特别是对于 AWS Lambda - 而且 SAP/Sybase 仍然没有提供 ADO.NET Core 驱动程序。
我们的驱动程序支持大多数 SAP/Sybase ADO.NET 功能，旨在成为 SAP/Sybase 驱动程序的替代品以方便过渡，并支持您关心的所有 .NET 框架。
您可以在 Nuget 上获取它：
https://www.nuget.org/packages/AdoNetCore.AseClient
As an alternative to the SAP/Sybase driver, we developed our own ADO.NET Core driver for ASE:
https://github.com/DataAction/AdoNetCore.AseClient
.NET Core was a key technology for us - in particular for AWS Lambda - and there is still no ADO.NET Core driver available from SAP/Sybase.
Our driver supports most of the SAP/Sybase ADO.NET features, aims to be a drop in replacement to the SAP/Sybase one for easy transition, and supports all of the .NET Frameworks you would care about.
You can get it on Nuget:
https://www.nuget.org/packages/AdoNetCore.AseClient
根据 Sybase 的以下链接，Sybase 15 #ESD10 支持 ADO.NET 2.0：
http ://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc20155.1500/html/newfesd/CBHJAABF.htm
新功能 Open Server 15.0 和 SDK 15.0 for Microsoft Windows 、Linux、UNIX 和 Mac OS X
ADO.NET 2.0 支持
ASE ADO.NET Data Provider 2.0 随此 SDK 版本一起提供。 此版本中支持的 ADO.NET 2.0 功能有：
有关支持的 ADO.NET 2.0 功能的详细信息，请参阅 ADO.NET 2.0 中的新增功能。
Sybase 15 #ESD10 has support for ADO.NET 2.0, according to this link at Sybase:
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc20155.1500/html/newfesd/CBHJAABF.htm
New Features Open Server 15.0 and SDK 15.0 for Microsoft Windows, Linux, UNIX, and Mac OS X
ADO.NET 2.0 support
ASE ADO.NET Data Provider 2.0 is shipped with this SDK release. The ADO.NET 2.0 features supported in this version are:
For more information on the supported ADO.NET 2.0 features, see What’s New in ADO.NET 2.0.
来自 sybase 网站：
Sybase 对 ADO.NET、OLE DB 和 ODBC 的支持
Adaptive Server 15.0 版包含 Sybase 开发的新 ODBC 和 OLE DB 驱动程序。 以前版本中包含的第三方重新命名的 ODBC 和 OLE DB 驱动程序套件不再提供。
已停用的 ODBC 驱动程序工具包安装在 %SYBASE%\ODBC 中，并在 ODBC 驱动程序管理器中注册为“Sybase ASE ODBC 驱动程序”。 Sybase 的新 ASE ODBC 驱动程序安装在 %SYBASE%\DataAccess\ODBC 中，并注册为“Adaptive Server Enterprise”。 Adaptive Server 和 SDK 15.0 附带的版本是 15.0.0.50。
已停用的 OLE DB 驱动程序工具包安装在 %SYBASE%\OLEDB 中，并使用提供程序短名称“Sybase.ASEOLEDBProvider”和长名称“Sybase ASE OLE DB Provider”。 Sybase 的新 ASE OLE DB 提供程序安装在 %SYBASE%\DataAccess\OLEDB 中，并使用提供程序短名称“ASEOLEDB”。 SDK 15.0 附带的版本是版本 15.0.0.51。
Sybase 建议您尽快开始新的 ODBC 和 OLE DB 驱动程序的迁移过程。 Adaptive Server 15.0 中引入的新功能仅受新驱动程序支持。
有关迁移到新驱动程序的说明，请参阅“适用于 Windows、Linux 和 UNIX 的 OpenServer 15.0 和 SDK 15.0 的新功能”。
From the sybase website:
Sybase support for ADO.NET, OLE DB, and ODBC
Adaptive Server version 15.0 contains new ODBC and OLE DB drivers developed by Sybase. The third-party rebranded ODBC and OLE DB Driver Kits included with previous versions are no longer shipped.
The retired ODBC Driver Kit was installed in %SYBASE%\ODBC, and registered with the ODBC Driver Manager as “Sybase ASE ODBC Driver”. The new ASE ODBC Driver by Sybase is installed in %SYBASE%\DataAccess\ODBC, and registered as “Adaptive Server Enterprise”. The version shipping with Adaptive Server and SDK 15.0 is version 15.0.0.50.
The retired OLE DB Driver Kit was installed in %SYBASE%\OLEDB, and used the provider short name of “Sybase.ASEOLEDBProvider” and the long name of “Sybase ASE OLE DB Provider”. The new ASE OLE DB Provider by Sybase is installed in %SYBASE%\DataAccess\OLEDB, and uses provider short name “ASEOLEDB”. The version shipping with SDK 15.0 is version 15.0.0.51.
Sybase recommends that you start your migration process the new ODBC and OLE DB drivers as soon as possible. New features introduced in Adaptive Server 15.0 are supported only by the new drivers.
See “New Features for OpenServer 15.0 and SDK 15.0 for Windows, Linux and UNIX”, for instructions on migrating to the new drivers.