Hello,

I have the following problem with EDB 2.03 (Unicode) D2010

The Application is installed local

There is a Database local and a Database on a Server (non C/S) Shared
access.

I now need to setup my Applicaction to use the local and the Server
Database

I have to sessions one for the local and one for the Server DB

There ar two EDB Configfiles one local and on on the Server

How to Setup these Situation ?

Thanks Fritz

Friedrich,

> I have to sessions one for the local and one for the Server DB
> There ar two EDB Configfiles one local and on on the Server
> How to Setup these Situation ?

You can use local settings for your sessions, e.g.:

Session1.LocalConfigPath := '\\myserver\d\mydata';
Session2.LocalConfigPath := 'c:\mydata2';

Important: to use these local settings you have to set

MyEngine.UseLocalSessionEngineSettings := true;

Have a look on this discussion, you'll find some more details there:
http://tinyurl.com/y986tby

Regards Uli

Uli

>> I have to sessions one for the local and one for the Server DB
>> There ar two EDB Configfiles one local and on on the Server
>> How to Setup these Situation ?
>
>You can use local settings for your sessions, e.g.:
>
>Session1.LocalConfigPath := '\\myserver\d\mydata';
>Session2.LocalConfigPath := 'c:\mydata2';
>
>Important: to use these local settings you have to set
>
>MyEngine.UseLocalSessionEngineSettings := true;

And just as a reminder the two config paths must point to the same config file.

Roy Lambert [Team Elevate]

Roy,

> And just as a reminder the two config paths must point to the same config file.

Unless I misunderstand you: I don't think so. He wants to access two
different config files using two different sessions.

But it's true that a database can *not* be accessed by different
sessions using different config files. Maybe that's what you mean.

Regards Uli

Uli

>Unless I misunderstand you: I don't think so. He wants to access two
>different config files using two different sessions.

Rereading its possible you're right. It wasn't how I read it to start with. My take is that he wants to access both databases simultaneously, and I was assuming transfer data between (or at least use both in queries simultaneously) in which case you need a single session pointing to both databases.

Confusing ain't it

Roy Lambert [Team Elevate]

Roy,

<< Rereading its possible you're right. It wasn't how I read it to start
with. My take is that he wants to access both databases simultaneously, and
I was assuming transfer data between (or at least use both in queries
simultaneously) in which case you need a single session pointing to both
databases. >>

That's really the key:  as you say, if you want to transfer data directly
between the two, then you need to have them using the same configuration
file.  If not, then multiple sessions is fine.

There's always replication also, if one doesn't mind a little delay (minute
or more) in the transfer of the data.

--
Tim Young
Elevate Software
www.elevatesoft.com

Uli Becker wrote:

>
> MyEngine.UseLocalSessionEngineSettings := true;

Thanks, these was the missing part

Fritz