I'm working on my first data project with EWB using an ElevateDB database. I've never done a unicode database before and it sounds like that's what I need for EWB at this point, so I thought I'd give it a try. I successfully created a unicode database using the ElevateDB manager(unicode) and I can read it just fine from the EWB application.

Now I'm trying to create a delphi application that reads this same database and I'm getting the error message #100 indicating the encryption password doesn't match and that might be a result of the character sets not matching. (this might be a question for the EDB bullitan board but EWB kind of let me to it). From my searches I  can see that this is probably a unicode/ansii mixup.

On my delphi application I normally drop a EDBSession, EDBDatabase, and EDBQuery components onto my form and set the "LocalConfigPath" to the correct folder. But when I run a SQL Query using the EDBQuery component I get the error #100.  I dropped a EDBEngine Component onto the form and looked through the properties thinking there is some sort of ANSI/Unicode switch. I guess I thought this information would be contained in the config folder so I wouldn't need to use the EDBEngine component.

If the problem is the ANSI vs Unicode I don't see a way to tell the components which to use. The session type is stLocal and the LocalConfigPath is correct.

Thanks for any help - trying to work on this database from both Delphi and EWB applications.

Jeff

<<
Jeff Newlin wrote:

If the problem is the ANSI vs Unicode I don't see a way to tell the components which to use. The session type is stLocal and the LocalConfigPath is correct.

>>

You need to make sure you have the unicode version of components installed in delphi - the components have separate installers for ansi vs unicode. Both edbmanager executables are included in the additional softare installer.

Raul

I see. Well I want to keep my ANSI components on my IDE so I guess I'll wait for Tim to do what he's going to do as far as using the ANSI with EWB - plenty of other things to experiment with.
Thanks!
jeff




Raul wrote:


<<
Jeff Newlin wrote:

If the problem is the ANSI vs Unicode I don't see a way to tell the components which to use. The session type is stLocal and the LocalConfigPath is correct.

>>

You need to make sure you have the unicode version of components installed in delphi - the components have separate installers for ansi vs unicode. Both edbmanager executables are included in the additional softare installer.

Raul

Jeff,
> I see. Well I want to keep my ANSI components on my IDE so I guess I'll wait for Tim to do what he's going to do as far as using the ANSI with EWB - plenty of other things to experiment with.

No need to wait: you can use an ANSI database with EWB without problems.
Just the dataset manager only works with UNICODE.

You can load the columns of a dataset also by using the dataset columns
editor.

Regards Uli