Using ADO.NET and the EDBConnection component, I'm able to create my own
EDBConfig file, which from what I can gather is basically = a 'Session'. I
can then create a database, some tables and populate some data etc.

My question is - how can I then access this new 'session' in EDB Manager?

The only option is to create a NEW session, but if I do that and point it at
the same folder as the session I created in code, it seems to overwrite the
EDBConfig file (and therefore all the settings).

Intuitively, what I'm looking for is something like an "Add Existing
Session" option in EDB Manager.

Have I missed something obvious?!

Thanks.

Hedley,

<< My question is - how can I then access this new 'session' in EDB Manager?
>>

You don't access the "session" itself.  Sessions are transient and not
stored anywhere.  What you would do, instead, is create a new session in the
ElevateDB Manager that accesses the particular ElevateDB Server (remote
session) or configuration file (local session) that you're using, and then
save it.

<< The only option is to create a NEW session, but if I do that and point it
at the same folder as the session I created in code, it seems to overwrite
the EDBConfig file (and therefore all the settings). >>

ElevateDB won't ever overwrite a configuration file.  First and foremost,
are you using the Unicode version of the ElevateDB Manager ?  That is
required if you're working with configurations and a databases used in .NET.
Secondly, what "settings" are you saying are being overwritten ?  It could
be that you're thinking certain settings are stored in the configuration
that are actually only configured in each session in code.

<<  Intuitively, what I'm looking for is something like an "Add Existing
Session" option in EDB Manager. >>

Session are only persistent in the EDB Manager, and only as a matter of
convenience when workin in the manager.  Anywhere else they are only
component-based and transient.  They exist only as a container representing
the current user thread access a given configuration and database(s).

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim,

I'm using local access (not c/s) and I managed to work out that I had to use
the UNICODE Manager for .NET (although I couldn't find anything in the
documentation about that)!

>> Sessions are transient and not  stored anywhere

Oh... so what information is actually stored in the EDBConfig.EDBCfg file?
Just databases/users/roles etc?

>> what "settings" are you saying are being overwritten ?  It could be that
>> you're thinking certain settings are stored in the configuration that are
>> actually only configured in each session in code.

I think you've hit the nail on the head. I use the
EDBConnectionStringBuilder to create my connection string and these are the
settings I use...

     sb.LargeFiles = true;
     sb.LogCats = "Warn,Error";
     sb.Encrypted = true;
     sb.EncryptPWD = "my_password";
//    sb.ConfigName = "EDBConfig";    // default
//    sb.ConfigExt = ".EDBCfg";       // default
     sb.LockExt = ".lck";
     sb.LogExt = ".log";
//    sb.CatalogName = "EDBDatabase"; //default
     sb.CatalogExt = ".cat";
     sb.BackupExt = ".bkp";
     sb.UpdateExt = ".upd";
     sb.TableExt = ".tbl";
     sb.IndexExt = ".idx";
     sb.BlobExt = ".blb";
     sb.PublishExt = ".pbl";

(I'm afraid I can't get used to 6 character file extensions!

I was expecting these to be stored in the EDBConfig file and when I was
creating a "new" session in the EDB Manager, I thought it was changing these
values. I think I'm at last starting to understand the architecture better
now though - thanks for your help!

Hedley

Hedley,

<< I'm using local access (not c/s) and I managed to work out that I had to
use the UNICODE Manager for .NET (although I couldn't find anything in the
documentation about that)! >>

http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=0&topic=5

Under "Internationlization":

Note
Windows .NET implementations always use the Unicode character set. Only
Win32 and Linux implementations have an option for choosing the target
compiler character set. Please see your product-specific documentation for
information on which character set is supported.

I'll grant you that it isn't exactly shouted out, but it's there.

<< Oh... so what information is actually stored in the EDBConfig.EDBCfg
file? Just databases/users/roles etc? >>

Yes, here is what is stored there or virtualized as part of the
configuration:

http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=3&topic=39

<< (I'm afraid I can't get used to 6 character file extensions! >>

No problem.  That's why we provide the ability to change them.

--
Tim Young
Elevate Software
www.elevatesoft.com