一个pymssql 的程序在解释器上运行正常，但是用py2exe打包后，提示
ImportError: No module named _mssql
百度了半天无果，然后bing,结果bing还是比百度靠谱，某神网的这段话，让我有了灵感，英语真心不怎么好滴说：
FYI there is a separate newsgroup for py2exe at
gmane.comp.python.py2exe. You may want to post
there also. Just as a suggestion, put an import decimal at
the top of your program. It looks like _mssql
might be doing dynamic imports in __load method
which will "confuse" py2exe because it can't
know about dynamic imports which happen at
runtime. -Larry Bates Chris wrote:
I've just completed a project using the following (Windows XP, python
2.4.1, wxpython 2.6, and pymssql 0.7.3). The program runs great, but
after I convert it to an exe (required for this project), it gives me
the following error when I try to run it. Traceback (most recent call last):
File "EstUpdate.py", line 6, in ?
File "frmSplash.pyc", line 9, in ?
File "pymssql.pyc", line 23, in ?
File "_mssql.pyc", line 9, in ?
File "_mssql.pyc", line 7, in __load
ImportError: No module named decimal However, when I look in c:\python24\lib on the machine which ran py2exe,
I see decimal.py and decimal.pyc. Can someone please help with this? I'm supposed to start testing the
program today and I can't seem to move past this first step. Thanks!!
Chris
解决办法就是这句话：
Just as a suggestion, put an import decimal at
the top of your program. It looks like _mssql
might be doing dynamic imports in __load method
which will "confuse" py2exe because it can't
know about dynamic imports which happen at
runtime.
运行exe的时候提示缺什么模块就import什么模块，并在代码里面显示的调用一次，我在程序里是调用了__version__,如下代码：
# -*- coding:gbk -*-
import pymssql
import _mssql
import uuid
import decimal decimal.__version__
uuid.ctypes.__version__
_mssql.__version__
调用之后，打包完直接就可以运行了。
参考地址：http://bytes.com/topic/python/answers/168576-help-py2exe-error-no-module-named-decimal