Re: Using cx_Oracle 6.0rc1 on Windows
Anthony Tuininga <[email protected]> Thu, 29 Jun 2017 14:30:40 -0600
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <CAE1XR-6K0OD4McG2=652ue2uOyqCV=wCfauiCJtoGJ0itpeaQg@mail.gmail.com> |
--===============8156237621617655470== Content-Type: multipart/alternative; boundary="94eb2c13a1469aea3b05531f2c9e" --94eb2c13a1469aea3b05531f2c9e Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 < [email protected]> 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=C3=B6rwald 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=3D=3D6.0rc1 >> Collecting cx_Oracle=3D=3D6.0rc1 >> Downloading cx_Oracle-6.0rc1-cp36-cp36m-win_amd64.whl (210kB) >> 100% |=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2= =96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96= =88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88= =E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2= =96=88| 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.190= 0 >> 64 bit (AMD64)] on win32 >> Type "help", "copyright", "credits" or "license" for more informatio= n. >> >>> 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 chan= ge >> 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-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > --94eb2c13a1469aea3b05531f2c9e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr">Thanks, Chris. If anyone getting this issue is able to bui= ld cx_Oracle themselves, please do so with the environment variable DPI_DEB= UG_LEVEL set to the value 7 and report the results here or in a GitHub issu= e. Thanks!<div><br></div><div>Anthony<br><div><br></div><div><br></div></di= v></div><div class=3D"gmail_extra"><br><div class=3D"gmail_quote">On Thu, J= un 29, 2017 at 6:54 AM, Christopher Jones <span dir=3D"ltr"><<a href=3D"= mailto:[email protected]" target=3D"_blank">christopher.jones@or= acle.com</a>></span> wrote:<br><blockquote class=3D"gmail_quote" style= =3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Do you h= ave the right VS Redistributable?=C2=A0 =C2=A0With Oracle 11.2 client libra= ries you need the VS 2005 Redistributable.<br> <br> Related info is in <a href=3D"https://github.com/oracle/node-oracledb/blob/= dev-2.0/INSTALL.md#75-install-the-visual-studio-redistributable" rel=3D"nor= eferrer" target=3D"_blank">https://github.com/oracle/node<wbr>-oracledb/blo= b/dev-2.0/INSTALL<wbr>.md#75-install-the-visual-<wbr>studio-redistributable= </a><br> and <a href=3D"https://github.com/oracle/python-cx_Oracle/issues/43" rel=3D= "noreferrer" target=3D"_blank">https://github.com/oracle/pyth<wbr>on-cx_Ora= cle/issues/43</a><br> <br> Chris<div><div class=3D"h5"><br> <br> On 29/6/17 8:39 pm, Walter D=C3=B6rwald wrote:<br> <blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p= x #ccc solid;padding-left:1ex"> Hello all!<br> <br> We're trying to use the new cx_Oracle 6.0 on Windows and have the follo= wing problem:<br> <br> =C2=A0 =C2=A0 (default) C:\>pip install --no-cache-dir cx_Oracle=3D=3D6.= 0rc1<br> =C2=A0 =C2=A0 Collecting cx_Oracle=3D=3D6.0rc1<br> =C2=A0 =C2=A0 =C2=A0 Downloading cx_Oracle-6.0rc1-cp36-cp36m-wi<wbr>n_amd64= .whl (210kB)<br> =C2=A0 =C2=A0 =C2=A0 =C2=A0 100% |=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2= =96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96= =88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88= =E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88=E2=96=88<wb= r>=E2=96=88=E2=96=88=E2=96=88| 215kB 2.7MB/s<br> =C2=A0 =C2=A0 Installing collected packages: cx-Oracle<br> =C2=A0 =C2=A0 Successfully installed cx-Oracle-6.0rc1<br> <br> =C2=A0 =C2=A0 (default) C:\>python<br> =C2=A0 =C2=A0 Python 3.6.0 (v3.6.0:41df79263a11, Dec 23 2016, 08:06:12) [MS= C v.1900 64 bit (AMD64)] on win32<br> =C2=A0 =C2=A0 Type "help", "copyright", "credits&q= uot; or "license" for more information.<br> =C2=A0 =C2=A0>>> import cx_Oracle<br> =C2=A0 =C2=A0 Traceback (most recent call last):<br> =C2=A0 =C2=A0 =C2=A0 File "<stdin>", line 1, in <module&= gt;<br> =C2=A0 =C2=A0 UnicodeDecodeError: 'utf-8' codec can't decode by= te 0xe4 in position 66: invalid continuation byte<br> =C2=A0 =C2=A0>>><br> <br> 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 O= racle version is an Oracle 11 XE. ORACLE_HOME points to c:\oraclexe\app\ora= cle\product<wbr>\11.2.0\server<br> <br> The Oracle installation itself seems to be working:<br> <br> =C2=A0 =C2=A0 (default) C:\>sqlplus<br> <br> =C2=A0 =C2=A0 SQL*Plus: Release 11.2.0.2.0 Production on Do Jun 29 11:49:53= 2017<br> <br> =C2=A0 =C2=A0 Copyright (c) 1982, 2010, Oracle.=C2=A0 All rights reserved.<= br> <br> =C2=A0 =C2=A0 Enter user-name: sys/pwd as sysdba<br> <br> =C2=A0 =C2=A0 Connected to:<br> =C2=A0 =C2=A0 Oracle Database 11g Express Edition Release 11.2.0.2.0 - Prod= uction<br> <br> =C2=A0 =C2=A0 SQL> exit<br> =C2=A0 =C2=A0 Disconnected from Oracle Database 11g Express Edition Release= 11.2.0.2.0 - Production<br> <br> This seems to be a problem related to encoding, but changing NLS_LANG from = GERMAN_GERMANY.AL32UTF8 to GERMAN_GERMANY.WE8IOS8859P1 doesn't change a= nything.<br> <br> Any help with getting cx_Oracle running would be appreciated.<br> <br> Servus,<br> =C2=A0 =C2=A0 Walter<br> <br> </blockquote> -- <br> </div></div><a href=3D"http://twitter.com/ghrd" rel=3D"noreferrer" target= =3D"_blank">http://twitter.com/ghrd</a><div class=3D"HOEnZb"><div class=3D"= h5"><br> <br> ------------------------------<wbr>------------------------------<wbr>-----= -------------<br> Check out the vibrant tech community on one of the world's most<br> engaging tech sites, Slashdot.org! <a href=3D"http://sdm.link/slashdot" rel= =3D"noreferrer" target=3D"_blank">http://sdm.link/slashdot</a><br> ______________________________<wbr>_________________<br> cx-oracle-users mailing list<br> <a href=3D"mailto:cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org" target=3D"_blank">= [email protected]<wbr>rge.net</a><br> <a href=3D"https://lists.sourceforge.net/lists/listinfo/cx-oracle-users" re= l=3D"noreferrer" target=3D"_blank">https://lists.sourceforge.net/<wbr>lists= /listinfo/cx-oracle-users</a><br> </div></div></blockquote></div><br></div> --94eb2c13a1469aea3b05531f2c9e-- --===============8156237621617655470== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot --===============8156237621617655470== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ cx-oracle-users mailing list cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org https://lists.sourceforge.net/lists/listinfo/cx-oracle-users --===============8156237621617655470==--