I'm trying to create a database via a delphi program and I'm getting stuck at the beginning. I have dropped a TEDBSession component on my form and I'm executing this command :

  EDBSession1.Execute('CREATE DATABASE "ADatabase" D:\etest ' +
                            'DESCRIPTION ' + QuotedStr('Test ADatabase') ) ;

The error it is returning is "#409 The configuration path is empty'

I do have a valid path in the "LocalConfigPath"  property. Right now that direcotry is empty. I guess I was expecting to see something happen in that directory like the appearance of some EDBConfig files - but I just get the error.  I'd like to be able to not use the manager to create the database but handle that in my own program.

Thanks for you info!
Jeff

Jeff,

> The error it is returning is "#409 The configuration path is empty'
>
> I do have a valid path in the "LocalConfigPath"  property.

By default EDB uses the config path property in the default engine object
that gets created behind the scenes for you rather than the config path on
the session object for local connections.  So even though you are setting
the config path property on the session object, it's not being used.

So to get around the 409 error, you have two options:

1. Set the engine configuration file path before you do any other EDB
operations by setting the engine.ConfigPath property:

engine.ConfigPath := 'c:\ConfigPath';


2. Tell the engine to use the local configuration information from the
session object:

engine.UseLocalSessionEngineSettings := True;


Hope this helps.

--

---------------------------------------
 Terry Swiers
 Millennium Software, Inc.
 http://www.1000years.com
 http://www.atrex.com

Now shipping Atrex 13.  For more information go to
 http://www.atrex.com/news.asp

Atrex Electronic Support Options:
 Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp
 Email: mailto:support@atrex.com
 Newsgroup: news://news.1000years.com/millennium.atrex
 Fax: 1-925-829-1851
 Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
 ---------------------------------------

Many thanks Terry   - I'm moving again!
jeff



"Terry Swiers" wrote:

Jeff,

> The error it is returning is "#409 The configuration path is empty'
>
> I do have a valid path in the "LocalConfigPath"  property.

By default EDB uses the config path property in the default engine object
that gets created behind the scenes for you rather than the config path on
the session object for local connections.  So even though you are setting
the config path property on the session object, it's not being used.

So to get around the 409 error, you have two options:

1. Set the engine configuration file path before you do any other EDB
operations by setting the engine.ConfigPath property:

engine.ConfigPath := 'c:\ConfigPath';


2. Tell the engine to use the local configuration information from the
session object:

engine.UseLocalSessionEngineSettings := True;


Hope this helps.

--

---------------------------------------
 Terry Swiers
 Millennium Software, Inc.
 http://www.1000years.com
 http://www.atrex.com

Now shipping Atrex 13.  For more information go to
 http://www.atrex.com/news.asp

Atrex Electronic Support Options:
 Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp
 Email: mailto:support@atrex.com
 Newsgroup: news://news.1000years.com/millennium.atrex
 Fax: 1-925-829-1851
 Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
 ---------------------------------------

Hopefully this will be my last probelm (haha)!

I wish I could get around the user and password prompt that comes up when that create database command is executed. In my session component I have already entered "Administrator" as user and "EDBDefault" as password in my object inspector. Does it not pick that that from the session? I didn't see any in the engine component (thinking there is similar engine-based username and password ).

But indeed it does create the database so I'm going in the right direction!

Jeff



"Terry Swiers" wrote:

Jeff,

> The error it is returning is "#409 The configuration path is empty'
>
> I do have a valid path in the "LocalConfigPath"  property.

By default EDB uses the config path property in the default engine object
that gets created behind the scenes for you rather than the config path on
the session object for local connections.  So even though you are setting
the config path property on the session object, it's not being used.

So to get around the 409 error, you have two options:

1. Set the engine configuration file path before you do any other EDB
operations by setting the engine.ConfigPath property:

engine.ConfigPath := 'c:\ConfigPath';


2. Tell the engine to use the local configuration information from the
session object:

engine.UseLocalSessionEngineSettings := True;


Hope this helps.

--

---------------------------------------
 Terry Swiers
 Millennium Software, Inc.
 http://www.1000years.com
 http://www.atrex.com

Now shipping Atrex 13.  For more information go to
 http://www.atrex.com/news.asp

Atrex Electronic Support Options:
 Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp
 Email: mailto:support@atrex.com
 Newsgroup: news://news.1000years.com/millennium.atrex
 Fax: 1-925-829-1851
 Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
 ---------------------------------------

Jeff,

> I wish I could get around the user and password prompt that comes up when
> that create database command is executed. In my session component I have
> already entered "Administrator" as user and "EDBDefault" as password in my
> object inspector. Does it not pick that that from the session? I didn't
> see any in the engine component (thinking there is similar engine-based
> username and password ).

The name and password entered on the session object should work and it does
appear to do so in my test app.  But I always set the ID and password on the
session object just before it is opened in the code, so that might be an
option for you.

--

---------------------------------------
 Terry Swiers
 Millennium Software, Inc.
 http://www.1000years.com
 http://www.atrex.com

Atrex Electronic Support Options:
 Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp
 Email: mailto:support@atrex.com
 Newsgroup: news://news.1000years.com/millennium.atrex
 Fax: 1-925-829-1851
 Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
 ---------------------------------------

Well I sure love an easy answer - I assigned those values in my source code and that's got it working. Great!
Jeff


"Terry Swiers" wrote:

Jeff,

> I wish I could get around the user and password prompt that comes up when
> that create database command is executed. In my session component I have
> already entered "Administrator" as user and "EDBDefault" as password in my
> object inspector. Does it not pick that that from the session? I didn't
> see any in the engine component (thinking there is similar engine-based
> username and password ).

The name and password entered on the session object should work and it does
appear to do so in my test app.  But I always set the ID and password on the
session object just before it is opened in the code, so that might be an
option for you.

--

---------------------------------------
 Terry Swiers
 Millennium Software, Inc.
 http://www.1000years.com
 http://www.atrex.com

Atrex Electronic Support Options:
 Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp
 Email: mailto:support@atrex.com
 Newsgroup: news://news.1000years.com/millennium.atrex
 Fax: 1-925-829-1851
 Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
 ---------------------------------------