BorlandTalk.com

Darío Alejandro Guzik · Guest

I have an old application that was working with paradox tables for a
while and everything was all right untill it wasn't... We are havein too
much trouble with corrupt indexes and locks now.

So We decided to migrate to a rdbms and chose MS SQLServer (I didn't
choose it... it was more a commercial desition rather than a
tecnologycal one.... I would have chosen IB or PostgresSQL, but anyways...)

I now that Borland abandoned BDE and I have to choose among the ways to
connecto to the database server.

Options are: 1) BDE + SQLLinks, 2) BDE + ODBC, 3) ADO, 4) dbExpress, 5)
third party access components

We first tried (2) but we have some troubles with ODBC.
(1) seems to work fine without much changes, but it's using BDE
(3) is also being replaced by MS, and I really don't like much Ms Stuff
(despite the fact I'm using SQL Server...) and would require massive
changes in the application replacing all the BDE objects with ADO.
(4) I began trying with dbExpress, but found out that there were a lot
of trouble regarding the fact that the cursos are unidirectional. I
would requiere more massive changes to make it work like it's working
now (a lot of editable grids)
(5) I'm not considering now because of the price.

Any suggestions?

--
Darío Alejandro Guzik (El Tío Borracho)
http://tioborracho.tripod.com
e-mail: [email]dguzik (AT) bigfoot (DOT) com[/email]
ICQ : 8389493

Viatcheslav V. Vassiliev · Guest

Native access to DBMS is always preferrable solution. Native for MS SQL
Server is OLEDB/ADO - this technology was develloped with MS SQL Server in
mind. ADO will be alive unless Windows will be .Net-based - MDAC 2.8 was
issued less than 1 month.

BDE is deprecated and it uses DBLib that is deprecated too.

dbExpress is new technology and Borland's MS SQL Server driver has some
troubles plus it is available only in VCL 7 (now only Delhpi 7, if I am not
wrong, Enterprise). It should become available in BCB 7. Now you will need
to use third-party driver. About unidirectional cursor - you can use
TClientDataSet that is not unidirectional.

Third-party components - if you need some special requirements for
speed/features, third-party components may provide theme.

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server, MS Jet (MS Access)
and Interbase (through OLEDB) databases.

"Darío Alejandro Guzik" <dguzik (AT) dc (DOT) uba.ar> ???????/???????? ? ????????
?????????: news:3f463fba (AT) newsgroups (DOT) borland.com...