Delphi 2010 的 Sybase 驱动程序
我们正在从Delphi 6迁移到Delphi 2010,之前我们使用BDE引擎从Delphi 6连接到Sybase数据库。我们发现Delphi 2010不支持BDE。
我们正在尝试使用 dbexpress,但无法捕获 Sybase 引发的异常(引发错误)。
请问除了 dbexpress 之外是否还有其他驱动程序可以从 Delphi 2010 连接到 Sybase 数据库。
谢谢。
问候, 作为
We are migrating from Delphi 6 to Delphi 2010,earlier we were using BDE engine to connect to Sybase Database from Delphi 6. We found out that Delphi 2010 does not support BDE.
We are trying with dbexpress but we are not able to catch the exception(raise error) thrown by Sybase.
Could you please let me know if there is any other driver except dbexpress to connect to Sybase Database from Delphi 2010.
Thanks.
Regards,
AS
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(5)
您可以使用 AnyDAC 连接到:
You can use AnyDAC to connect to:
我怀疑您真正的问题是您拥有专业版的 Delphi 而不是企业版。据我所知,BDE 仍然可以与 Delphi 2010 一起使用。Delphi
6 专业版允许连接到远程数据库。在 Delphi 6 和 Delphi 2010 之间,该策略发生了变化。
不管怎样,你真的需要放弃 BDE 并继续前进。
编辑:(jeroen)
用于关系访问的 BDE(又名
BDE SQL Links 技术
)自 2002 年起已被弃用,大约在在 Kylix 和 Delphi 6 中引入 dbExpress 两年后。I suspect your real problem is that you have the Professional version of Delphi rather than Enterprise. As far as I know, BDE can still be used with Delphi 2010.
With Delphi 6 the Professional version allowed connections to remote databases. Somewhere between Delphi 6 and Delphi 2010 that policy was changed.
Anyway, you really need to give up on BDE and move forward.
Edit: (jeroen)
The BDE for relational access (aka the
BDE SQL Links technology
) has been deprecated since 2002, about 2 years after the introduction of dbExpress in Kylix and Delphi 6.您可以尝试解决方法:
IIRC 不应删除可用的 SQL 链接(否则会破坏旧版本) ,并且它们应该仍然可以在 Delphi 2010 中工作。但这确实是权宜之计。
Devart的UniDac可以在不使用dbExpress的情况下连接到Sybase,但我从未使用过它。
You could try a workaround:
IIRC the available SQL Links should not be removed (otherwise it would break the older version), and they should still work in Delphi 2010. But that's really a stopgap try.
Devart's UniDac can connect to Sybase without using dbExpress, but I never used it.
dbExpress 的 Sybase 驱动程序包含在 Delphi 企业版中。如果这不是一个选项,您可以使用 Professional 中包含的 dbGO (ADO)。
Sybase drivers for dbExpress is included in Enterprise version of Delphi. If that is not an option you can use dbGO (ADO) that is included in Professional.
您可以尝试 ZEOSLIB,它包含 SyBase 连接以及许多其他 SQL 数据库。
据我所知,它要求您删除查询/表对象并将其替换为自己的表和查询替换对象,但是从 BDE 迁移到 ADO/dbGo 或 dBExpress 也是如此。
您确实应该从您的应用程序中删除 BDE。它像门钉一样死了。
You can try ZEOSLIB which contains SyBase connectivity, along with many other SQL dbs.
As far as I can see, it requires you to remove your Query/Table objects and replace them with its own Table and Query replacement objects, but then, so would moving from BDE to ADO/dbGo or dBExpress.
And you really should get the BDE out of your application. It's dead as a doornail.