优势数据库索引排序顺序 [英] Advantage Database Index Collation Sequence

问题描述

我正在将Delphi程序从BDE转换为Advantage数据库。

周末，我使用Delphi XE在Win 7机器上工作。在一周内，我使用Delphi 7在Win XP机器上工作。

优势表在Win 7机器上工作正常，但复制到XP机器时无法访问 - 错误5175索引是用不同的归类序列创建的。

我已经搜索到网络，甚至进入了优势论坛，但找不到任何帮助。

XP和Win 7都设置与位置相同。表属性将排序规则序列列为空白。 / p>

任何人都知道是什么导致这个和如何解决。我尝试删除并重新创建索引，但无效。

解决方案

用于创建或打开索引文件的排序规则序列取决于您正在连接的远程服务器或本地服务器配置的归类顺序。

对于 Advantage本地服务器（ALS）可以在 adslocal.cfg 配置文件。

必须重新安装专用的 Advantage数据库服务器（ADS）才能更改归档，因为安装程序将整理烘烤到服务器可执行文件中（至少在我知道的情况下）。

除此之外，不同操作系统的归类有所不同如果您在安装ADS组件时选择< CURRENT SYSTEM LANGUAGE> （或类似），则可以使用版本和操作系统语言。这在帮助中有所描述：

1. 强烈推荐使用第一个选项，并且是更容易的方法来确保所有连接的ANSI排序规则语言相同。安装Advantage数据库服务器和Advantage客户端时，请特别选择ANSI归类语言。确保为所有安装指定相同的ANSI语言。在Advantage客户端安装期间选择的ANSI归类语言将被放置在Advantage Local Server配置文件ADSLOCAL.CFG中。


2. 如果不希望使用上述选项1，请选择安装Advantage数据库服务器和Advantage客户端时的ANSI归类语言。只有当以下所有内容都为True时才选择。用于安装Advantage数据库服务器的所有计算机都应该运行相同的Windows操作系统。运行连接到Advantage Local Server的应用程序的计算机也应该运行相同的操作系统。除了操作系统相同之外，所有计算机都应使用相同的ANSI归类语言（通过区域设置图标指定）。

http：//devzone.advantagedatabase .com / dz / webhelp / advantage10 / master_avoiding_ansi_collat​​ion_mismatch_errors.htm

http://devzone.advantagedatabase.com/dz/webhelp/advantage10/index.html?error_5175_ae_index_collat​​ion_mismatch.htm

I am converting a Delphi program from the BDE to Advantage Database.

On weekends I work on a Win 7 machine using Delphi XE. During the week I work on a Win XP machine using Delphi 7.

Advantage tables work fine on the Win 7 machine but when copied to the XP machine they cannot be accessed - Error 5175 the index was created with a different collation sequence

I have searched the net, even gone into the Advantage forums but can't find anything helpful.

The XP and Win 7 are both set up the same as regards location etc. Table properties lists the collation sequence as blank.

Anyone know what is causing this and how to fix. I have tried dropping and recreating the indices but to no avail.

解决方案

The collation sequence that is used to create or open index files depends on what collation sequence is configured for the remote server or local server you are connecting to.

For Advantage Local Server (ALS) this can be set in the adslocal.cfg config file.

The dedicated Advantage Database Server (ADS) has to be reinstalled in order to change the collation, since the installer "bakes" the collation into the server executable (at least as far as I know).

In addition to that the collation is different on different OS versions and OS languages if you select <CURRENT SYSTEM LANGUAGE> (or similar) when you install the ADS components. This is described in the help:

1. This first option is strongly recommended and is the easier method to make sure the ANSI collation languages are the same for all connections. Specifically select an ANSI collation language when installing the Advantage Database Server and Advantage clients. Make sure to specify the same ANSI language for all installs. The ANSI collation language selected during an Advantage client install will be placed in the Advantage Local Server configuration file, ADSLOCAL.CFG.
2. If you do not wish to use option 1 above, select for the ANSI collation language when installing the Advantage Database Server and the Advantage clients. Only select if all of the following are True. All computers used for installation of the Advantage Database Server should be running the same Windows operating system. The computer running an application that connects to the Advantage Local Server should also be running this same OS. In addition to the operating systems being the same, all computers should be using the same ANSI collation language (which is specified via the Regional Settings icon).

http://devzone.advantagedatabase.com/dz/webhelp/advantage10/master_avoiding_ansi_collation_mismatch_errors.htm

http://devzone.advantagedatabase.com/dz/webhelp/advantage10/index.html?error_5175_ae_index_collation_mismatch.htm

这篇关于优势数据库索引排序顺序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！