Re: Looking for database that is easy to install

From: Geoff (geoff_at_nospam.nexusdb.com)
Date: 04/20/04 

Date: Tue, 20 Apr 2004 14:58:06 +1000

"Shawn Oster" <monocularjack@change-haute-to-hot.hautemail.c0m> wrote in
message news:40847219$1@newsgroups.borland.com...

Hi Shawn.

> company LAN and doesn't need to be much more powerful than Access.
Probably
> 10-20 users.

NexusDB (www.nexusdb.com) will fit your needs here. Scalable from single
user (embedded DBMS) through to hundreds of users.

> I haven't yet looked at all the database alternatives but I do know that
it
> needs to be easy to install on the backend.

Copy the server exe (and ini) file onto the designated file server. Enter
the path to where you want your tables stored. Activate the TCP/IP protocol
and engine. Leave running. :)

> As evil as Access is I do like
> the single file database and only having to ensure ADO is installed on the
> client machine. Of course getting it installed just right is a headache
and
> one reason I'm shying away from Access.

Its on our wishlist to allow all tables to be stored in a single file
database. Version 2 is coming out in a few months - can't say for sure if
this feature will make it into that version though.

> I want my end-user to be able to run a simple install script on the
machine
> acting as a server or their own client machine and have it install the
basic
> database files.

Easily accomplished.

> I'd prefer a single file solution but I suppose I could
> live with the one table per file approach if it was pretty easy to get it
up
> and running.

One table per OS file is the current configuration. (However, you can
optionally store BLOB's and Indices in their files if you so desire.)

> I definitely don't want something along the level of MSSQL or
> MySql as far as setup and configuration.

<shudder> agreed... :)

> People should also be able to
> download a demo of my app and run it on their machine without having to
also
> setup a server and go through all that magic.

With NexusDB you can develop a demo that is self contained (that is, server
and app in the one exe file) and even supply it so that it runs (for
example) off a CD-ROM (that is, you can configure it to use a read-only
database). If you were to setup your app so that it created the data within
the exe, then your entire demo could be distributed as a single file.

> Have I beaten that horse to death yet? *grin*

Come over to our NG's (News.nexusDB.com) and feel free to flog it a bit
more... <g> The nexusdb.public.discussions NG would be the best to ask
questions.

In summary, I think you'll find all your specified needs, bar the single
file DB, are catered for with NexusDB.

See you over there!

Regards,
Geoff [NDS]

Relevant Pages

  • Re: ANN: NexusDB v2 Christmas Special - dont miss out!
    ... based applications to NexusDB within a matter of hours. ... The server is able ... that can easily be used to send client to client messages. ... currently opened in that database have changed since you last called ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Cannot connect to Olap server
    ... am getting the same error on a Test Server which is using 2000). ... > I am having problems connecting to Olap server from a XP client ... > The client machine is Windows XP Professional. ... > connect to the database. ...
    (microsoft.public.sqlserver.olap)
  • Re: MultiTier?
    ... Take a look at NexusDb Developer ... it gives you components that turn an app into a database server. ... The clients then connect to this for their database needs through your ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: configure database on other system
    ... I want to configure a database on another system because of capacity problems. ... Remote database access is pretty standard stuff in the Informix world. ... You have to install the CSDK or iClient on the client machine unless it has it's own server installed and running. ... You make an entry into the sqlhosts file on the client that points to the server, set up a TCP connection in the remote server and poof! ...
    (comp.databases.informix)
  • Re: Communication Link Failure Error
    ... Does the problem occur when you use the native OLE DB provider for SQL ... Server instead of the deprecated OLE DB provider for ODBC databases? ... unplug the network cable from the client machine and put the cable ... I disconnect from the database in my code ...
    (microsoft.public.data.ado)
Loading