ORA-12737: Instant Client Light: unsupported server character set %s
来源:互联网 发布:杭州知乎电子有限公司 编辑:程序博客网 时间:2024/06/06 03:19
Question:
I am trying to connect to oracle db without full installation of oracle client done on the machine. I found this helpfull post Using the new ODP.Net to access Oracle from C# with simple deployment but when I try it, I am failed on the next exception:
[Oracle.DataAccess.Client.OracleException ORA-12737: Instant Client Light: unsupported server character set %s at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src) ...
Answer:
I had the same problem and google says the solution is 'some_big_oracle_package' installation, but I want to keep this away. So simply unpacked all dll files from ODAC112012Xcopy.zip 32bit (xcopy version ONLY). And it works! So I had to found the mysterious dll that pushed it to the next level. The one & only is
oraociei11.dll
On my working-portable solution catalog I have .exe file and 4 dlls:
- oci.dll,
- Oracle.DataAccess.dll (version 2.112.1.2),
- OraOps11w.dll
- oraociei11.dll
This stuff works on Win7 x86 & x64 and WinXP x86 (all the systems don't have Oracle or sth installed, pure copy & paste). Notice that oraociei11.dll weighs 120MB! After compression ~40MB
注:ODAC112012Xcopy.zip 32bit (xcopy version ONLY),dll文件通过搜索查找出来
- OraOps11w.dll用odp.net20文件夹里头的那个
- ORA-12737: Instant Client Light: unsupported server character set %s
- ORA-12737:Instant Client Light:unsupported server character set ZHS16GBK
- ORA-12737: Instant Client Light: unsupported server character set CHS16GBK
- ORA-12737:Instant Client Light:unsupported server character set ZHS16GBK
- ora-123737:instant client light:unsupported server character set zhs16gbk
- Navicat连接Oracle 报 ORA-12737(ORA-12737: Instant Client Light: unsupported server character set CHS16)
- Navacat连接字符集问题ORA-12737:Instant Client Light:unsupported server character set ZHS16GBK
- navicat连接oracle报错:ORA-12737 Instant Client Light:unsupported server character set ZHS16GBK
- navicat连接oracle报错ORA-12737: Instant Client Light: unsupported server character set CHS16GBK”
- Navicat连接oracle数据库报错:ORA-12737 Instant Client Light:unsupported server character set ZHS16GBK
- ORA-12737 navicat连接oracle报错ORA-12737: Instant Client Light: unsupported server character set ZHS16GB
- ora-123737:instant client light:unsupported server character set zhs16gbk 关于navicat连接oracle
- 我们用Navacat连接Oracle数据库的时候,会提示ORA-12737:Instant Client Light:unsupported server character set ZHS16GBK
- navcat Instant Client Light: unsupported server character set CHS16GBK
- navicat连接oracle的错误:ora-12737:instant client light :unsupport server charater set ZHS16GBK解决办法。
- navicat连接oracle的错误:ora-12737:instant client light :unsupport server charater set ZHS16GBK解决办法。(oracle服务端字符集,客户端字符集,dmp备份文件字符集,or
- Navicat连接Oracle:unsupported server character set zhs16gbk
- [Sybase]Character set conversion is not available between client character set 'iso_1' and server character set 'cp936'.
- sqlmap
- c++ STL 基础使用
- spring mvc 框架搭建
- 我的OpenCV学习笔记(2):opencv中的模糊算法
- php json_decode 转换为空的解决方案一
- ORA-12737: Instant Client Light: unsupported server character set %s
- linux 学习笔记
- Workflow常见错误如何解决
- 【DB.PL/SQL】程序流程控制 —— 异常处理
- 【移动开发】Service类onStartCommand()返回值和参数
- 关注CSDN社区微信,更多精彩等你来
- cocos2d 坐标系使用
- Linux curl命令参数常用
- CreateThread函数