> > ok, got that. So conceptually, there are mutiple tables with one file
per
> > table, and the database is defined by the folder the files are put in
(like
> > in NexusDB)?
>
> Correct, but the files are:
> table.DAT, table.IDX, table.BLB  Data/Index/Blob

great! But that's lots of files . . . I thought it was a streytch in nexus
with just one file per table! Anyway, I'm sure there's a reason . . .

> >>  > On the other hand, servadmin lets me work with servers (databases?),
> > but
> >> > apparently not create or edit databases or tables.
> >>
> >> In Server Admin, you define the database aliases, etc ... and the users
> > for the database,
> >> but tables are handled in dbsys. You would connect to the server using
> > dbsys and
> >> once your are connected, the tables will be created based on your
> > connection
> >> info.
> >
> > I don't quite follow this. When I try to connect in servadmin it seems
to
> > not let me log in (error# 11280 - cannot connect to database server
> > 127.0.0.1).
>
> Silly question, do you have the actual server running? dbsrvr.exe?

Ah, that was it. In nexus, the server and the server administration are tied
together into the one app, so I was thinking the servadmin might also be the
server and hadn't found the actual server yet.

Another couple of newbie questions - what are the default username and
passwords for the server, and where do I configure these? Also, where do I
configure the users?

Thx

Lauchlan M

> > In nexus, either you run the server for a C/S app, or you include a
> > component that embeds the server for an embedded app.
>
> same with Dbisam.

ok, great!

> > Here, I assume similar applies: In either case (embedded or C/S)
> > you'd need a server running?
>
> nope. for embedded, if you are connecting locally you do not need to
> run a Dbisam Server. Then Engine is embedded. If you want to access
> somne of hte Engine properties yourself (not requried) you can drop a
> DbisamEngine compoonent on your form and set as local rather then
> remote type.

Well, that's sort of what I meant. there is a server, but it's embedded,
right, with the component? You don't need to run a seperate one external to
the app?

Anyway, I follow what you are saying . . .

> > The ServAdmin seems to have options for connecting to a remote server
> > such as IP, port, service, host name etc, which tends to suggest it
> > is mainly for connecting to remote servers and is probably intended
> > to work in a similar way to the nexus server . . . but I don't see
> > any way to configure users, security, etc in it . . .
>
> Once you log in click on the DATABASE USERS tab.  You then setup
> Aliases to your database(s) and then add users that you have already
> defined to that database.

I don't see that tab.

Perhaps I don't see that yet because I haven't managed to log in - what are
the default username and password?

Thx

Lauchlan M

> > In nexus, either you run the server for a C/S app, or you include a
> > component that embeds the server for an embedded app.
>
> > Here, I assume similar applies: In either case (embedded or C/S) you'd
need
> > a server running?
>
> You only need a server running if you are using a C/S approach.
> If you are using a local, then you simply open the table using
TDBISAMTable or TDBISAMQuery.

ok. What components do I drop for C/S and embedded apps?



> > The ServAdmin seems to have options for connecting to a remote server
such
> > as IP, port, service, host name etc, which tends to suggest it is mainly
for
> > connecting to remote servers and is probably intended to work in a
similar
> > way to the nexus server . . . but I don't see any way to configure
users,
> > security, etc in it . . .
>
> The ServerAdmin will have tabs to Add/Update Database, Users, Database
Users.. etc
> once you are connected to the Server. Until then, you have a very menu of
Option/Connect.

ok, I thoiught it might be something like that. Now I need to log on!

> I think the confusion may be that NexusDB allows you to do this all on the
server.
> DBISAM allows this through ServerAdmin after you are connect.

Yep, that's the way it works in Nexus.

> > What constitutes starting the server? Does running ServAdmin do this, or
is
> > the server run automatically as a service (once it's installed), or does
it
> > happen programatically via the components? Does the dbsys have an
embedded
> > server, or does it need/use servadmin?
>
> Running the server is dbsrvr.exe, ServerAdmin is simply a utility to
connect to the DBISAM server.
> dbsrvr /install for a service.

ok, great - I follow this now. With Nexus the server UI and the server are
integrated.

> dbsrvr.exe ; DBISAM server
> ServerAdmin; Admin util for DBISAM server
> dbsys; DB manager

Thanks

Lauchlan M

> ok. What components do I drop for C/S and embedded apps?

Sorry, I meant to finish my thoughts there . . .

I assume it's a database, session and (for embedded apps) and engine, with
table and query hooked to the database?

Nexus also has a Winsock transport component for the C/S case, but I expect
int he DBISAM case this is just internalised to use tcp/ip here without
dropping that component specifically? In any case, I don't see a component
for that . . .

And to connect, are the main properties the database.databasename and
database.directory?

I assume database name plays a role like 'alias'in NexusDB:

<<
Use to the DatabaseName property to specify the name of the database to
associate with this TDBISAMDatabase component.  The database name is
arbitrary and is used only for identification of the database when
connecting TDBISAMTable and TDBISAMQuery components.  It is best to think of
the DatabaseName as an alias to the physical location of the database
tables, which is represented by the Directory property for local sessions
and the RemoteDatabase property for remote sessions.  The DatabaseName
property must begin with an alpha character.
>>

Is this databasename defined in the server administrator utility (when
logged in and one can see the additional tabs)?

Do you only have to provide one or the other of databasename and directory,
and it's usually the former for C/S and the latter for embedded?

Thx,

Lauchlan M

u: Admin
p: DBAdmin

Case-sensitive

Regards,
Scott.

> Perhaps I don't see that yet because I haven't managed to log in - what are
> the default username and password?
>
> Thx
>
> Lauchlan M
>
>

Once you login to the server w/ ServerAdmin, you will see the tabs
to config users.. etc.

Login:
Admin
DBAdmin

Regards,
Scott.

> Another couple of newbie questions - what are the default username and
> passwords for the server, and where do I configure these? Also, where do I
> configure the users?
>
> Thx
>
> Lauchlan M
>
>

Correct,

Simply set the Session to Remote or Local.

There are Remote properties in Session/Database that are used
when connecting to the server.

> Well, that's sort of what I meant. there is a server, but it's embedded,
> right, with the component? You don't need to run a seperate one external to
> the app?
>
> Anyway, I follow what you are saying . . .
>

>> You only need a server running if you are using a C/S approach.
>> If you are using a local, then you simply open the table using
> TDBISAMTable or TDBISAMQuery.
>
> ok. What components do I drop for C/S and embedded apps?
>


Session,Database (Engine if you make changes, not requred)
Will get you going for either type of app.

Then drop a tdbisamquery / table and set the session / database name.

Regards,
Scott.

> Once you login to the server w/ ServerAdmin, you will see the tabs
> to config users.. etc.
>
> Login:
> Admin
> DBAdmin

Ah, I'd just found it in the help.

Now I have logged in, dropped a database, session, and query component (no
engine) and wired them up and seen data in a grid in both c/s and embedded
modes.

A couple of little things I am still confused about:

1. when I put the session into stlocal, the database component still demands
I enter a databasename. If this is embedded mode, why do I need an 'Alias'?

2. It was complaining in embedded mode when I used the default session name.
When I changed it to 'Fred' it worked. Not sure what was going on there.

3. I guess I must be a bit confused about what DatabaseName is - if it's an
Alias, why would one still need to choose the database in RemoteDataBase?
Wouldn't the Alias/Databasename specify this already?

4. All this was without dropping the DBISAMEngine component. Is this not
needed, even for embedded apps?

5. Where do I enter usernames and passwords, so that it doesn't give me the
username and password dialog in C/S mode?

Thanks!

Lauchlan M

> Session,Database (Engine if you make changes, not requred)
> Will get you going for either type of app.

And the main initial reason for dropping the Engine component in C/S apps
would be for changing the default server name?

Is it typically used for local apps?

Thx, I think I am beginning to see the picture here!

Lauchlan M