search

oracle / python-cx_Oracle

Python interface to Oracle Database now superseded by python-oracledb
https://oracle.github.io/python-cx_Oracle
Other
889 stars 361 forks source link

Wont build on windows #668

Closed roda37 closed 7 months ago

roda37 commented 7 months ago

Untitled

I keep getting this message, I am not very good with windows but I am pretty sure I've installed the build tools and every known C++ package both x86 and 64 and it still wont build the package, any help?

cjbj commented 7 months ago

The common root cause is trying to use cx_Oracle with versions of Python that were released after cx_Oracle 8.3 itself was released. I.e. Pre-built cx_Oracle binaries packages are not available for those Python versions. The best solution in this case is to upgrade cx_Oracle so the new version's pre-built binary packages install directly without you needing to compile. See the original release announcement for the upgrade.

roda37 commented 7 months ago

The common root cause is trying to use cx_Oracle with versions of Python that were released after cx_Oracle 8.3 itself was release. I.e. Pre-built cx_Oracle binaries packages are not available for those Python versions. The best solution in this case is to upgrade cx_Oracle so the new version's pre-built binary packages install directly without you needing to compile. See the original release announcement for the upgrade.

The main reason why I use this client instead of the new oracledb client is because the new one does not support old databases, when you run the script with this new library you will always get this:

DPY-3010: connections to this database server version are not supported by python-oracledb in thin mode

The old one (cx_Oracle) works with Oracle Database 11g that I have deployed here, which cannot be upgraded or changed. Hey I'm just trying to do my job :). Could you perhaps point me to the prebuilt packages, or could it be built with mingw?

On Linux cx_Oracle works really nice, yes it's annoying to have a client installed but as long as it works it's fine. On Windows however it will fail no matter what. I don't know anything about packaging on pip, perhaps someone here does so it can be fixed.

cjbj commented 7 months ago

The new driver, python-oracledb, works fine with Oracle DB 11gR2: you just need to add a call to init_oracle_client() in your scripts so the Oracle Client libraries are linked, just like they always were with cx_Oracle. The Thick mode is now optional in python-oracledb, but was the only choice with cx_Oracle.

cjbj commented 7 months ago

Closing - no update