There are times when the program cannot be launched 1C, and the window appears 1C with a message "The sort order set for the database is different from!".
After closing the window, the program closes (you can start it in the mode Configurator).
Cause of error and solutions
The reason for the error – mismatch between settings and settings 1C.
By the way, if the operating system is localized and the regional settings are set correctly, then during installation 1C its settings will be brought in line with.
Checking the correctness of the settings
I. settings(for a localized Russian version Windows)
1. Open Start – > Customization –> Control Panel –> language and regional standards.
2. On the tab Regional options the dropdown should contain – Russian.
3. On the tab Languages – > More… – window Text Input Languages and Services –> tab Parameters – > Input language should be – > Russian-Russian.
4. On the tab Additionally should be –> Russian.
II. 1C settings
1. Start the program 1C... In the window Launch 1C
2. In the drop-down list In the mode choose Configurator –> OK.
3. It will start Configurator... Select the menu Administration –> Code page for information security tables…
4. In the window the dropdown should contain –> 1251 – > Russian, Belarusian, Bulgarian and Serbian languages.
Notes (edit)
1. If you are using the component (distributed infobase management), – when checking sort order is disabled, – You SHOULD NOT use symbols of any alphabets other than Latin in the three-letter identifier of infobases that are part of a distributed database.
2. Please be aware that disabling checking the identity of the sort order may result in unexpected – for the 1C program! – the order of the lines, for example, when generating reports.
Eliminating the error in Windows Vista and Windows 7+
If you are using Windows Vista and Windows 7+ , then get rid of the message "The sort order set for the database is different from the system!" the above methods will fail.
We'll have to go the other way:
1. Start the program 1C... In the window Launch 1C select the required infobase.
2. In the drop-down list In the mode choose Configurator – > OK.
3. It will start Configurator... Select the menu Administration – > Code page for information security tables…
4. In the window Infobase tables code page in the dropdown list select + Current installation – > OK.
Despite the reluctance of corporate users to say goodbye to Windows XP, it is becoming clear that it will still have to be done in the near future. Therefore, there will be a need to launch 1C Enterprise 7.7 in the Windows 7 (Vista) environment. In this article, we decided to consider the "typical" problems that arise when 1C works in a new OS environment, and how to solve them.
Error "data sort order differs from the system one"
Probably only the lazy does not know about this error, as well as about the way to solve it. However, not everything is as simple as it seems, so we will consider this issue in more detail.
The reason for the error is trivial - a mismatch between the OC code pages of the NT6 family and 1C. There are two ways to solve this problem:
- Bring the IS code page in accordance with the system one. To do this, run Configurator - Administration - IS code page and at the very bottom of the drop-down list, select + Current system setting... This is the most correct way, but after bringing the base into compliance with the code page of Windows 7 (Vista), we will begin to receive the same error when starting the base in Windows XP.
- Disable sort order checking. To do this, create a signal file named ordnochk.prm(). When placed in a directory with IB, it disables sort order checking for this database, when it is placed in the directory BIN(in the 1C installation folder) sorting check will be disabled for all databases on this PC. This method works only with release 26 and higher... In addition, 1C warns:
"The use of this feature can only be recommended in extreme cases when it is not possible to match the system sorting order with the sorting order set for the infobase. Latin, in the three-letter identifier of the infobases that are part of the distributed one.It should be borne in mind that 1C: Enterprise uses the ability to sort both mechanisms during its work, and disabling the verification of the order identity in them can lead to an unexpected order of strings for the user, for example, when generating reports. "
Which way to choose? If you have a homogeneous OS park, i.e. all machines work under Windows 7 (Vista), then the first option should definitely be used. The second option should be used when it is necessary to work simultaneously with databases under both OS families. In this case, it is advisable to locate the databases on a machine with Windows XP, and ordnochk.prm put in the BIN folder on a Windows 7 (Vista) machine. This will avoid potential problems with the operation of components such as URIB. It should be remembered that a machine with Windows 7 (Vista) can be used only to work in 1C Enterprise mode. Any changes in the Configurator mode must be made only on a Windows XP machine. When the bases are located on a machine with Windows 7 (Vista) necessarily you should bring the IS code page to the system one (according to the first method), and ordnochk.prm use already on machines with Windows XP, otherwise work with URIB or simply loading previously uploaded data into IB will be impossible.
Error creating from component V7Plus.dll (Missing CLSID)
This problem occurs when UAC is enabled, when accessing external processing or other actions that require the library V7Plus.dll(uploading data, reports, etc.), while V7Plus.dll present in the directory with the base. The reason for the error is that 1C Enterprise registers this library dynamically, when it becomes necessary to use it. When UAC is enabled, 1C works with user rights and therefore cannot register the library. The solution is simple - register V7Plus.dll manually, for this we recommend copying it to the BIN folder (so as not to be tied to a specific database), run Command line with administrator rights and execute the command:
Regsvr32<путь к 1С>\ BIN \ V7Plus.dll
the result of execution should be a message about successful registration of the library.
Error "To access the database, an ODBC driver for MS SQL Server version 3.50.0303 or later is required
The error occurs when you try to run SQL version 1C Enterprise 7.7 on Windows 7 (Vista) and consists in the lack of support for these OS versions of SQL server below SQL Server 2005 SP2... Excerpt from Microsoft Official Press Release:
For enhanced security, Microsoft Windows Server 2008 and Microsoft Windows Vista will support SQL Server 2005 Express Service Pack 1 (SP1), while all other SQL Server editions will require SQL Server 2005 Service Pack 2 (SP2) or later. Earlier versions of SQL Server, including SQL Server 2000(all editions including the Desktop Engine edition aka MSDE), SQL Server 7.0 and SQL Server 6.5, Windows Server 2008 and Windows Vista will not be supported.
Solutions to date does not exist(and it is unlikely to appear). The "solution" found on the Internet with replacing the ODBC driver files with files from Windows XP should not be seriously considered and it is strongly discouraged to use it.
Alternatively, we recommend running 1C Enterprise on Windows Server 2003 in terminal mode, we recommend the same option for 1C file mode in a network with different versions of Windows.
There are times when the 1C program cannot be started, and the 1C dialog box appears with the message "The sorting order set for the database differs from the system one!" After closing the window, the program closes (you can start it in the Configurator mode).
Valery Sidorov
Cause of error and solutions
The cause of the error is a mismatch between system settings and 1C settings.
By the way, if the operating system is localized and the regional settings are set correctly, then when installing 1C, its settings will be brought in line with the system settings.
Checking the correctness of the settings
I. System settings (for localized Russian version of Windows)
1. Open Start - Settings - Control Panel - Regional and Language Options.
2. On the Regional Options tab, the drop-down list should be - Russian.
3. On the Languages tab - More ... - the Languages and text input services dialog box - the Options tab - The default input language should be - Russian-Russian.
4. On the Additional tab there should be - Russian.
II. 1C settings
4. In the Code page of infobase tables window, the drop-down list should contain - 1251 - Russian, Belarusian, Bulgarian and Serbian languages.
Notes (edit)
1. If you are using the URIB (distributed infobase management) component, if the sort order check is disabled, you SHOULD NOT use any alphabets other than Latin in the three-letter identifier of infobases included in the distributed database.
2. It should be borne in mind that disabling the verification of the identity of the sort order can lead to something unexpected - for the user of the 1C program! - the order of the lines, for example, when generating reports.
Troubleshoot Windows Vista error
If you are using Windows Vista, then get rid of the message "The sort order set for the database is different from the system!" the above methods will fail.
For this:
1. Start the 1C program. In the Launch 1C window, select the required infobase.
2. In the In mode drop-down list select Configurator - OK.
3. The Configurator will start. Select the Administration menu - IB tables code page ...
4. In the Codepage of infobase tables window, in the drop-down list, select + Current system setting - OK.
5. In the Configurator window with the message “When changing the code page, the indexes of all data tables of the infobase will be rebuilt! Do you want to change the code page? " click Yes.
6. After a certain period of time, depending on the size of the IB, the Configurator window will appear with the message “Code page changed!”, Click OK.
7. Close the Configurator, you can work with the infobase.
8. To work with other information security systems, change the code page of the information security tables in the same way.
When loading data into the 1C 7.7 database in MS SQL format through the configurator, an error occurs:
"The sort order set for the database is different from the system one!"
And this is provided that we have crammed the OrdNoChk.prm file into all places, which cancels the encoding check.
I hasten to note that this error cannot be overcome on the system configuration of Windows Server 2008 R2 and MS SQL Server 2008. Old 1C 7.7 does not understand how to behave with these monsters. Therefore, you can upload data to 1C 7.7 only on MS SQL Server 2000 (2005). And then transfer the sql database to MS SQL Server 2008. This procedure is usually used when converting a database from DBF format to MS SQL format.
So, we are working with MS SQL Server 2000. Version 1C: 7.7.027. To fix the error, you need to change the file using the HEX editor. BkEnd.dll which is in the directory BIN 1C programs.
A free PSPad editor can be used as a HEX editor. Open the editor: File - Open in a HEX editor. Open our file BkEnd.dll.
In the menu, select "Search" - "Go to line". And go to the address $ 0018A79D. Change the value "75" to "EB". We are saved. 
We repeat loading data into 1C. At the end of the download, a transaction error may appear - do not pay attention to it. 
In the 1C database directory, you need to delete the file 1srecalc... This file may remain after recalculation of accounting totals and the program will try to recalculate them each time.
At the moment, few people use 1C version 7.7, but still there are organizations that, for one reason or another, cannot switch to newer platforms. In my practice, I have not seen configurations written in 7.7 for a long time. But more recently, I had to deal with 7. In the process, I ran into this problem. When running on different versions of Windows, the same error appears all the time. Namely, the sort order set for the databases differs from the system one. There are two ways to solve it, we will analyze each of them in more detail.
How to disable 1c code page check
Changing the code table
The easiest way is to change the code page in the 1C program. To do this, run the program in the configurator mode. Next, go to Administration - Code page of IB tables.
In the window that appears, select + Current system setting and click OK.
After that, the program should start, but there is one caveat if users work in this configuration with different operating systems, such as Windows XP and Windows 7, then when starting on a different version, you will need to do similar actions every time.
Disable code page validation
This way is much better and easier. You can disable the code page check in 1C. To do this, create a file named ordnochk.prm and place it in the program folder along this path C: \ Program Files \ 1Cv77 \ Bin. If you do not have the Bin directory, upload the file to the directory above. C: \ Program Files \ 1Cv77 \
The 1C program lies with me in a different way; do not pay attention to this. That's all if something didn't work out, write in the comments I'll try to answer and help everyone.
