获取“cx_Oracle.DatabaseError: DPI-1050: Oracle Client lib

Getting quot;cx_Oracle.DatabaseError: DPI-1050: Oracle Client library must be at version 11.2 or higherquot; error(获取“cx_Oracle.DatabaseError: DPI-1050: Oracle Client library must be at version 11.2 or later错误)

问题描述

我正在尝试使用 pycharm(3.3) 使用以下代码访问我的 Oracle SQL(11.2.0)，但出现以下详细信息的错误.

I am trying to use pycharm(3.3) to access my Oracle SQL(11.2.0) using the below codes but getting error with below details.

使用的代码:

import cx_Oracle

connection = cx_Oracle.connect('uname/pwdserver')

收到错误

cx_Oracle.DatabaseError: DPI-1050: Oracle Client library must be at version 11.2 or higher

推荐答案

我遇到了一个和你非常相似的问题.我能够通过使用不同的连接方法来解决它:

I had an issue very similar to yours. I was able to solve it by using a different connection method:

my_dsn = cx_Oracle.makedsn("host",port,sid="sid")
connection = cx_Oracle.connect(user="user", password="password", dsn=my_dsn)
cursor = connection.cursor()

querystring = "SQL query"
cursor.execute(querystring)

参见 http://cx-oracle.readthedocs.io/en/latest/module.html 了解更多信息

这篇关于获取“cx_Oracle.DatabaseError: DPI-1050: Oracle Client library must be at version 11.2 or later"错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！