cx_Oracle错误。 DPI-1047：无法找到64位Oracle客户端库 [英] cx_Oracle error. DPI-1047: Cannot locate a 64-bit Oracle Client library

问题描述

我安装了该库，当尝试使用我的凭据访问jupyter笔记本中的SQL时，出现以下错误：

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

DatabaseError：DPI-1047：无法找到64-位Oracle客户端库：找不到指定的模块。参见 https://oracle.github.io/odpi/doc/installation.html# Windows 寻求帮助

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

推荐答案

我建议您首先检查OS，Python和Oracle Instant Client体系结构的兼容性：

I suggest you to first check the compatibility of your OS, Python and Oracle Instant Client architecture:

import platform
platform.architecture()

然后，我绝对建议您在jupyter笔记本中设置Oracle Instant Client：

Then, I definitely advise you to set the Oracle Instant Client inside your jupyter notebook:

import os
os.environ["PATH"] = "Complete Location of Instant Client Folder" + ";" + os.environ["PATH"]

这篇关于cx_Oracle错误。 DPI-1047：无法找到64位Oracle客户端库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！