Delphi 7 DbExpress and Oracle 10G

[Karen]

I am starting with a new project. I always used the bde. But are thinking of using DbExpress. How stable is DbExpress in D7 with Oracle10G? And which drivers do you suggest to use? Also I read dbExpress in unidirectional? How do I work around that?

Cheers
Karen

[delfo]

Post by Karen
I am starting with a new project. I always used the bde. But are thinking of using DbExpress. How stable is DbExpress in D7 with Oracle10G? And which drivers do you suggest to use? Also I read dbExpress in unidirectional? How do I work around that?

Based in my experience, I would advice you not even try it, unless you
have lot of free time that you want to loose. I would use BDE or wait to
D2008 to see if they have solved the worst bugs or use a different
driver, not Codegear's.

To solve the problem of unidirectional datasets you have to insert
DataSetProviders and ClientDataSets between the querys and the dbgrids.
You can do that also with BDE. In my case I began doing those changes in
BDE to make the transition smoother. If you search in Codegear's webpage
I think you can find articles that explain how to do it.

[Bill Todd [TeamB]]

If you search in Codegear's webpage I think you can find articles
that explain how to do it.

The Delphi 7 Developer's Guide also contains a good explanation.

[Armando Luiz Dettmer]

Post by Karen
I am starting with a new project. I always used the bde. But are thinking of using DbExpress. How stable is DbExpress in D7 with Oracle10G? And which drivers do you suggest to use? Also I read dbExpress in unidirectional? How do I work around that?
Cheers
Karen

Hi Karen.

I must desagree from Delfo´s opinions. I´m using dbExpress sine
september 2002 and, after the initial learning process, I left
BDE forever. Of course DbExpress isn´t perfect but it´s faster
than BDE and easier to deploy. I never tested the D7 driver against
oracle 10 but I think that it should work perfectly, I used the 2006
driver version for 2 years without problems.

Regards.