Re: [cx-oracle-users] Using cx_Oracle 6.0rc1 on Windows

[Anthony T. <ant...@gm...>]

Thanks, Chris. If anyone getting this issue is able to build cx_Oracle
themselves, please do so with the environment variable DPI_DEBUG_LEVEL set
to the value 7 and report the results here or in a GitHub issue. Thanks!

Anthony



On Thu, Jun 29, 2017 at 6:54 AM, Christopher Jones <
chr...@or...> wrote:

> Do you have the right VS Redistributable?   With Oracle 11.2 client
> libraries you need the VS 2005 Redistributable.
>
> Related info is in https://github.com/oracle/node
> -oracledb/blob/dev-2.0/INSTALL.md#75-install-the-visual-
> studio-redistributable
> and https://github.com/oracle/python-cx_Oracle/issues/43
>
> Chris
>
>
> On 29/6/17 8:39 pm, Walter Dörwald wrote:
>
>> Hello all!
>>
>> We're trying to use the new cx_Oracle 6.0 on Windows and have the
>> following problem:
>>
>>     (default) C:\>pip install --no-cache-dir cx_Oracle==6.0rc1
>>     Collecting cx_Oracle==6.0rc1
>>       Downloading cx_Oracle-6.0rc1-cp36-cp36m-win_amd64.whl (210kB)
>>         100% |████████████████████████████████| 215kB 2.7MB/s
>>     Installing collected packages: cx-Oracle
>>     Successfully installed cx-Oracle-6.0rc1
>>
>>     (default) C:\>python
>>     Python 3.6.0 (v3.6.0:41df79263a11, Dec 23 2016, 08:06:12) [MSC v.1900
>> 64 bit (AMD64)] on win32
>>     Type "help", "copyright", "credits" or "license" for more information.
>>    >>> import cx_Oracle
>>     Traceback (most recent call last):
>>       File "<stdin>", line 1, in <module>
>>     UnicodeDecodeError: 'utf-8' codec can't decode byte 0xe4 in position
>> 66: invalid continuation byte
>>    >>>
>>
>> This is on Windows 10 Home. The Python version is the one that you get
>> when you install Visual Studio 2017 with the Python development workload.
>> The Oracle version is an Oracle 11 XE. ORACLE_HOME points to
>> c:\oraclexe\app\oracle\product\11.2.0\server
>>
>> The Oracle installation itself seems to be working:
>>
>>     (default) C:\>sqlplus
>>
>>     SQL*Plus: Release 11.2.0.2.0 Production on Do Jun 29 11:49:53 2017
>>
>>     Copyright (c) 1982, 2010, Oracle.  All rights reserved.
>>
>>     Enter user-name: sys/pwd as sysdba
>>
>>     Connected to:
>>     Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
>>
>>     SQL> exit
>>     Disconnected from Oracle Database 11g Express Edition Release
>> 11.2.0.2.0 - Production
>>
>> This seems to be a problem related to encoding, but changing NLS_LANG
>> from GERMAN_GERMANY.AL32UTF8 to GERMAN_GERMANY.WE8IOS8859P1 doesn't change
>> anything.
>>
>> Any help with getting cx_Oracle running would be appreciated.
>>
>> Servus,
>>     Walter
>>
>> --
> http://twitter.com/ghrd
>
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>