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

[Walter D. <wa...@li...>]

On 29 Jun 2017, at 22:30, Anthony Tuininga wrote:

> 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!

We have an Oracle 11 XE installation, so the VS Redistributables we need 
should be from VS 2005. dumpbin confirms this:

C:\Program Files (x86)\Microsoft Visual 
Studio\Shared\14.0\VC\bin\amd64_x86>dumpbin /dependents 
C:\oraclexe\app\oracle\product\11.2.0\server\bin\oci.dll
Microsoft (R) COFF/PE Dumper Version 14.00.24218.2
Copyright (C) Microsoft Corporation.  All rights reserved.


Dump of file C:\oraclexe\app\oracle\product\11.2.0\server\bin\oci.dll

File Type: DLL

   Image has the following dependencies:

     KERNEL32.dll
     MSVCR80.dll
     ADVAPI32.dll
     PSAPI.DLL

   Summary

         4000 .data
        1F000 .rdata
        17000 .reloc
         1000 .rsrc
        BF000 .text

According to

    https://github.com/oracle/node-oracledb/blob/dev-2.0/INSTALL.md#75-install-the-visual-studio-redistributable

MSVCR80.dll mean VS 2005.

However after downloading vcredist_x64.exe from

    https://www.microsoft.com/en-us/download/details.aspx?id=18471

the situation remains unchanged. Note that this page states:

    Supported Operating System

    Windows 2000, Windows 7, Windows Server 2003, Windows Server 2008,
    Windows Server 2008 R2, Windows Vista, Windows XP

Could this be the problem (as we're on Windows 10 Home)?

As you suggested, we will try compiling cx_Oracle from source next week.

Servus,
    Walter

> 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
>>