Today, the program I wrote is put on the client's machine, and the SelectedCollatingSequenceNotSupported80004005 error occurs as soon as it is run. After google, the solution is as follows.
Today, the program I wrote is put on the client's machine, and the Selected Collating Sequence Not Supported 80004005 error occurs as soon as it is run. After google, the solution is as follows.
Cause:
Access on my computer uses Chinese as the database sorting language. The customer's machine is not converted to Chinese, so adodb cannot use the access database normally. It is impossible for the customer to install Chinese characters on all of his computers, so it is only possible for me to solve the problem.
Solution:
1. Open the database with access;
2. Select Tools> Options from the menu;
3. In Options, select the General page;
4. On the General page, there is an option: New Database Sort Order to set its value to General, and then press OK.
5. Select Tools> Database Utilities> Compact and Repair Database from the menu;
6. Solve the problem.