使用 pyodbc 从 IBM DB2 检索数据以及相关错误

Question

我确认我已经在 StackOverflow 上浏览了多个关于类似问题的帖子，但仍然遇到以下问题，因此发帖寻求指导/指示。

以下是代码执行的代码

import pypyodbc as pyodbc
import configparser

config = configparser.ConfigParser()
config.read('config.ini')

conn_str = 'DRIVER={' + config['db2']['driver'] + '};' \
            + 'SERVER=' + config['db2']['server'] + ';' \
            + 'DATABASE=' + config['db2']['database'] + ';' \
            + 'UID=' + config['db2']['uid'] + ';' \
            + 'PWD=' + config['db2']['password']
print(conn_str)

connection = pyodbc.connect(
    conn_str
)

cur = connection.cursor()

cur.execute('SELECT col_1, col_2 FROM schema.table_name LIMIT 2')
for row in cur:
    print (row)

输出

[connect string output]
DRIVER={'IBM i Access ODBC Driver 64-bit'};SERVER='hostname';DATABASE='database';UID='userid';PWD='password'

[error from executing the code]
raise Error(state,err_text)
pypyodbc.Error: ('IM002', '[IM002] [unixODBC][Driver Manager]Data source name not found, and no default driver specified')

配置文件

$ cat config.ini
[db2]
driver = 'IBM i Access ODBC Driver 64-bit'
server = 'hostname'
database = 'database'
uid = 'userid'
password = 'password'

ODBC 安装程序和卸载程序命令的输出

odbcinst -j
unixODBC 2.3.1
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /home/useradmin/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

cat /etc/odbcinst.ini
[PostgreSQL]
Description=ODBC for PostgreSQL
Driver=/usr/lib/psqlodbcw.so
Setup=/usr/lib/libodbcpsqlS.so
Driver64=/usr/lib64/psqlodbcw.so
Setup64=/usr/lib64/libodbcpsqlS.so
FileUsage=1

[MySQL]
Description=ODBC for MySQL
Driver=/usr/lib/libmyodbc5.so
Setup=/usr/lib/libodbcmyS.so
Driver64=/usr/lib64/libmyodbc5.so
Setup64=/usr/lib64/libodbcmyS.so
FileUsage=1

[IBM i Access ODBC Driver]
Description=IBM i Access for Linux ODBC Driver
Driver=/opt/ibm/iaccess/lib/libcwbodbc.so
Setup=/opt/ibm/iaccess/lib/libcwbodbcs.so
Driver64=/opt/ibm/iaccess/lib64/libcwbodbc.so
Setup64=/opt/ibm/iaccess/lib64/libcwbodbcs.so
Threading=0
DontDLClose=1
UsageCount=1

[IBM i Access ODBC Driver 64-bit]
Description=IBM i Access for Linux 64-bit ODBC Driver
Driver=/opt/ibm/iaccess/lib64/libcwbodbc.so
Setup=/opt/ibm/iaccess/lib64/libcwbodbcs.so
Threading=0
DontDLClose=1
UsageCount=1

$ cat ~/.odbc.ini
[db2]
Driver          = IBM i Access ODBC Driver 64-bit
DATABASE        = 'database'
SYSTEM          = hostname
HOSTNAME        = hostname
PORT            = 446
PROTOCOL        = TCPIP

$ isql db2 $username $password -v
[08001][unixODBC][IBM][System i Access ODBC Driver]The specified database can not be accessed at this time.
[ISQL]ERROR: Could not SQLConnect

中没有拼写错误

我已仔细检查并确认驱动程序名称“IBM i Access ODBC Driver 64-bit”操作系统信息 x86_64 GNU/Linux

请问有关于如何调试问题的指示/指导吗？

Answer 1

我认为您将架构名称与数据库名称混淆了。
您很可能可以完全省略数据库名称（或将其保留为空字符串并使其默认为 *SYSBAS）。相反，您可以指定 DefaultLibraries 参数。

请参阅此处的 IBM 文档有关有效连接字符串（和 odbc.ini）关键字的信息。

同样，您可以省略 PORT、PROTOCOL 和 HOSTNAME 关键字，因为此驱动程序不支持它们。

这将为您留下一个看起来像这样简单的 odbc.ini：

[db2]
Driver           = IBM i Access ODBC Driver 64-bit
DefaultLibraries = 'database'
SYSTEM           = hostname