pycharm 连接 mssql 报错 ValueError 怎么办?

问答 liaoebin ⋅ 于 2019-06-03 17:38:43 ⋅ 最后回复由 青牛 2019-06-04 09:19:10 ⋅ 2403 阅读

file
file
python3.7, pycharm2018.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 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 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.initValueError: list.remove(x): x not in list

成为第一个点赞的人吧 :bowtie:
回复数量: 1
  • 青牛 国内首批大数据从业者,就职于金山,担任大数据团队核心研发工程师
    2019-06-04 09:19:10

    没连上把你的LA2是什么地址 写成ip试试

暂无评论~~
  • 请注意单词拼写,以及中英文排版,参考此页
  • 支持 Markdown 格式, **粗体**、~~删除线~~、`单行代码`, 更多语法请见这里 Markdown 语法
  • 支持表情,可用Emoji的自动补全, 在输入的时候只需要 ":" 就可以自动提示了 :metal: :point_right: 表情列表 :star: :sparkles:
  • 上传图片, 支持拖拽和剪切板黏贴上传, 格式限制 - jpg, png, gif,教程
  • 发布框支持本地存储功能,会在内容变更时保存,「提交」按钮点击时清空
Ctrl+Enter