I have setup a server and a session connecting to it.  I then tried to create a database with no preceeding path info (ex. instead of C:\ElevateDB\TestDB, I put in just TestDB).  It creates the database and it shows up in the tree, but when I try to open it, it gives the following error:

---------------------------
ElevateDB Manager
---------------------------
ElevateDB Error #9999 Unable to create directory.
---------------------------
OK   
---------------------------

If I then try to drop the database, I get the following error:

---------------------------
ElevateDB Manager
---------------------------
ElevateDB Error #600 File manager error (Cannot create file TestDB3\main.edbcat (OS Error: The system cannot find the path specified))
---------------------------
OK   
---------------------------

I have tried shutting down the server and EDBMgr and restarting both, but still cannot drop the database...

Robert,

<< I have setup a server and a session connecting to it.  I then tried to
create a database with no preceeding path info (ex. instead of
C:\ElevateDB\TestDB, I put in just TestDB).  It creates the database and it
shows up in the tree, but when I try to open it, it gives the following
error:

---------------------------
ElevateDB Manager
---------------------------
ElevateDB Error #9999 Unable to create directory.
---------------------------
OK
--------------------------- >>

This is an OS error, which means that for whatever reason, the TestDB path
cannot be created based upon the current working directory.  It's a bad idea
to use relative paths for databases, so you should avoid doing so.

<<  If I then try to drop the database, I get the following error:

---------------------------
ElevateDB Manager
---------------------------
ElevateDB Error #600 File manager error (Cannot create file
TestDB3\main.edbcat (OS Error: The system cannot find the path specified))
>>

This error says TestDB3, not TestDB.  Are you creating more than one
database ?

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

> This is an OS error, which means that for whatever reason, the TestDB path
> cannot be created based upon the current working directory.  It's a bad idea
> to use relative paths for databases, so you should avoid doing so.

Understood, but when I connect locally under DBISAM and do the same, I have no problem (it just adds a subdir under the current server folder).  Just something you might want to check for (if cannot create folder, don't add it - check for full path, etc.)


> This error says TestDB3, not TestDB.  Are you creating more than one
> database ?

Sorry, I had created another database to get the error messages for you - I have 2 with the same problem now - the original one was TestDB - TestDB3 was the one I created step by step to give you the order of operations I was performing as well as the error messages...  They both have
the same problem, however...  Sorry for the confusion!!

--
Tim Young
Elevate Software
www.elevatesoft.com

Robert,

<< Understood, but when I connect locally under DBISAM and do the same, I
have no problem (it just adds a subdir under the current server folder).
Just something you might want to check for (if cannot create folder, don't
add it - check for full path, etc.) >>

It's a Delphi 6 or higher issue - the ForceDirectories function in SysUtils
for these versions doesn't like relative path names like that.  I'll code a
workaround into our file system units.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thanks, Tim!

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Robert,

<< Understood, but when I connect locally under DBISAM and do the same, I
have no problem (it just adds a subdir under the current server folder).
Just something you might want to check for (if cannot create folder, don't
add it - check for full path, etc.) >>

It's a Delphi 6 or higher issue - the ForceDirectories function in SysUtils
for these versions doesn't like relative path names like that.  I'll code a
workaround into our file system units.

--
Tim Young
Elevate Software
www.elevatesoft.com