cx_Oracle.DatabaseError: DPI-1047

[Priyanka493-My]

1. What versions are you using? python 3.7.6 64 bit (AMD64)

Give your database version. sqldeveloper-21.4.1.349.1822-x64

Also run Python and show the output of:

import sys
import platform

print("platform.platform:", platform.platform())
print("sys.maxsize > 2**32:", sys.maxsize > 2**32)
print("platform.python_version:", platform.python_version())

platform.platform: Windows-10-10.0.18362-SP0 sys.maxsize > 2**32: False platform.python_version: 3.7.2

And:

import cx_Oracle
print("cx_Oracle.version:", cx_Oracle.version)
print("cx_Oracle.clientversion:", cx_Oracle.clientversion())

cx_Oracle.version: 8.3.0 Then getting this error print("cx_Oracle.clientversion:", cx_Oracle.clientversion()) cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 32-bit Oracle Client library: "The specified module could not be found".

-->

2. Describe the problem

cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 32-bit Oracle Client library: "The specified module could not be found". Even installed instantclient-basiclite-windows.x64-21.3.0.0.0 . Mine is a 64 bit laptop. Kindly help.

3. Include a runnable Python script that shows the problem.

import cx_Oracle

Connect as user "hr" with password "welcome" to the "orclpdb1" service running on this computer.

connection = cx_Oracle.connect(user="c##scott", password="XXXXXX", dsn="localhost:1521/orcl") print(connection.version)

[anthony-tuininga]

Look carefully at what you posted. You claim to be running Python 3.7.6 64-bit but you are actually running Python 3.7.2 32-bit! Make sure you are actually running the 64-bit version of Python!

[cjbj]

Closing - no activity.