BorlandTalk.com

Peter van Mierlo · Guest

Hi,

Our Delphi application uses now the BDE and Paradox. This apps is running
for almost 6 years
at 80 health-care customers. Some customers would like to use MS SQL, others
need about
1-2 years to migrate, i all depends on the money in health-care.

Now we would like to customise our apps, so it could work with BDE/Paradox
OR
with MS SQL. Let's say it simple....when we use a parameter /mssql the apps
has to
work with MS SQL. This means we have to change code or build things twice,
just
with a few changes...one for paradox the other for ms sql. Maybe we need to
build
2 datamodules, 1 for paradox and the other contains....db-express
components.

Has somenone done this before and at what point are the most
changes/differens between
paradox and ms-sql.

Greetings Peter

Bill Todd (TeamB) · Guest

Your goal is not possible without a large number of compromises that
may be unacceptable. First read
http://community.borland.com/article/0,1410,28688,00.html .

Next read http://community.borland.com/article/0,1410,28160,00.html .

As you can see, you need different data access components and a
different data architecture for SQL Server. The only way to access
Paradox tables is with the BDE. You do not want to use the BDE to
access SQL Server since the driver has been deprecated, it only fully
support SQL Server 6.5. Features added in later versions cannot be
supported because the BDE driver uses Microsoft's DBLIB client library
and Microsoft stopped updating DBLIB with SQL Server 6.5 to force
everyone to move to ADO.

The closest you could come to your objective is to write a DataSnap
application with two DataSnap servers. One for SQL server using ADO
and the other for Paradox using the BDE.

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)