I have a database, I try to open it with ElevateDB Manager and I found message 'ElevateDB Error #100', but if I can open it with ElevateDB Manager (Unicode). I use delphi 7, ElevateDB VCL-TRIAL - Version 2.03 Build 14 and I try to open that database and always found error message 'ElevateDB Error #100'. So, How to open unicode database with delphi 7? Thanks

Roy,

From your description it sounds like you created the database using a
unicode version of EDB Manager. If you try to open the database with a
non-unicode version of EDB Manager, you will get an error as the
metadata is different.

Having said that, Delphi 7 and ElevateDB for Delphi 7 do not support
unicode. You will have to use D2009 or D2010 to support unicode in your
applications. AFAIK, if you want to continue to use D7 you will have to
reconstruct your database again with a non-unicode version of EDB
Manager.

--
Jan Ferguson


roy wrote:

> I have a database, I try to open it with ElevateDB Manager and I
> found message 'ElevateDB Error #100', but if I can open it with
> ElevateDB Manager (Unicode). I use delphi 7, ElevateDB VCL-TRIAL -
> Version 2.03 Build 14 and I try to open that database and always
> found error message 'ElevateDB Error #100'. So, How to open unicode
> database with delphi 7? Thanks

Roy,

<< I have a database, I try to open it with ElevateDB Manager and I found
message 'ElevateDB Error #100', but if I can open it with ElevateDB Manager
(Unicode). I use delphi 7, ElevateDB VCL-TRIAL - Version 2.03 Build 14 and I
try to open that database and always found error message 'ElevateDB Error
#100'. So, How to open unicode database with delphi 7? Thanks >>

What Jan said is correct.  If you need to convert the Unicode database to
ANSI, see this thread:

http://www.elevatesoft.com/forums?action=view&category=edb&id=edb_general&page=1&msg=10794#10794

for more information on using IMPORT TABLE/EXPORT TABLE to move the data
over.

You can use the Unicode EDB Manager to reverse-engineer (Database
node/Reverse-Engineer Database task link) the existing Unicode database to
an SQL script that you can execute in the ANSI EDB Manager.  Be sure to set
the collation mapping so that the UNI collation references are mapped to
ANSI collation references in the generated script.

--
Tim Young
Elevate Software
www.elevatesoft.com