Re: Help! 7.14 on HP 10.10 / 7203 ISAM 117

Kate_Tomchik@HomeDepot.COM wrote: > > We are getting the following errors when we try to select a database from > dbaccess: > > -7203 DBNLS is not set or LC_COLLATE must be category-value. > > This message may be returned when you try to access an external > database that has a different locale than the current database. In > order to use this NLS database, you must set the DBNLS environment > variable to 1 or 2 and the LC_COLLATE environment variable to the > specified category-value. > > -117 ISAM error: bad custom collating sequence. > > This message is not displayed by any current Informix product. If > the error recurs, please note all circumstances and contact the > Informix Technical Support Department. > > What does this mean? Any suggestions on how to help? This probably means that your database was created the following environment variables set: LANG=xx_xx and DBNLS=1. If LANG is set to something like en_US the set DBNLS to 2 and try and connect again. NLS information is stored in the database at creation time when DBNLS is set to 1. You can find the information in the systables table where tabid = 90 and 91. best regards -- +-------------------------------------------------------------+ | Claus Samuelsen Sysdeco Danmark A/S | | Project Manager Gydevang 22B | | email: csa@sysdeco.dk DK-3450 Aller'd | | phone: +45 4814 3000 Denmark | +-------------------------------------------------------------+