I have on a disk a database created by code. All happy.

I want to access it using the database manager. It doesn't seem logical
to me that I therefore have to "create" a session in the manager. I
don't understand why I'm not "opening an existing session". Why can't I
point at the location of the EDBCfg file and enter a password and all
done?

What am I missing here?

--

Matthew Jones

Matthew Jones wrote:

>  "create" a session

I should say that I'm also nervous about this as everything is good
now, so I don't want to create anything new and break the existing
database or anything.

--

Matthew Jones

Matthew

>I want to access it using the database manager. It doesn't seem logical
>to me that I therefore have to "create" a session in the manager. I
>don't understand why I'm not "opening an existing session". Why can't I
>point at the location of the EDBCfg file and enter a password and all
>done?
>
>What am I missing here?

On the face of it its a very reasonable approach, and it could probably be done but ....

Opening a database in ElevateDB is a bit different to just opening a standalone table such as is the case in DBISAM. The main difference is that you now have two files which control things (configuration & catalog)  - in DBISAM there were none.

Think about the information you enter into a TEDBSession component - that isn't stored in the configuration file - that's what EDBManager's .ini file is for.To open up the session in EDBManager by double clicking the .EDBCfg file would need it to use defaults / make assumptions. Is this an ANSI or UNICODE database, is it to be opened locally or remotely. OK it could guess somethings (eg the configuration folder and configuration file name) but others it would be a bit dangerous to guess (eg Large File Support). Then there's not just a password that can be applied there's an engine signature and encryption as well) There's also do you want to access f/s or c/s. Finally users have the option of altering the file names and the extensions to their own choosing so the necessary associations may not be set up.

Is that enought to miss or would you like more

Roy Lambert

Roy Lambert wrote:

> Matthew
>
> > I want to access it using the database manager. It doesn't seem
> > logical to me that I therefore have to "create" a session in the
> > manager. I don't understand why I'm not "opening an existing
> > session". Why can't I point at the location of the EDBCfg file and
> > enter a password and all done?
> >
> > What am I missing here?
>
> On the face of it its a very reasonable approach, and it could
> probably be done but ....
>
> Opening a database in ElevateDB is a bit different to just opening a
> standalone table such as is the case in DBISAM. The main difference
> is that you now have two files which control things (configuration &
> catalog)  - in DBISAM there were none.
>
> Think about the information you enter into a TEDBSession component -
> that isn't stored in the configuration file - that's what
> EDBManager's .ini file is for.To open up the session in EDBManager by
> double clicking the .EDBCfg file would need it to use defaults / make
> assumptions. Is this an ANSI or UNICODE database, is it to be opened
> locally or remotely. OK it could guess somethings (eg the
> configuration folder and configuration file name) but others it would
> be a bit dangerous to guess (eg Large File Support). Then there's not
> just a password that can be applied there's an engine signature and
> encryption as well) There's also do you want to access f/s or c/s.
> Finally users have the option of altering the file names and the
> extensions to their own choosing so the necessary associations may
> not be set up.

Surely most of that is in the config too? Should be if not.

But if this is all in an INI and it won't create, I shall have
confidence to continue... (and a backup!)

--

Matthew Jones

Matthew


>Surely most of that is in the config too? Should be if not.

No and possibly. However, leaving any of it out means you can't simply double click the file.

Look at the properties of the TEDBSession component

>But if this is all in an INI and it won't create, I shall have
>confidence to continue... (and a backup!)

Do not understand - what won't create what?

Roy

Roy Lambert wrote:

> > But if this is all in an INI and it won't create, I shall have
> > confidence to continue... (and a backup!)
>
> Do not understand - what won't create what?

Won't create a new set of files that wipes out my existing ones. That
is, if I get something wrong, it won't break the application I already
have working.

--

Matthew Jones

On 9/27/2016 6:48 AM, Matthew Jones wrote:
> I want to access it using the database manager. It doesn't seem logical
> to me that I therefore have to "create" a session in the manager. I
> don't understand why I'm not "opening an existing session". Why can't I
> point at the location of the EDBCfg file and enter a password and all
> done?
>
> What am I missing here?

Because session is the "how do i connect" part of the equation.

When you are using a local session the "how" is the path, remote session
the "how" is the IP/hostname

EDBCfg file captures the databases, users and such info - it can be
accessed thru numerous ways.

If you ran EDB in C/S mode then you would not think twice about a need
of creating a remote session on every PC you wish to run manager on in
order to access the edb.

This is same except it applies locally as well - you need to tell every
app (your code vs manager) "how" to get to edb.

Raul

Raul wrote:

> If you ran EDB in C/S mode then you would not think twice about a
> need of creating a remote session on every PC you wish to run manager
> on in order to access the edb.

Indeed - I think it is the fact it "feels special" that the EDB Manager
might know more, and that the dialog feels like I'm creating the data
in the directory, but I'm actually storing it in an INI file.

Thanks both.

--

Matthew Jones

Matthew


>Won't create a new set of files that wipes out my existing ones. That
>is, if I get something wrong, it won't break the application I already
>have working.

Ah - no - all it does is stuff the information into the .ini

Roy

On 9/27/2016 9:06 AM, Matthew Jones wrote:
> Indeed - I think it is the fact it "feels special" that the EDB Manager
> might know more, and that the dialog feels like I'm creating the data
> in the directory, but I'm actually storing it in an INI file.

New enhancement for EDB then - when you're creating a new session EDB
Manager should show one of those "Keep Calm and Carry On" images on the
session creation dialog  

Raul