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

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

On 12 Jul 2017, at 0:24, Anthony Tuininga wrote:

> On Tue, Jul 11, 2017 at 7:49 AM, Walter Dörwald 
> <wa...@li...>
> wrote:
>
>> On 6 Jul 2017, at 19:11, Anthony Tuininga wrote:
>>
>> [...]
>>
>>> Thanks. I have downloaded VS 2017 and will attempt to build with it. 
>>> I
>>> know that Python itself was built with VS 2015 so that 
>>> redistributable will be
>>> needed but the 2017 one will also probably be needed. I'll let you 
>>> know if
>>> I am able to replicate your issue.
>>
>> Any luck so far?
>
> I was able to get VS 2017 and was able to compile cx_Oracle with it. I
> didn't run into any problems at all. I was using an instant client,
> however, so not sure if that has any bearing.
>
>> What we could try is to use the Oracle Instant Client instead of 
>> Oracle 11
>> XE and see if this changes anything.
>
> Please let us know if this does change things in any way.
>
> A new release will be made sometime next week, if at all possible, so 
> you
> can get binary releases directly for it with this and other fixes 
> included
> in it. There will also be some updated documentation on installation 
> which
> will encapsulate some of this information -- so if you do find out 
> that
> Oracle 11 XE is the culprit it would be very good to know! Thanks.

OK, we've installed an Instant Client, removed Oracle XE from the path 
and added the Instant Client instead. We also put a tnsnames.ora file in 
the Instant Client directory. The result

   >>> import cx_Oracle
    Traceback (most recent call last):
      File "<stdin>", line 1, in <module>
    cx_Oracle.DatabaseError: DPI-1047: Oracle Client library cannot be 
loaded: Das angegebene Modul wurde nicht gefunden. See 
https://oracle.github.io/odpi/doc/installation.html for help

I.e. we get another error message: "Das angegebene Modul wurde nicht 
gefunden" means "The specified module wasn't found".

If we start the sqlplus.exe that is part of the Oracle Instant Client, 
it sits there for several seconds and then displays the following 
dialog:

    http://styx.livinglogic.de/~walter/cx_Oracle/sqlplus_dialog.png

which basically says "MSVCR100.dll not found".

After we've copied MSVCR100.dll from some other directory (Sublime Text 
in the case) to the Instant Client directory, importing cx_Oracle did 
work, and we could do db queries with it.

Copying MSVCR100.dll to the Oracle XE directory however doesn't change 
anything. (The Oracle XE directory does contain MSVCR71.dll, but whether 
this is good, bad, or irrelevant, I don't know).

> [...]

Servus,
    Walter