Error 7147, weird behaviour

[marcus_herz]

Hi.

I get the error 7147 when I try to open an ADT table. This is the script to reproduce the error:

Create a dictionary and then execute

create table test(
Name1 char(10),
Name2 char(10)) IN DATABASE;

select * into testcopy from test;

You get the table testcopy. When you try to open the table by double klick in the explorer, a new instance of arc32 is started trying to open this table (which is the same as when you open the table via ACE api). You get this error:

Collation name could not be found.....

The error also occurs when you drag the table onto arc32.

This did work with version 11.

But you can execute a

select * from testcopy;

and this works.

[michael_loop]

Sorry, I didn't see your most recent post until now. You should be able to attach a file directly to this thread, using the paperclip icon. Be sure that the table contains only sample data.

[marcus_herz]

Hi

How can I send you an example of an ADT file that is created and that I cannot open with Vers 12 ?

[michael_loop]

I did try your sample, and I could not recreate the problem. I have just tried again with German settings, and still I do not see the problem.

If you click on ANSI in the connection properties, you will see ellipsis (...) at the end of the field. Click on the ellipsis and you will see the ADSCollation Generator. By default, ADS Character Type is ANSI, Unicode Locale is blank, and Unicode Case Insensitive Search is unchecked. Are any of these value diifferent for you?

[michael_loop]

Which collations are reported by the .add?

Which collations are configured in ADS (assuming you are using remote connections)?

Are the files: adscollate.adt, adscollate.adm, aicu32.dll, ansi.chr, extend.chr and icudt40l.dat present in your ARC 12 directory?

[marcus_herz]

The ARC installation is complete with all DLLs for all collations. (Otherwise I would not be able to open my ADD.)

The server setting for ANSI is GERMAN,

The collation in the add is ANSI.

Didi you try my sample? Can you recreate the behaviour?

[marcus_herz]

Fine, but how do I set a collation? If I open a ADD, the collation is defined in the settings. But still I cannot open the temporary file! but all others!

The ads_err only shows 7147, not even a filename.

The same temp file can be opened by arc32 vers 11.10.0.22 without 7147.

Seems there is a problem with ver 12

[michael_loop]

The help file has this to say about error 7147:

Problem: An attempt to load a dynamic collation failed because the given collation name was not found.

Solution: Verify that the correct collation name was specified in the application. The error log (ads_err.adt or ads_err.dbf) entry for this error will show the name that was being searched for.

Do your error logs indicate which collation is being called?