CODEWITHSUNDEEP
pythonoracle-databasecx-oracleinstantclient
Alen Liu
Alen Liu

Reputation: 1

Python cx_Oracle "32-bit Oracle Client library cannot be loaded: "The specified module could not be found""

I downloaded the Oracle Instant Client and specified the Path in environment variable as in the first screenshot. enter image description here

cx_Oracle is imported successfully as shown in the second screenshot. enter image description here

I was trying to connect to Oracle DB hosted in AWS using the code as below: enter image description here

The log message returns:

32-bit Oracle Client library cannot be loaded: "The specified module could not be found".

Is my argument for cx_Oracle.connect or my path in the environment variables wrong? Python, WHL and Instant Client are all 32-bits.

Upvotes: 0

Views: 8727

Answers (2)

karol
karol

Reputation: 430

Oracle Instant Client require the presence of the correct Visual Studio redistributable according to documentation of installation: https://oracle.github.io/odpi/doc/installation.html#windows. Please check dependences dlls of oci.dll on your system.

Upvotes: 0

Cyrille MODIANO
Cyrille MODIANO

Reputation: 2376

From you’re screenshot you seem to use a 32bits python, if yes you also need to use a 32bits Oracle Instant client. Here you’re 32bits Python try to find 32bits oracle libraries and can’t find them.

Upvotes: 0

Related Questions