python pymssql charset=“gbk“ b‘DB-Lib error message 20010, severity 8

简介: python pymssql charset=“gbk“ b‘DB-Lib error message 20010, severity 8

报错:

(20010, b'DB-Lib error message 20010, severity 8:\nUnable to allocate sufficient memory (localhost)\nOperating System error during No error (12)\n')

代码:

import pymssql
conn = pymssql.connect(host=ip,user=u,passwd=p,port=int(port),database='master', timeout=5,charset="gbk")

解决:去掉 charset="utf-8" 参数

pymssql.connect(host=ip,user=u,passwd=p,port=int(port),database='master', timeout=5)
目录
相关文章
|
5月前
|
网络安全 Python
python request SSL error 403证书错误
python request SSL error 403证书错误
73 0
|
2月前
|
安全 网络安全 API
python调用openai api报错self._sslobj.do_handshake()OSError: [Errno 0] Error
python调用openai api报错self._sslobj.do_handshake()OSError: [Errno 0] Error
74 1
python调用openai api报错self._sslobj.do_handshake()OSError: [Errno 0] Error
|
3月前
|
计算机视觉 Python
python opencv:ERROR: Could not find a version that satisfies the requirement opencv ERROR:
python opencv:ERROR: Could not find a version that satisfies the requirement opencv ERROR:
65 2
|
11天前
|
Python
IDA3.12版本的python,依旧报错IDAPython: error executing init.py.No module named ‘impRefer to the message win
IDA3.12版本的python,依旧报错IDAPython: error executing init.py.No module named ‘impRefer to the message win
|
1月前
|
SQL 关系型数据库 数据库连接
Python中使用pymysql和pymssql进行数据库操作的完整指南
Python中使用pymysql和pymssql进行数据库操作的完整指南
216 0
|
6月前
|
数据可视化 Python
常见的bug---5、在安装superset时候报错,Command “python setup.py egg_info“ failed with error code 1
常见的bug---5、在安装superset时候报错,Command “python setup.py egg_info“ failed with error code 1
|
4月前
|
编解码 Python Windows
Python文件路径报错SyntaxError: (unicode error) ‘unicodeescape‘ codec can‘t decode bytes in position 2-3: t
Python文件路径报错SyntaxError: (unicode error) ‘unicodeescape‘ codec can‘t decode bytes in position 2-3: t
|
9月前
|
C++ Python
【Python学习笔记】pip安装reportlab包时报错:fatal error LNK1158: cannot run ‘rc.exe‘
【Python学习笔记】pip安装reportlab包时报错:fatal error LNK1158: cannot run ‘rc.exe‘
|
9月前
|
前端开发 Python
npm install报错gyp ERR&! stack Error: Can‘t find Python executable python
晕了,今天安装react脚手架突然报这种奇怪的错 ,前几天还没事的
110 0
|
Python C语言
为Python安装pymssql模块来连接SQLServer
1、安装依赖包 yum install -y gcc python-devel 2、安装freetds 下载地址:http://pan.baidu.com/s/1pLKtFBl tar zxvf freetds-0.
1279 0