DELPHI 5中从BDE到ADO的转换 [英] BDE to ADO conversion in DELPHI 5

问题描述

我在公司中有一个申请。我想将其从BDE转换为ADO Connection。
我几乎在所有地方搜索过，但找不到任何好的答案。
AIM是
将该BDE连接转换为ADO连接，但是我们需要使用TQuery组件从数据库中获取数据。
因此，看起来我们在使用BDE，但在内部使用ADO Connection。
所以，请回答您无法想象的问题，我将多么感激。

I have an application in my company. I want to convert it from BDE to ADO Connection. I searched almost everywhere, I did not find any good answer. The AIM IS Convert that BDE connection to ADO connection but we need to use TQuery component to fetch data from database. So, it will look like we are using BDE but internally it uses ADO Connection. So, please answer this question you cant imagine, how thankful i will be.

推荐答案

...如果可以通过某种方式将数据库别名设置为ADO连接...

... if somehow we can set the database Alias to ADO connection ...

只看一下源代码的Delphi对BDE和ADO的支持（例如DBTables.Pas和ADOInt.Pas + ADODB.Pas），您很快就会发现它们与粉笔和奶酪一样。

Just take a look at the source code of Delphi's BDE and ADO support (in e.g. DBTables.Pas and ADOInt.Pas + ADODB.Pas and you will soon see that they are as different as chalk and cheese.

可能要做的就是将数据移动到ADO数据库（例如MS Sql Server），然后创建a）通过ODBC连接到ADO db的系统DSN，然后b）设置使用BDE别名的BDE别名，以及c）更改现有的BDE应用程序以使用新的别名，而不是当前使用的别名。这样，您可以继续使用现有的应用程序通过TTable，TQuery等访问ADO版本的数据，并在闲暇时开发基于并行TAdo组件的等效项。

What you could do is do move your data to an ADO database (e.g. MS Sql Server) and then create a) a System DSN to connect to the ADO db via ODBC and then b) set up a BDE Alias that uses the BDE alias and c) change your existing BDE app to use the new alias instead of the one it currently uses. That way, you can continue using your existing app to access the ADO version of the data via TTable, TQuery etc and develop a parallel TAdo-component based equivalent at your leisure.

您可以使用传统的Delphi MastApp或 Fish Facts演示应用程序和数据轻松地进行尝试。使您现有的BDE应用程序通过ODBC别名访问与ADO兼容的数据副本，即使您以前从未做过，也不会超过一天的工作。但是，实际上将BDE应用程序转换为ADO可能会花费更长的时间。

You could easily try this out using the traditional Delphi MastApp or "Fish Facts" demo application and data. Getting your existing BDE app to access an ADO-compatible copy of your data via an ODBC alias should not be more than a day's work even if you have never done it before. Actually converting your BDE app to ADO would likely take rather longer, though.

有无数种将BDE（例如Paradox）数据复制到ADO数据的不同方式的示例。互联网。尝试看看一些。

There are countless examples of different ways of copying BDE (e.g. Paradox) data to ADO data on the internet. Try looking at a few.

这篇关于DELPHI 5中从BDE到ADO的转换的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！