ubuntu系统中,查询到的数据都是空字符串,windows都是正常的
ubuntu系统中,查询到的数据都是空字符串
python3 httpTest2.py
('', '', '', '', None, '')
('', '', '', '', None, '')
('', '', '', '', None, '')
('', '', '', '', None, '')
('', '', '', '', None, '')
('', '', '', '', None, '')
('', '', '', '', None, '')
('', '', '', '', None, '')
('', '', '', '', None, '')
('', '', '', '', None, '')
代码如下
import pyodbc
import requests
driver = '/usr/irisodbc/bin/libirisodbc35.so'
server = 'xx'
database = 'xx'
username = 'xx'
password = 'xx'
port = 'xx'
cnxn = pyodbc.connect(driver=driver, server=server,port='51773', database=database, uid=username, pwd=password,charset='UTF-8')
cursor = cnxn.cursor()
cursor.execute("select top 10 * from xxx.xxx")
row = cursor.fetchone()
while row:
print(row)
row = cursor.fetchone()
cnxn.close()