cx_Oracle的安裝及問題說明

1、下裝cx_Oracle的安裝程式 http://cx-oracle.sourceforge.net/

 

2、要下載instantclient-basic-win32-10.2.0.5.zip 注意有兩個版本，一相版本的體積比較小，但在隻支援en

     所以要下instantclient-basic-win32-10.2.0.5.zip這個

 

3、instantclient-basic-win32-10.2.0.5.zip解壓出來的檔案(oci.dll)copy到python安裝目錄D:/Program Files/Python26/Lib/site-packages下

 

4、 ORA-12705錯誤解決

Error message:

cx_Oracle.DatabaseError: ORA-12705: Cannot access NLS data files or invalid environment specified

Solution:
1. import os
 os.environ['NLS_LANG'] = 'TRADITIONAL CHINESE_TAIWAN.ZHT16MSWIN950'
2. Add an evironment variable:
Name: NLS_LANG
Value: TRADITIONAL CHINESE_TAIWAN.ZHT16MSWIN950
3. reopen the console

I don't know which one between 1 or 2 takes effects after reopening the console.  It, however, is solved after the above steps.

 

最言主要的應該是增加環境變量NLS_LANG = 'TRADITIONAL CHINESE_TAIWAN.ZHT16MSWIN950'