Question

pycharm连接mssql报错ValueError怎么办？

python3.7pycharm2018.3.4代码：import pymssqlconn = pymssql.connect( host='LA2', database='testbase')~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~运行报错：F:\!school\python\venv\Scripts\python.exe F:/!school/python/t05.pyF:/!school/python/t05.py:1: DeprecationWarning: Using or importing the ABCs from 'collections' instead of from 'collections.abc' is deprecated, and in 3.8 it will stop working import pymssqlProcess finished with exit code -1073741819 (0xC0000005)~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~debug报错：F:\!school\python\venv\Scripts\python.exe "F:\!school\!pycharm\PyCharm Community Edition 2018.3.4\helpers\pydev\pydevd.py" --multiproc --qt-support=auto --client 127.0.0.1 --port 60609 --file F:/!school/python/t05.pypydev debugger: process 18696 is connectingConnected to pydev debugger (build 191.6183.50)Traceback (most recent call last): File "F:\!school\!pycharm\PyCharm Community Edition 2018.3.4\helpers\pydev\pydevd.py", line 1741, in <module> main() File "F:\!school\!pycharm\PyCharm Community Edition 2018.3.4\helpers\pydev\pydevd.py", line 1735, in main globals = debugger.run(setup['file'], None, None, is_module) File "F:\!school\!pycharm\PyCharm Community Edition 2018.3.4\helpers\pydev\pydevd.py", line 1135, in run pydev_imports.execfile(file, globals, locals) # execute the script File "F:\!school\!pycharm\PyCharm Community Edition 2018.3.4\helpers\pydev\_pydev_imps\_pydev_execfile.py", line 18, in execfile exec(compile(contents+"\n", file, 'exec'), glob, loc) File "F:/!school/python/t05.py", line 5, in <module> database='testbase' File "src\pymssql.pyx", line 636, in pymssql.connect File "src\_mssql.pyx", line 1957, in _mssql.connect File "src\_mssql.pyx", line 675, in _mssql.MSSQLConnection.__init__ValueError: list.remove(x): x not in list





Answer 1

要这样写：
pymssql.connect(host='数据库服务器地址',user='user',password='密码',database='数据库名称',charset='utf8')
MSSQL是要密码认证的，它不是SQLite这种轻量可不加密的数据库。