Re: Using cx_Oracle 6.0rc1 on Windows

Anthony Tuininga <[email protected]> Wed, 5 Jul 2017 11:00:23 -0600
Newsgroups gmane.comp.python.db.cx-oracle
Message-ID <CAE1XR-5BFh3BUuaJFy3Qt2mKJcsV7B=gMxTc2qN6T9Jj5Nq6fw@mail.gmail.com>
--===============0248923074750324455==
Content-Type: multipart/alternative; boundary="94eb2c184f58a674c1055394ef2b"

--94eb2c184f58a674c1055394ef2b
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, Jul 5, 2017 at 10:19 AM, Walter D=C3=B6rwald <[email protected]=
>
wrote:

> On 5 Jul 2017, at 16:21, Anthony Tuininga wrote:
>
> [...]
>>> "%1 ist keine zul=C3=B5ssige Win32-Anwendung" (which should read "%1 is=
t keine
>>> zul=C3=A4ssige Win32-Anwendung", i.e. the "=C3=B6" should be an "=C3=A4=
") means "%1 is
>>> not
>>> an acceptable win32 application".
>>>
>>> So we don't see the real problem because cx_Oracle fails to create the
>>> proper Unicode string from the OS error message.
>>>
>>> It's not clear what encoding this is (probable latin-1 or cp1252, but
>>> definitely *not* UTF-8). A
>>>
>>>    grep 'xe4.*LATIN SMALL LETTER A WITH DIAERESIS' Lib/encodings/*.py
>>>
>>> in the Python source code returns 40 encodings that map the byte 0xE4 t=
o
>>> =C3=A4.
>>>
>>> If the correct encoding can't be determined from the environment it mig=
ht
>>> be best to use a less strict error handling (like e.g. backslashreplace=
)
>>> when decoding the bytes of the error message.
>>>
>>>
>> Thanks, Walter. This is very helpful. We'll have to see what makes the
>> most
>> sense in this case. Do you see information in the event log regarding th=
is
>> error?
>>
>
> Where can we find this event log?


Search for "Event Viewer". Its a long shot but sometimes errors are
displayed there as well, and sometimes they even are useful! :-)

>
>
> [...]
>>
>
> Servus,
>    Walter
>
> ------------------------------------------------------------
> ------------------
> 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
>

--94eb2c184f58a674c1055394ef2b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_extra"><div class=3D"gmail_quote">On W=
ed, Jul 5, 2017 at 10:19 AM, Walter D=C3=B6rwald <span dir=3D"ltr">&lt;<a h=
ref=3D"mailto:[email protected]" target=3D"_blank">[email protected]=
e</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote" style=3D"margi=
n:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On 5 Jul 2017, at=
 16:21, Anthony Tuininga wrote:<br>
<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex"><blockquote class=3D"gmail_quote" style=3D"m=
argin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
[...]<span class=3D""><br>
&quot;%1 ist keine zul=C3=B5ssige Win32-Anwendung&quot; (which should read =
&quot;%1 ist keine<br>
zul=C3=A4ssige Win32-Anwendung&quot;, i.e. the &quot;=C3=B6&quot; should be=
 an &quot;=C3=A4&quot;) means &quot;%1 is not<br>
an acceptable win32 application&quot;.<br>
<br>
So we don&#39;t see the real problem because cx_Oracle fails to create the<=
br>
proper Unicode string from the OS error message.<br>
<br>
It&#39;s not clear what encoding this is (probable latin-1 or cp1252, but<b=
r>
definitely *not* UTF-8). A<br>
<br>
=C2=A0 =C2=A0grep &#39;xe4.*LATIN SMALL LETTER A WITH DIAERESIS&#39; Lib/en=
codings/*.py<br>
<br>
in the Python source code returns 40 encodings that map the byte 0xE4 to =
=C3=A4.<br>
<br>
If the correct encoding can&#39;t be determined from the environment it mig=
ht<br>
be best to use a less strict error handling (like e.g. backslashreplace)<br=
>
when decoding the bytes of the error message.<br>
<br>
</span></blockquote><span class=3D"">
<br>
Thanks, Walter. This is very helpful. We&#39;ll have to see what makes the =
most<br>
sense in this case. Do you see information in the event log regarding this<=
br>
error?<br>
</span></blockquote>
<br>
Where can we find this event log?</blockquote><div><br></div><div>Search fo=
r &quot;Event Viewer&quot;. Its a long shot but sometimes errors are displa=
yed there as well, and sometimes they even are useful! :-)=C2=A0</div><bloc=
kquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #cc=
c solid;padding-left:1ex"><div class=3D"HOEnZb"><div class=3D"h5"><br>
<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">
[...]<br>
</blockquote>
<br>
Servus,<br>
=C2=A0 =C2=A0Walter<br>
<br>
------------------------------<wbr>------------------------------<wbr>-----=
-------------<br>
Check out the vibrant tech community on one of the world&#39;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></div>

--94eb2c184f58a674c1055394ef2b--


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

--===============0248923074750324455==--