Hi,

I have two services that both require access to the same database; the
services and database all reside on a single server.

Can the two services each run with a Local session pointing to the same
database, or do I need to use remote sessions in order to avoid database
access conflicts between the two services?

Thanks,
Jack

Jack


You can mix local and remote access to your heart's content

Roy Lambert

That's great news; I had expected that it would need to be one or the other.

Thanks Roy.


"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:8BA67FF1-4572-4FD3-BEC2-AE303F535A11@news.elevatesoft.com...
> Jack
>
>
> You can mix local and remote access to your heart's content
>
> Roy Lambert
>

Jack


Its one of the great benefits of DBISAM (and ElevateDB). The other nice bit is the similarity between filters and sql. As long as you ignore joins they're almost identical, and most of the time the differences don't matter. It does mean you can use things like TEXTSEARCH and LIKE in filters.

The other major major benefit is this community. Damn few flames and a lot of help. The final benefit is Tim although at present he's disappeared into the maw of ElevateDB but we do have hope of him clawing his way out eventually.

Roy Lambert

Roy,

<< The other major major benefit is this community. Damn few flames and a
lot of help. The final benefit is Tim although at present he's disappeared
into the maw of ElevateDB but we do have hope of him clawing his way out
eventually. >>

I'm back from the pits of hell, otherwise known as refreshable static result
sets.   It took 70+ hours over this last week to get that damn Sudoko puzzle
solver to finally work with EDB, but it finally does.  It's really hard to
debug views that are 7-8 levels deep.

--
Tim Young
Elevate Software
www.elevatesoft.com

Jack,

<< Can the two services each run with a Local session pointing to the same
database, or do I need to use remote sessions in order to avoid database
access conflicts between the two services? >>

Per what others have said - yes, you can have a DBISAM database server, or
servers, accessing the same database(s) as other local applications like web
apps.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim,

> I'm back from the pits of hell, otherwise known as refreshable static result
> sets.   It took 70+ hours over this last week to get that damn Sudoko puzzle
> solver to finally work with EDB, but it finally does.  It's really hard to
> debug views that are 7-8 levels deep.

You mean you've spent all that time playing games?  Tsk tsk.  

SteveG

Tim


Well done Ole <vbcg>

Roy Lambert

Steve,

<< You mean you've spent all that time playing games?  Tsk tsk.  >>

Well, let me just say that I have no desire to play Sudoko any time soon.


--
Tim Young
Elevate Software
www.elevatesoft.com