Desperately seeking database
: >
: >
: >Before very long I'm going to have to take the plunge and actually
: >buy a server RDBMS. I've looked at InterBase, Oracle and Gupta
: >SQL Base. I looked at those as I happen to have demo versions to
: >hand. The more I look, the harder the decision becomes.
: >
: >The application I will be building will be used by a small workgroup,
: >perhaps between two and five users. More than ten is highly unlikely.
: >The database will be fairly small -- I doubt it will ever exceed
: >100Mb and 50Mb will be typical.
: >
: >The server will be running on Novell Netware.
: >
: >1) Work with Delphi (naturally!) and preferably Borland SQL links.
: >
: >2) Small workgroup, up to ten concurrent users.
: >
: >3) Novell Netware (I don't have a choice about this, several
: >potential customers already have Netware).
: >
: >4) A 'proper' SQL Server, not an overgrown desktop database.
: >
: >5) Reasonable retail price with a two-user version available. I
: >think UKP 250 per user is reasonable.
: >
: >6) My client software will be running on Windows 3.1 and Windows
: >95. Windows 95 seems to be a problem for Oracle...
: >
: >7) The end users will typically have very little computing
: >experience. They need to be able to run day-to-day jobs like
: >starting the server and backing up the database without needing a
: >BSc and four weeks training.
: >
: >Initially, I'll need a two user version for development. The cost
: >of this is coming out of my pocket (Plexus is a one man company),
: >so I want to be as sure as I can that I'm buying the right one.
: >
: >----------------------------------------------------------------------
: >Plexus Systems Ltd. Reading, Berkshire, UK
: >
: Don't knock your self out. Use standard Delphi desktop with Paradox
: tables. The could be set as networked without much fanfare and will
: support efficiently 20 - 25 users. If Novell is not so dear to your
: you might consider Windows NT Server 3.51. The advantage is that if
: you use the NTFS file system you can have commit and rollback - the
: main feature of SQL Server - from NT. It is also easier to set up,
: maintain and what you mentioned backups Although you can backup Novell
: files just as easy from a workstation you can do the same with NT from
: either the server or the workstation. It is also much simpler with NT
: to back up the server by setting up a timed i.e. when no one is present
: without requiring a workstation to stay open. Hope this answers your
: question. If you have anything further please EMail me.
: Ben
: Arrow Software
: Brooklyn, NY
Can you give me any details on how to achieve a commit or rollback in Paradox
running in an NT environment? I think that I read lately that commits and
rollbacks in NTFS differ in results from commits and rollbacks as provided by
database servers. As I have no experience with NT but am planning to get it,
any comment is appreciated.
Best regards,
Andy