Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 7 of 7 total
Thread opening database at design time
Wed, Jul 18 2012 6:52 AMPermanent Link

Iztok Lajovic (1)

Hello

I have created session "Kres" and database "Prian" in EDB manager and successfully migrated data into it also using manager. I use "C\kresEDB\EDB" as my config folder.
When I try to open database in IDE, there is noting in database drop-down list.
I use local session and it's "LocalConfigPath" is the same as above (C:\kresEDB\EDB"). If I manually type in my database name and want to open it, I get "Elevate DB error # 401 The database Prian does not exist".

I know I must be missing something trivial, but I've spend so much time figuring this out, I am afraid I would not see the solution if it hit me on my head. So I am asking for your help.

If config paths are the same, what else is there to check?

thank you for your help

Iztok Lajovic
Wed, Jul 18 2012 7:12 AMPermanent Link

Uli Becker

Iztok,

> I have created session "Kres" and database "Prian" in EDB manager and successfully migrated data into it also using manager. I use "C\kresEDB\EDB" as my config folder.
> When I try to open database in IDE, there is noting in database drop-down list.
> I use local session and it's "LocalConfigPath" is the same as above (C:\kresEDB\EDB"). If I manually type in my database name and want to open it, I get "Elevate DB error # 401 The database Prian does not exist".
>
> I know I must be missing something trivial, but I've spend so much time figuring this out, I am afraid I would not see the solution if it hit me on my head. So I am asking for your help.
>
> If config paths are the same, what else is there to check?

Make sure that "UseLocalSessionEngineSettings" of the engine is set to true.

From the manual:
<<
Use the UseLocalSessionEngineSettings property to indicate that you wish
to have any TEDBSession component use its own Local* versions of the
following TEDBEngine properties...
>>

Uli



Wed, Jul 18 2012 7:20 AMPermanent Link

Iztok Lajovic (1)

Uli Becker wrote:

Iztok,

Make sure that "UseLocalSessionEngineSettings" of the engine is set to true.

From the manual:
<<
Use the UseLocalSessionEngineSettings property to indicate that you wish
to have any TEDBSession component use its own Local* versions of the
following TEDBEngine properties...
>>

Uli

Thanks for such a fast response Smile
I've had that on true since I've put engine on my form. Maybe I am still thinking in DBISAM standards, but I've read manual and reinstalled EDB countless times, and I still have a feeling it's just something small that eludes me.

Iztok
Wed, Jul 18 2012 9:10 AMPermanent Link

Iztok Lajovic (1)

I found the solution.

I had to delete my app, close EDB manager, reopen it, make my app from beginning and now I can use my database at design time. And I have identical settings on my engine, session and DB as before. Identical!

Is the problem in creation order? I followed manual instructions to the letter and still ... sometimes it works and sometimes it doesn't. Why so much work for something so basic?

Iztok
Wed, Jul 18 2012 9:14 AMPermanent Link

Uli Becker

Iztok,
> I've had that on true since I've put engine on my form. Maybe I am still thinking in DBISAM standards, but I've read manual and reinstalled EDB countless times, and I still have a feeling it's just something small that eludes me.

Actually it's quite simple when you are used to it. Smile

Try this:

1. Create a new project
2. Drop a TEDBEngine component on your form
3. Set UseLocalSessionEngineSettings of the Engine component = true
4. Drop a TEDBSession component on your form

Assign these properties:
a) LocalConfigPath
b) LoginUser
c) LoginPassword
d) SessionName (call it "test" for the moment)

5. Drop a TEDBDatabase component on your form
6. Set SessionName = "test"
7. Set Databasename = "test"

Clickin on the dropdown button of "Database" you should see now the
available databases.
Maybe you forgot to set the sessionname.

Uli


Wed, Jul 18 2012 9:16 AMPermanent Link

Uli Becker

Iztok,

> I found the solution.
>
> I had to delete my app, close EDB manager, reopen it, make my app from beginning and now I can use my database at design time. And I have identical settings on my engine, session and DB as before. Identical!
>
> Is the problem in creation order? I followed manual instructions to the letter and still ... sometimes it works and sometimes it doesn't. Why so much work for something so basic?

You must have done something wrong.
Actually creating something like you tried is a very basic and reliable
thing. (I do it every day Smile

Uli

Thu, Aug 2 2012 3:47 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Iztok,

<< I had to delete my app, close EDB manager, reopen it, make my app from
beginning and now I can use my database at design time. And I have identical
settings on my engine, session and DB as before. Identical! >>

I'm really not calling you a liar here, but you must have done something
differently. Smile

<< Is the problem in creation order? I followed manual instructions to the
letter and still ... sometimes it works and sometimes it doesn't. Why so
much work for something so basic? >>

You're doing something wrong if it doesn't work.  As for why so much work -
there really isn't that much to it.  It just seems like it because it's all
new to you and you're used to DBISAM.  Once you have an entire application
referring to the database name "MyDatabase" and you need to move it
somewhere or convert it from CS to local, or vice-versa, you'll appreciate
how the configuration file works and why it is important.

Tim Young
Elevate Software
www.elevatesoft.com
Image