Databases
StackOverflow2013
Postsdbo
POpymssql throws ImportError: No module named _mssql when build app with py2exe
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POpymssql throws ImportError: No module named _mssql when build app with py2exe
    primarykey
    data
    text
    <p>I have python application that shoud be launched as windows executable. I'm using py2exe and pymssql 1.9.908.</p> <p>I used next build script to generate application:</p> <pre><code>from distutils.core import setup import MySQLdb import fnmatch import os import pymssql import shutil import py2exe import glob ############## name = 'BGAgent' old_version = '0.1' ver = '0.1' distDir = 'Dist' + name + ver shutil.rmtree(distDir, True) shutil.rmtree('Dist' + name + old_version, True) os.mkdir(distDir) ############## class Target(object): """ A simple class that holds information on our executable file. """ def __init__(self, **kw): """ Default class constructor. Update as you need. """ self.__dict__.update(kw) # MySQLdb #dst = os.path.join(distDir, "MySQLdb") #copy_tree(MySQLdb.__path__[0], dst ) # pymssql site_packages_dir = os.path.dirname(pymssql.__file__) pymssql_files = []#'pymssql.py', 'pymssql.pyc', 'pymssql.pyo', '_mssql.pyd'] for eggInfo in glob.glob(os.path.join(site_packages_dir, '*mssql*')) : pymssql_files.append(os.path.basename(eggInfo)) for fname in pymssql_files : src = os.path.join(site_packages_dir, fname) dst = os.path.join(distDir, fname) if(os.path.isfile(src)) : shutil.copy(src, dst) else : shutil.copytree(src, dst) includes = ['MySQLdb', 'pymssql', 'OpenSSL'] excludes = ['run_w.exe'] #['_gtkagg', '_tkagg', 'bsddb', 'curses', 'email', 'pywin.debugger', 'pywin.debugger.dbgcon', 'pywin.dialogs', 'tcl', 'Tkconstants', 'Tkinter'] packages = ['MySQLdb', 'pymssql', 'OpenSSL'] dll_excludes = []#['libgdk-win32-2.0-0.dll', 'libgobject-2.0-0.dll', 'tcl84.dll', 'tk84.dll'] data_files = ['server.pem', 'config.ini', 'run.bat', #os.path.join(os.path.split(pymssql.__file__)[0], 'ntwdblib.dll'), ] icon_resources = [] bitmap_resources = [] other_resources = [] MyApp_Target = Target( # what to build script = "run.py", icon_resources = icon_resources, bitmap_resources = bitmap_resources, other_resources = other_resources, dest_base = name, version = ver, company_name = "", copyright = "", name = name, ) setup( data_files = data_files, options = {"py2exe": {"compressed": 0, "optimize": 1, "includes": includes, "excludes": excludes, "packages": packages, "dll_excludes": dll_excludes, "bundle_files": 3, "dist_dir": distDir, "xref": False, "skip_archive": False, "ascii": False, "custom_boot_script": '', } }, zipfile = r'library.zip', console = [], windows = [MyApp_Target], service = [], com_server = [], ctypes_com_server = [] ) </code></pre> <p>Build works, but I have error when I tried to launch application:</p> <pre><code> File "pymssql.pyo", line 12, in &lt;module&gt; File "pymssql.pyo", line 10, in __load File "_mssql.pxd", line 10, in init pymssql (pymssql.c:7370) ImportError: No module named _mssql </code></pre> <p>_mssql.pyd and pymssql.pyd files are in executable directory.</p> <p>OS version Windows 7 Enterprice SP 1.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USvarela
    1. USvarela
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload