Currently we have Delphi 2.0 application running with Oracle 7.3.3 client and connecting to Oracle 7.3.4 in Sun Solaris Server.

We are planning to migrate the Oracle server to Oracle 9i and keep the client as oracle 7.3.3. We are using Delphi BDE connection.

My query is

1. Will BDE work with Oracle 9i server and Oracle 7.3.3 client?
2. If it works will I have any feature disadvantage of keeping the client in lower version ?
3. Will BDE work with Oracle 9i server and Oracle 9i client?

thanks

Your wrote:
Delphi BDE on Oracle 9i
Currently we have Delphi 2.0 application running with Oracle 7.3.3 client and connecting to Oracle 7.3.4 in Sun Solaris Server.

We are planning to migrate the Oracle server to Oracle 9i and keep the client as oracle 7.3.3. We are using Delphi BDE connection.

My query is

1. Will BDE work with Oracle 9i server and Oracle 7.3.3 client?
2. If it works will I have any feature disadvantage of keeping the client in lower version ?
3. Will BDE work with Oracle 9i server and Oracle 9i client?

thanks
__________________________________________________ ________

1. Technically, yes, the BDE will probably work with the
Oracle 9i server and Oracle 7.3.3 client . . . however,
why would you want it to? My understanding is that Oracle rather
strongly suggests having both the server and client at the same
release level . . . it simplifies figuring out what is screwing up.

2. You will absolutely feature disadvantages from keeping the client
in lower version. In the first place, there have been _MAJOR_
improvements in Delphi since D2 (Hey, we're on _D7_, for heaven's
sake). In the second place, the BDE has also been improved. In the
third place, there is a better answer than the BDE anyway _IF_ you
move to something like D5, D6, or D7.

3. Technically, yes, the BDE will probably work with the
Oracle 9i server and Oracle 9i client . . . however, again,
why would you want it to? See the answer to 2. above.

Essentially, the newer versions of Delphi offer the use of both ADO and DAO (Direct Oracle Access) components to improve (and I mean VASTLY improve) your access to Oracle.