pyodbc cursor.execute（查询）在数据库中添加我的用户名

发布于 2025-01-21 06:16:14 字数 600 浏览 3 评论 0原文

在Jupyter Notebook中，我能够使用'dsn使用PyoBDC连接到工作数据库；用户身份; PW'连接字符串成功。我测试了打印数据库中的所有表名称。然后，我尝试运行以下代码来测试简单的查询。

================================================

query = "select * from TEST_TABLE"

cursor.execute(query)

==============

但是我有以下错误。

ProgrammingError: ('42S02', '[42S02] [IBM][CLI Driver][DB2/AIX64] SQL0204N  "**myusername.TEST_TABLE**" is an **undefined name**.  SQLSTATE=42704\r\n (-204) (SQLExecDirectW)')

我连接到的数据库中确实存在Test_table。但是由于某种原因，该代码在test_table的前面添加myusername，并告诉我未定义表名。

原文

In Jupyter Notebook, I was able to connect to my work database using pyobdc with 'dsn; userid; pw' connection string successfully. I tested out printing all the table names in the database. Then I tried to run the following code to test a simple query.

================================

query = "select * from TEST_TABLE"

cursor.execute(query)

================================

But I got the following error.

ProgrammingError: ('42S02', '[42S02] [IBM][CLI Driver][DB2/AIX64] SQL0204N  "**myusername.TEST_TABLE**" is an **undefined name**.  SQLSTATE=42704\r\n (-204) (SQLExecDirectW)')

TEST_TABLE does exist in the database I'm connected to. But for some reason, the code is adding myusername in front of the TEST_TABLE and tells me the table name is not defined.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

爱你不解释 2025-01-28 06:16:14

尝试设置PYODBC连接如下：

import pyodbc
dbConn = pyodbc.connect("DSN=<dsn>;UID=<uid>;PWD=<pwd>;DATABASE=<db>")
dbCursor = dbConn.cursor()
query = "SELECT * FROM TEST_TABLE"
dbCursor.execute(query)

其中：

dsn = hostName（或IP地址）
uid = the username
pwd = password
< em> db =数据库名称

Try setting up the PyODBC connection as follows:

import pyodbc
dbConn = pyodbc.connect("DSN=<dsn>;UID=<uid>;PWD=<pwd>;DATABASE=<db>")
dbCursor = dbConn.cursor()
query = "SELECT * FROM TEST_TABLE"
dbCursor.execute(query)

where: