Selected collating sequence not supported by the operating system
来源:互联网 发布:java bigdecimal 乘法 编辑:程序博客网 时间:2024/05/16 09:17
用C#开发的一个软件,使用了Access数据库文件(mdb文件)作为后台数据库,之前的测试一直给予中文操作系统或者安装了中文语言包的英文操作系统,当今天将软件部署到纯英文操作系统后,抛出异常:“Selected collating sequence not supported by the operating system. ”。
非常感谢万能的网络以及无私的网络兄弟,最后终于找到了原因:中文版的Access默认的排序方式为按照拼音排序,而英文版的Windows操作系统不支持MDB文件默认的汉语拼音排序方式,所以导致错误。
解决方案(网上主要给出的Office2003下的解决办法,但Office2007的界面和菜单布局和Office2003很不相同,这里补充Office2007下的解决办法):
1、使用Access 2007打开出问题的MDB文件;
2、修改Access的默认排序方案:
将系统默认的“汉语拼音”排序修改为“常规”;
3、压缩数据库:
选定“压缩和修复数据库”,程序不会做任何提示,而且不需要再次保存,直接关闭Access,再放到英文操作系统下,该问题就已经解决了。
符:
转自网络的Office 2003的修改排序方法的设置页面【转自http://www.cnitblog.com/wufajiaru/archive/2009/07/18/43851.html】:
在修改完排序方法后的修复操作同Office 2007类似,菜单位置:工具->数据库常用工具->压缩和修复数据库。
- Selected collating sequence not supported by the operating system
- Selected collating sequence not supported by the operating system
- Access错误提示之"Selected collating sequence not supported by the operating system."
- 解决Access错误 Selected collating sequence not supported by the operating system
- [转]解决Access错误 Selected collating sequence not supported by the operating system
- 解决国外空间Access错误Selected collating sequence not supported by the operating system
- 解决国外空间Access错误Selected collating sequence not supported by the operating system
- Access数据库出现"Selected collating sequence not supported by the operating system."错误
- 国外空间ACCESS错误提示之:Selected collating sequence not supported by the operating system
- 国外空间Access错误Selected collating sequence not supported by the operating system
- 解决国外空间Access错误Selected collating sequence not supported by the operating system
- 关于Access提示Selected collating sequence not supported by the operating system错误
- 转[分享]解决Access错误 Selected collating sequence not supported by the operating system
- Access解决“Selected collating sequence not supported by the operating system”的方法
- Selected collating sequence not supported by the operating system vc6.0报错
- Access error:Selected Collating Sequence Not Supported
- ADODB连接access是出现“"Selected Collating Sequence Not Supported" or "Unrecognized Database Format" 80004005 ”错误
- Guest operating system ‘fedora’ is not supported.
- 如何判断一个图中是否存在回路
- 非虚继承类,虚继承类的sizeof分析--GCC编译器和VC编译器
- 如何判断一个图中是否存在回路
- windbg符号链接的问题.还有KeServiceDescriptorTableShadow内存块查找时问号的情况
- Host 'aeolus-PC2' is not allowed to connect to this MySQL server
- Selected collating sequence not supported by the operating system
- 如果理解oop
- Hadoop 实战之单词计数WordCount
- 长春赛 K题
- 输出星号图
- Android-Sensor应用解析
- 南阳理工之两点距离
- 从GRE数学题说起
- php 时间函数