Re: Client-Server ODBC-Programming - Best Choices

ayermako_at_carbon.cudenver.edu (Alexander I Yermakov) wrote:

>Could someone help me with a problem that has recently challenged me
>in my research ? I have to design a client-server system to support a
>big database on computational linguistics at our university computer
>lab (using ODBC drivers) and I am somewhat at sea as to a) which DBMS
>to use, and b) which programming system to choose to program the
>access and user interface.
 

>The choices suggested by our system manager are: for databases -
>FoxPro for Windows, Paradox for Windows, MS Access, Clipper for
>Windows, Borland Delphi'95, PowerBuilder, JAM for Windows, Oracle
>(Oracle Cooperative Development Environment), Informix-NewEra; for
>programming - MS Visual C++, MS Visual Basic, Borland C++ with
>Database Engine.
 

>Alex

Hello Alex,

Since you're using Visual C++, I suppose you're looking for something running on PC. I can't provide you with an info on all products you listed, but I have some experience with Watcom, Oracle, Access.

1. Access. The Access 2.0 ODBC driver is based on OLE, therefore if you need a decent performance, you'll have to supply you users' PCs with enough memory (>= 16MB). I don't think Access has satisfactory performance.
2. Watcom SQL 4.0. This is my favourite. Very fast. Easy to learn and use.
3. Oracle 7.0. Too heavy for PC. I could not make it run as fast as Watcom, but maybe we have to wait for better drivers.

Hope it helps. Received on Tue Jun 27 1995 - 00:00:00 CEST