cx_Oracle 错误.DPI-1047:找不到 64 位 Oracle 客户端库

问题描述

我安装了库，当尝试使用我的凭据访问 jupyter notebook 中的 SQL 时，出现以下错误:

DatabaseError:DPI-1047:找不到 64 位 Oracle 客户端库:找不到指定的模块".请参阅

就是这样！

I installed the library and when trying to access SQL in jupyter notebook with my credentials the following error appears:

DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: "The specified module could not be found". See https://oracle.github.io/odpi/doc/installation.html#windows for help

解决方案

The easiest solution is as follows:

1. Download 64-bit version of oracle instantClient from: https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html
2. Copy the dll files in the instantclient directory to the python directory, as shown below

That is it!