I have just done a simple clean install of EDB components onto a new computer. The computer includes a DBISAM V4.30 DB.

I have run the EDB Manager program and clicked on "Migrate Database". No dialogue fires up, instead I see the message:

"ElevateDB Error #401. The Module edbmigratedbisam4 does not exist in the configuration EDBConfig."

... I have used the migrate process in previous situations (a while ago). I am now running a Windows 7 computer ... might that be the problem? Perhaps I need to change Win7 settings somewhere?

Adam,

> .. I have used the migrate process in previous situations (a while
> ago)

Since v2.04, the modules now have to be created by you in a remote
session. The EDB Manager can crete them for you in the default local
session.

> I have run the EDB Manager program and clicked on "Migrate Database".
> No dialogue fires up, instead I see the message:
>
> "ElevateDB Error #401. The Module edbmigratedbisam4 does not exist in
> the configuration EDBConfig."

As I alluded to above, which session are you using...the default local
session or a remote session? If the default local session, simply start
the session and click on the "Create Database Migrators" link in the
Tasks menu.

If you are using a remote session, start a new SQL statement and you
can then check to see if there are any migrators in the Configurations
database using SELECT * from Configuration.Modules. Or you can "View
Installed Modules" from the Tasks menu to accomplish the same thing.

If there are no modules created, first create the module using a SQL
statement:
CREATE MODULE "edbmigratedbisam4"
PATH 'C:\ElevateDB\edbmigratedbisam4.dll'
DESCRIPTION 'DBISAM 4'

then create the migrator, again using a SQL statement:
CREATE MIGRATOR "DBISAM4"
MODULE "edbmigratedbisam4"
DESCRIPTION 'DBISAM 4'

> .. I have used the migrate process in previous situations (a while
> ago). I am now running a Windows 7 computer ... might that be the
> problem? Perhaps I need to change Win7 settings somewhere?

I am running Windows 7 Professional and have been since November 2009.
There is nothing I had to do differently in Win7 than on an XP box to
create migrators.

There is some basic information regarding local session migrators at:
http://www.elevatesoft.com/supportfaq?action=view&category=edb&question=
missing_elevatedb_manager_migrators

Further information on creating migrators can be found in the SQL
manual.

HTH...

--
Jan Ferguson [Team Elevate]

Dear Jan,

Thank you for this. I am still grappling with the additional levels of complexity of EDB having worked with DBISAM for a long time.

>>If the default local session, simply start
>>the session and click on the "Create Database Migrators" link in the
>>Tasks menu.

Sorry, but my "Tasks" menu does not include this option. The only ones listed are:

Disconnect Session, Edit Session, Rename Session, Delete Session, Create Copy of Session.

I am using V2.05 of the EDB Manager.



Following this I tried using the script as suggested:

>>CREATE MODULE "edbmigratedbisam4"
>>PATH 'C:\ElevateDB\edbmigratedbisam4.dll'
>>DESCRIPTION 'DBISAM

When I do this I am give the message "ElevateDB Error #502 Administrator privileges are required to perform this operation (CREATE MODULE edbmigratedbisam4)"

It is a bit crazy, I have looked around EDB Help files a bit, but I can't find any notes on how to create a user with Admin privileges ... you need to _have_ Admin privileges to create a user that has them ... but my DEFAULT user doesn't have them, and there are no other users listed.

I am guessing perhaps my Tasks Menu is context sensitive and so does not show the "Migrate" option because my user doesn't have the rights ...

Sorry to be a Newbie.

Adam,

> Thank you for this. I am still grappling with the additional levels
> of complexity of EDB having worked with DBISAM for a long time.

Understood. It took me a while to wrap my brain around the differences
as well, having been with DBISAM since 2002.

> Sorry, but my "Tasks" menu does not include this option.

It sounds like you are not logged in with Administrator rights. When
you first install EDBManager the default username/password combination
is: Administrator/EDBDefault. Are you logged in as some other user with
non-administrative rights?

> I am using V2.05 of the EDB Manager.

You need to be logged into ANY version of EDB Manager to accomplish
what we have been discussing. But I am also using v2.05 as well.

> When I do this I am give the message "ElevateDB Error #502
> Administrator privileges are required to perform this operation
> (CREATE MODULE edbmigratedbisam4)"

That confirms what I mentioned above, You definitely need to log into
the EDB Manager with administrative rights, not necessarily as the
"Administrator" user but as a user who has been assigned administrative
rights.

> It is a bit crazy, I have looked around EDB Help files a bit, but I
> can't find any notes on how to create a user with Admin privileges

It's very simple. Once you log in (as an administrator) go to the
"Users" menu option. Under "Users Properties" in the center section you
will see "Add a New User". Create the user and save it. Then go to
"Roles" and click on Roles|Administrators|Role Users. In the "Role
Users Properties" center section you will see, "Add a User". Click on
that option and select the user you wish to grant administrator
permissions to.

NOTE: This will have to be accomplished for the local session as well
as the remote session (if you are running a remote session) since they
are two totally separate configuration files.

There is User Security information in the EDB SQL Manual starting on
page 22, however that doesn't address the use of EDBManager in creating
an administrative user.

> I am guessing perhaps my Tasks Menu is context sensitive and so does
> not show the "Migrate" option because my user doesn't have the rights

Absolutely correct. A user with non-adminstrative rights can only
change their own password and perform other non-administrative type
tasks.

> Sorry to be a Newbie.

Don't be sorry for that. We all have to crawl before we can walk or
run. I can't count the number of times I asked Tim questions or
searched these newsgroup for answers.

--
Jan Ferguson [Team Elevate]

Adam,

<< When I do this I am give the message "ElevateDB Error #502 Administrator
privileges are required to perform this operation (CREATE MODULE
edbmigratedbisam4)"

It is a bit crazy, I have looked around EDB Help files a bit, but I can't
find any notes on how to create a user with Admin privileges ... you need to
_have_ Admin privileges to create a user that has them ... but my DEFAULT
user doesn't have them, and there are no other users listed. >>

What user are you logging in as ?  If you use the default Administrator user
(password EDBDefault), then you will have Administrator privileges.

<< I am guessing perhaps my Tasks Menu is context sensitive and so does not
show the "Migrate" option because my user doesn't have the rights ... >>

Yes, that is correct.

--
Tim Young
Elevate Software
www.elevatesoft.com

Dear Jan & Tim,

Sorry to take up masses of time & multiple posts on this trivial issue.

I don't "log in" to EDBManager at all ... it just starts, with the default session open. I can immediately open tables & do anything that does not require admin privileges on the first database I have created.

Once EDBManager is open, there does not seem to be any option in EDBManager where I can "log off" or perhaps "re-log on" at a new or raised level of Admin rights.

I assume this process is different from the process of connecting to a session. I can connect and disconnect the default session without entering any password.

Curiously, when I create a completely new session (other than the default) and try to connect to it I am asked to enter a login, but the login does not accept the User Name / Password which I have set in the "create session" dialogue. So I cannot connect to any session other than the default.

1 more thing: I am now trying to connect in Delphi, to some database objects in the default database.

I have set up a database, session & query object, but when I try to connect I get the message

"Error 409 the configuration path is empty"

This may well be related to my other problems above.

>>"Error 409 the configuration path is empty"

APOLOGIES, for the above, please ignore. I just didn't realise that I needed a TEDBEngine component. I have slotted one in & can connect to the tables just fine.

Adam


EDBManagher is a fair bit different from DBSys

When you open EDBManager you should see a list of sessions. Click on one and the "centre menu" changes. You should see Edit Session as one of the options. Click on that and you get a tabbed form. One of the pages is Logon. You can alter the user name / password here. If you leave them blank (or invalid) you'll be prompted when you try and open the session.

Roy Lambert [Team Elevate]

Adam,

Is this instance of EDBManager at a client's location? I can't figure
out why you would be able to automatically log in via the default local
session automatically and NOT as an administrator. While it's been a
long time since the first time I initially installed EDBManager, you
would at least be able to have administrator access even if it
automatically logs you in.

Having said the above, Roy gave you the correct information on how to
stop EDBManager from automatically logging in.

--
Jan Ferguson [Team Elevate]


Adam Brett wrote:

> I don't "log in" to EDBManager at all ... it just starts, with the
> default session open.
>
> Once EDBManager is open, there does not seem to be any option in
> EDBManager where I can "log off" or perhaps "re-log on" at a new or
> raised level of Admin rights.