Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread prepurchase DBISAM C/S Version Questions
Thu, Apr 11 2013 4:48 PMPermanent Link

Brent Shelton

I have questions about upgrading to the C/S version of DBISAM before I upgrade to it:

1.  Is it ok if one user has his client set to local and another client has their client set to remote
and they are accessing the same data tables?

2.  I currently have 4.30 Build 7 with Source using Delphi 7 Pro.  Some of my users call about missing "secondary index" errors.  I think it might be caused by their network setup using wifi to connect to the database.  Do you think using a C/S set up would prevent this since all of the work would be happening on one system?

Thanks,
Wayne
Thu, Apr 11 2013 6:27 PMPermanent Link

Raul

Team Elevate Team Elevate

On 4/11/2013 4:48 PM, Wayne Delph wrote:
> 1.  Is it ok if one user has his client set to local and another client has their client set to remote
> and they are accessing the same data tables?

Yes.

If you are licensed for any version of DBISAM you get the 5-user dbsrvr
so you can try it out yourself before purchase to make sure everything
works OK.

> 2.  I currently have 4.30 Build 7 with Source using Delphi 7 Pro.  Some of my users call about missing "secondary index" errors.  I think it might be caused by their network setup using wifi to connect to the database.  Do you think using a C/S set up would prevent this since all of the work would be happening on one system?

What is the exact error? You should not be getting those errors even in
file sharing mode so i would investigate the source of the errors first.

In general yes C/S would work better as it would be the only process
accessing  the data tables and you would eliminate any file sharing
related issues.

Raul
Fri, Apr 12 2013 4:01 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Raul

>> 2. I currently have 4.30 Build 7 with Source using Delphi 7 Pro. Some of my users call about missing "secondary index" errors. I think it might be caused by their network setup using wifi to connect to the database. Do you think using a C/S set up would prevent this since all of the work would be happening on one system?
>
>What is the exact error? You should not be getting those errors even in
>file sharing mode so i would investigate the source of the errors first.

Whilst I support your comment I'd suspect the wi-fi connection. It doesn't take much of a drop out before you get trouble in fileshareing mode.

>In general yes C/S would work better as it would be the only process
>accessing the data tables and you would eliminate any file sharing
>related issues.

Agreed BUT a bigger faster machine may be needed to provide a reasonable level of experience for the users. So how many users are going to have to be supported?

Roy Lambert [Team Elevate]
Fri, Apr 12 2013 7:56 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Wayne,

<< 1.  Is it ok if one user has his client set to local and another client
has their client set to remote and they are accessing the same data tables?
>>

Yes.  However, I would only recommend allowing direct access to the database
tables to processes executing on the server machine.  If you allow direct
network file access, then you're eliminating one of the benefits of using
the DBISAM Database Server since it only takes one such client to go down
during a write to end up corrupting one or more tables.

<< 2.  I currently have 4.30 Build 7 with Source using Delphi 7 Pro.  Some
of my users call about missing "secondary index" errors.  I think it might
be caused by their network setup using wifi to connect to the database.  Do
you think using a C/S set up would prevent this since all of the work would
be happening on one system? >>

Yes, absolutely.  If a connection gets dropped with a remote session, the
DBISAM Database Server will just keep doing what it was last doing for the
client until it is done, and then will clean up the session in an orderly
fashion if the client's remote session doesn't reconnect within a certain
time period (configurable).

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com
Image