Hi,
i'm using EDBElevate trial.
I use client version to create a portal software. (a software without installation
database system)
i create a databse by elevatedb manager. i set directory of config and database same and
to c:\my project\db
when i move the project to d:\ i config the configpath to current directory as below.
my connecion open but when i want select from table, raise an error that tableName doesn't
exist.
i trace the code and found the error :
EDBConfig.EDBCfg  save inner the last path. when i use elevatedb manager and alter my
database and correct the path this problem solved.
but i need to do this by code. i found the command as ALTER DATABASE PATH 'new path' but
failed,m because database in used.
please helpme to solve my problem.

Visual Studio 2008
Windows Server 2003
elevate.elevatedb.data   2.2.3.0

Codes :
           EDBConnectionStringBuilder csb = new EDBConnectionStringBuilder();
           csb.Type = "LOCAL";
           csb.ConfigPath =
System.IO.Path.GetDirectoryName(Application.ExecutablePath)+"\\DB\\";
           csb.Database = "ParseSMSStudioDB";
           csb.CatalogName = "";     


CatalogName After Open the Connection Fill By Old Path.

Error after Select Command :  

"ElevateDB Error #700 An error was found in the statement at line 1 and column 15
(ElevateDB Error #401 The table or view PhoneBook does not exist)"

Mehrdad,

<< but i need to do this by code. i found the command as ALTER DATABASE PATH
'new path' but failed,m because database in used. please helpme to solve my
problem. >>

You need to make sure that the current database is the system-defined
"Configuration" database when you execute the ALTER DATABASE statement.  You
can use the EDBConnection.ChangeDatabase() method to do so:

MyConnection.ChangeDatabase("Configuration");

//  Now execute the ALTER DATABASE

MyConnection.ChangeDatabase("MyExistingDatabase");

// Continue with normal operation

--
Tim Young
Elevate Software
www.elevatesoft.com

Thank You Very Much