pymssql在macOS上import 报错处理：Expected in: flat namespace in _mssql.cpython-38-darwin.so

原创已于 2024-08-23 13:56:32 修改 · 1.3k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

©Dot1x

标签

#macos #python #mssql

于 2022-05-12 21:21:40 首次发布

Python 专栏收录该内容

10 篇文章

订阅专栏

在macOS系统中，使用pymssql库时遇到了'Expected in: flat namespace in _mssql.cpython-38-darwin.so'的导入错误。通过查阅GitHub上的相关Issue，找到了解决方案。只需简单引入相关包，即可消除报错。问题虽突发，但解决过程相对顺利。

报错提示

Python 3.8.1 (default, Oct  7 2020) 
[Clang 11.0.0] on darwin
Type "help", "copyright", "credits" or "license" for more information.
>>> import pymssql
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/Users/xxx/.pyenv/versions/3.8.1/lib/python3.8/site-packages/pymssql/__init__.py", line 3, in <module>
    from ._pymssql import *
  File "src/pymssql/_pymssql.pyx", line 1, in init pymssql._pymssql
ImportError: dlopen(/Users/xxx/.pyenv/versions/3.8.1/lib/python3.8/site-packages/pymssql/_mssql.cpython-38-darwin.so, 2): Symbol not found: _iconv
  Referenced from: /Users/xxx/.pyenv/versions/3.8.1/lib/python3.8/site-packages/pymssql/_mssql.cpython-38-darwin.so
  Expected in: flat namespace
 in /Users/xxx/.pyenv/versions/3.8.1/lib/python3.8/site-packages/pymssql/_mssql.cpython-38-darwin.so

解决方案

翻页GitHub的Issues之后解决
https://github.com/pymssql/pymssql/issues/705
在这里插入图片描述
引入包：_scproxy就不会报错了

>>> import _scproxy
>>> import pymssql
>>>

总结

其实之前都是好好的，后面无缘无故报错了。