Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 6 of 6 total |
Error Creating Database |
Thu, Sep 23 2010 1:58 AM | Permanent Link |
Jeff Newlin Lightspeed | 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 |
Thu, Sep 23 2010 2:49 AM | Permanent Link |
Terry Swiers | 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) --------------------------------------- |
Thu, Sep 23 2010 3:09 AM | Permanent Link |
Jeff Newlin Lightspeed | 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) --------------------------------------- |
Thu, Sep 23 2010 3:21 AM | Permanent Link |
Jeff Newlin Lightspeed | 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) --------------------------------------- |
Thu, Sep 23 2010 11:38 AM | Permanent Link |
Terry Swiers | 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) --------------------------------------- |
Thu, Sep 23 2010 4:44 PM | Permanent Link |
Jeff Newlin Lightspeed | 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) --------------------------------------- |
This web page was last updated on Wednesday, June 12, 2024 at 01:54 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |