Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 10 of 14 total
Thread SQL ElevateDB Tutorial
Thu, Jan 18 2007 7:25 PMPermanent Link

John Stevenson
I have been using DBISAM from the beginning, and to date, I have successfully avoided using SQL.
With the advent of ElevateDB, it looks like I need to move with the times.
I am intending to migrate from DBISAM to ElevateDB ... may as well do it now, rather than when DBISAM gets phased out in a few years.

I have tried to get going with the Tutorial in the help file that accompanies the ElevateDB beta.
But ... it starts off ...
The following steps will guide you through creating a basic local application using ElevateDB and Delphi 7.

Note
It is assumed that you have already created a database called "Tutorial" in the local folder "C:\Tutorial\DB" using the SQL below:

CREATE DATABASE "Tutorial"
PATH 'C:\Tutorial\DB'
DESCRIPTION 'Tutorial Database'

and that you have created a table called "Customer" in the "Tutorial" database using the SQL below:
... etc.

Well, I am lost there.
Checked out edbmgr, but all I can achieve there is an "ElevateDB Error #400 The collation ENU already exists." error message.
Could I get some step by step instructions on implementing the above, please?
Thanks

John
Fri, Jan 19 2007 8:39 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

John,

<< Checked out edbmgr, but all I can achieve there is an "ElevateDB Error
#400 The collation ENU already exists." error message. >>

When you do get this error message ?  Could you please elaborate on the
steps that you're taking ?  Also, what build of the preview are you using ?

To create a database in the EDB Manager you must:

1) Start up the EDB Manager
2) Make sure that the configuration file path is set to the desired location
('c:\Tutorial'):

   a) In the task pane, click on the Edit Options link
   b) Make sure that the configuration file folder in the first edit box is
the desired folder
   c) Click on the OK button.

3) Double-click on the Default session in the right-hand properties pane.
4) Click on the SQL tab at the top of the right-hand properties pane.
5) Paste in the CREATE DATABASE SQL from the tutorial.
6) Click on the Execute SQL link in the task pane.
7) Click on the Refresh button at the top of the EDB Manager.
8) Click on the + sign next to the Databases node in the treeview.
9) Click on the new Tutorial database that you just created.
10) Click on the Open Database link in the task pane.
11) Click on the SQL tab at the top of the right-hand properties pane.
12) Paste in the CREATE TABLE SQL from the tutorial.
13) Click on the Execute SQL link in the task pane.
14) Click on the Refresh button at the top of the EDB Manager.
15) The table should now show up in the list of Tables for the Tutorial
database.

--
Tim Young
Elevate Software
www.elevatesoft.com

Sun, Jan 21 2007 7:22 PMPermanent Link

John Stevenson
Tim

>>  << Checked out edbmgr, but all I can achieve there is an "ElevateDB Error
>>  #400 The collation ENU already exists." error message. >>
>> When you do get this error message ?  Could you please elaborate on the
>> steps that you're taking ?  Also, what build of the preview are you using ?

I am using ElevateDB Manager Version 1.00 (1.00 Build 5), which I think I downloaded on 18
January.
To get the above mentioned error message I clicked on Connect Session.

>> To create a database in the EDB Manager you must:
>> 1) Start up the EDB Manager
>> 2) Make sure that the configuration file path is set to the desired location
>> ('c:\Tutorial'):
>>    a) In the task pane, click on the Edit Options link

OK ... could not find any Edit Options link, but eventually found that if you selected
ElevateDB Manager on the left, it became visible.

>> 3) Double-click on the Default session in the right-hand properties pane.
If I do that, I get the "ElevateDB Error #400 The collation ENU already exists." error
message.

John

Mon, Jan 22 2007 8:06 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

John,

<< I am using ElevateDB Manager Version 1.00 (1.00 Build 5), which I think I
downloaded on 18 January.
To get the above mentioned error message I clicked on Connect Session. >>

What OS and version are you using ?  It sounds like there is a duplicate
locale ID installed on your system.

<< OK ... could not find any Edit Options link, but eventually found that if
you selected ElevateDB Manager on the left, it became visible. >>

The Edit Options task link should be visible when you first start up EDB.
Was this not the case for you ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Mon, Jan 22 2007 9:30 PMPermanent Link

John Stevenson
Tim

<< What OS and version are you using ?  It sounds like there is a duplicate
locale ID installed on your system. >>

Windows XP Pro Version 2002 SP2

<< The Edit Options task link should be visible when you first start up EDB.
Was this not the case for you ? >>

It is visible when I first start up EDB.  It would have been last time too, but in answering your question about the error message, I temporarily lost it.

John
Tue, Jan 23 2007 1:42 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

John,

<< Windows XP Pro Version 2002 SP2 >>

Weird.  I'll have to see about putting a check in EDB for this because I'm
not sure why the OS is serving up a duplicate locale.  It certainly isn't
doing so with XP SP2 here and we haven't had any other reports of this, so
it must be something very particular.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Jan 23 2007 10:26 PMPermanent Link

John Stevenson
<< Weird.  I'll have to see about putting a check in EDB for this because I'm
not sure why the OS is serving up a duplicate locale.  >>

Thanks Tim ... I will look forward to hearing from you when we can progress.

John
Wed, Jan 24 2007 11:14 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

John,

<< Thanks Tim ... I will look forward to hearing from you when we can
progress. >>

Could you do me a favor and run an application on your machine ?  I want to
see what it returns for the list of locales.  I will email it to you
privately if you agree to do so.

--
Tim Young
Elevate Software
www.elevatesoft.com

Wed, Jan 24 2007 11:48 AMPermanent Link

Evgeni Georgiev
I recieve the same error! I installed the beta of edbmgr to new instalation of XP sp2. First it ran normally then
I installed Bulgarian language and then the error raised.

Wed, Jan 24 2007 5:04 PMPermanent Link

John Stevenson
Tim

<< Could you do me a favor and run an application on your machine ?  I want to
see what it returns for the list of locales.  I will email it to you
privately if you agree to do so. >>

Of course ... no problem ... happy to do all that I can to assist!!

John
Page 1 of 2Next Page »
Jump to Page:  1 2
Image