marupapa / pymssql

Automatically exported from code.google.com/p/pymssql
GNU Lesser General Public License v2.1
0 stars 0 forks source link

import pymssql crashes python #2

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. download newest pymssql for windows on this website
2. run the installer
3. try to import pymssql module, python crashes

What is the expected output? What do you see instead?
i expect it to not crash, python crashes

What version of the product are you using? On what operating system?
python2.6 on windows XP 2002SP3 32bit

Please provide any additional information below.

Original issue reported on code.google.com by nmeix...@gmail.com on 21 Apr 2010 at 9:52

GoogleCodeExporter commented 8 years ago
Can't confirm this either with ActivePython 2.6.4.10 or with python.org Python 
2.6.5.
Please try to reinstall Python and pymssql and see what happens.

Original comment by akuk...@gmail.com on 22 Apr 2010 at 7:51

GoogleCodeExporter commented 8 years ago
I was using pymssql last night, been using it for a couple of weeks with no 
problem.
Suddenly, when I would try to import pymssql module, it would crash PythonWin 
or IDLE
(the Python GUI).  At first it was random, about every 3rd or 4th load would 
crash
it.  Pretty soon, it was every import.  The only other program running during 
this
time was Notepad++.

Let me emphasize that this has been working flawlessly for 2 weeks; crashes at 
first
were random; finally, crashed every time I tried to import pymssql.  This 
occurred
over about a 2 hour time period.

Tried uninstalling pymssql and reinstalling.  Still crashes on every import.

Running in VMWare 1.0.9 build-156507
Windows 7 Professional 32-bit
Python 2.6.2 (r262:71605, Apr 14 2009, 22:40:02)
[Installed by ESRI's ArcGIS program, in C:\Python26\ArcGIS9.4\... -- this 
program
apparently wants this folder structure, I don't know why, but I don't want to 
change it.]

Detailed crash info:
Problem signature:
  Problem Event Name:   APPCRASH
  Application Name: pythonw.exe
  Application Version:  0.0.0.0
  Application Timestamp:    49e4f60b
  Fault Module Name:    _mssql.pyd
  Fault Module Version: 0.0.0.0
  Fault Module Timestamp:   4bc64492
  Exception Code:   c0000005
  Exception Offset: 00017495
  OS Version:   6.1.7600.2.0.0.256.48
  Locale ID:    1033
  Additional Information 1: 0a9e
  Additional Information 2: 0a9e372d3b4ad19135b953a78882e789
  Additional Information 3: 0a9e
  Additional Information 4: 0a9e372d3b4ad19135b953a78882e789

I've confirmed that this crash info is the same on every crash; it doesn't 
change. 
I've tried rebooting Virtual Machine, etc., but it seems "corrupted".

Just tried uninstalling pymssql and PythonWin, reinstalled just pymssql - same 
crash
info.

Hope this helps in tracking this down.

Original comment by cew...@comcast.net on 26 Apr 2010 at 6:51

GoogleCodeExporter commented 8 years ago
OK so the python language works just fine, but the IDEs crash. Can you try just
`import _mssql` from IDE or Pythonwin?

Original comment by akuk...@gmail.com on 26 Apr 2010 at 9:08

GoogleCodeExporter commented 8 years ago
Just tried that and it worked!

Original comment by cew...@comcast.net on 27 Apr 2010 at 3:30

GoogleCodeExporter commented 8 years ago
I see this as well, running on windows 7.  I installed a new version of pymssql 
using
the pymssql-1.9.907.win32-py2.6.exe installer the morning of 4/27/2010.

I usually use IPython, and importing crashes with an error message:
----
C:\Python26>python.exe "C:\Python26\scripts\ipython"
Python 2.6.5 (r265:79096, Mar 19 2010, 21:48:26) [MSC v.1500 32 bit (Intel)]
Type "copyright", "credits" or "license" for more information.

IPython 0.10 -- An enhanced Interactive Python.
?         -> Introduction and overview of IPython's features.
%quickref -> Quick reference.
help      -> Python's own help system.
object?   -> Details about 'object'. ?object also works, ?? prints more.

In [1]: import pymssql
tds_init_winsock: WSAEnumProtocols failed with 10055(WSAENOBUFS: No buffer space
 available.)
----

A normal python interpreter also gives the error:
----
C:\Python26>python.exe -i
Python 2.6.5 (r265:79096, Mar 19 2010, 21:48:26) [MSC v.1500 32 bit (Intel)] on
win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import _mssql
tds_init_winsock: WSAEnumProtocols failed with 10055(WSAENOBUFS: No buffer space
 available.)
----

Oddly enough, if I try it from cygwin, it works:
----
 > /cygdrive/c/Python26/python.exe -i
Python 2.6.5 (r265:79096, Mar 19 2010, 21:48:26) [MSC v.1500 32 bit (Intel)] on 
win32
Type "help", "copyright", "credits" or "license" for more information.
Could not open PYTHONSTARTUP
IOError: [Errno 2] No such file or directory: '/home/ryepup/.pythonrc'
>>> import pymssql
>>> exit()
----

Original comment by rye...@gmail.com on 27 Apr 2010 at 2:20

GoogleCodeExporter commented 8 years ago
A coworker using Python 2.6.2 (r262:71605, Apr 14 2009, 22:40:02) [MSC v.1500 
32 bit
(Intel)] has no problem importing pymssql under ipython.

Original comment by rye...@gmail.com on 27 Apr 2010 at 3:18

GoogleCodeExporter commented 8 years ago
So looks like we have problem with FreeTDS on Windows. Stay tuned for updates.

Original comment by akuk...@gmail.com on 27 Apr 2010 at 5:30

GoogleCodeExporter commented 8 years ago
I tried importing _mssql as well. Still Crashes. The error message contains 
this 
info (not sure if any of it is useful)

Error Signature:
AppName pythonw.exe
AppVer 0.0.0.0
ModName: _mssql.pyd
ModVer: 0.0.0.0
Offset 00017495

Exception Information:
Code: 0xc0000005
Flags: 0x00000000
Record: 0x0000000000000000
Adress0x0000000001557495

Let me know if there is any more info I can provide.  Thanks to all for the 
help.

Original comment by nmeix...@gmail.com on 27 Apr 2010 at 11:32

GoogleCodeExporter commented 8 years ago
I am having the same issue with the _mssql library.  Everything works fine if I
comment out 'import cgi' but I need it.

Original comment by luigi...@gmail.com on 30 Apr 2010 at 10:13

GoogleCodeExporter commented 8 years ago
I am experiencing the exact same issue on both a Windows XP SP3 and a Windows 
Server
2008 SP2 machine. Both are running Python 2.6.5, and trying to import either 
pymssql
or _mssql whether via CGI or IDLE immediately crashes the python process.

Original comment by eavesdown on 1 May 2010 at 8:13

GoogleCodeExporter commented 8 years ago
I find the problem not only crashing the IDE but also when running a script 
from the
command line. The 2nd line of the script is "import pymssql".

Attached is a screenshot of the output from the command line

Original comment by r.bryan....@gmail.com on 5 May 2010 at 6:48

Attachments:

GoogleCodeExporter commented 8 years ago
i had the same problem with   Comment 11  by r.bryan.kane,

Original comment by kylinp...@gmail.com on 6 May 2010 at 6:27

GoogleCodeExporter commented 8 years ago
I  had  same problem   using sqlobject  but in CMD  is OK

Original comment by yangwenchong2003 on 21 May 2010 at 7:27

Attachments:

GoogleCodeExporter commented 8 years ago
from sqlobject.dbconnection import DBAPI
from sqlobject import col
import re
import pymssql as sqlmodule
class MSSQLConnection(DBAPI):

    supportTransactions = True
    dbName = 'mssql'
    schemes = [dbName]

    def __init__(self, db, user, password='', host='localhost',
                 autoCommit=0, **kw):
        backends = kw.pop('backend', None) or 'adodb,pymssql'
        for backend in backends.split(','):
            backend = backend.strip()
            if not backend:
                continue
            try:
                if backend in ('adodb', 'adodbapi'):
                    import adodbapi as sqlmodule
                elif backend == 'pymssql':
                    pass
                    #import pymssql
                    #import pymssql as sqlmodule
                else:
                    raise ValueError('Unknown MSSQL backend "%s", expected adodb or
pymssql' % backend)
            except ImportError:
                pass
            else:
                break
        else:
            raise ImportError('Cannot find an MSSQL backend, tried %s' % backends)
        self.module = sqlmodule

        if sqlmodule.__name__ == 'adodbapi':
            self.dbconnection = sqlmodule.connect
            # ADO uses unicode only (AFAIK)
            self.usingUnicodeStrings = True

            # Need to use SQLNCLI provider for SQL Server Express Edition
            if kw.get("ncli"):
                conn_str = "Provider=SQLNCLI;"
            else:
                conn_str = "Provider=SQLOLEDB;"

            conn_str += "Data Source=%s;Initial Catalog=%s;"

            # MSDE does not allow SQL server login 
            if kw.get("sspi"):
                conn_str += "Integrated Security=SSPI;Persist Security Info=False"
                self.make_conn_str = lambda keys: [conn_str % (keys.host, keys.db)]
            else:
                conn_str += "User Id=%s;Password=%s"
                self.make_conn_str = lambda keys: [conn_str % (keys.host, keys.db,
keys.user, keys.password)]

            kw.pop("sspi", None)
            kw.pop("ncli", None)

        else: # pymssql
            self.dbconnection = sqlmodule.connect
            sqlmodule.Binary = lambda st: str(st)
            # don't know whether pymssql uses unicode
            self.usingUnicodeStrings = False
            self.make_conn_str = lambda keys:  \
                   ["", keys.user, keys.password, keys.host, keys.db]

        self.autoCommit=int(autoCommit)
        self.host = host
        self.db = db
        self.user = user
        self.password = password
        self.limit_re = re.compile('^\s*(select )(.*)', re.IGNORECASE)
        self.password = password
        self._can_use_max_types = None
        DBAPI.__init__(self, **kw)

    def connectionFromURI(cls, uri):
        user, password, host, port, path, args = cls._parseURI(uri)
        path = path.strip('/')
        return cls(user=user, password=password, host=host or 'localhost',
                   db=path, **args)
    connectionFromURI = classmethod(connectionFromURI)

    def insert_id(self, conn):
        """
        insert_id method.
        """
        c = conn.cursor()
        # converting the identity to an int is ugly, but it gets returned
        # as a decimal otherwise :S
        c.execute('SELECT CONVERT(INT, @@IDENTITY)')
        return c.fetchone()[0]

    def makeConnection(self):
        con = self.dbconnection( *self.make_conn_str(self) )
        cur = con.cursor()
        cur.execute('SET ANSI_NULLS ON')
        cur.execute("SELECT CAST('12345.21' AS DECIMAL(10, 2))")
        self.decimalSeparator = str(cur.fetchone()[0])[-3]
        cur.close()
        return con

    HAS_IDENTITY = """
       SELECT col.name, col.status, obj.name
       FROM syscolumns col
       JOIN sysobjects obj
       ON obj.id = col.id
       WHERE obj.name = '%s'
       and col.autoval is not null

    """
    def _hasIdentity(self, conn, table):
        query = self.HAS_IDENTITY % table
        c = conn.cursor()
        c.execute(query)
        r = c.fetchone()
        return r is not None

    def _queryInsertID(self, conn, soInstance, id, names, values):
        """
            Insert the Initial with names and values, using id.
        """
        table = soInstance.sqlmeta.table
        idName = soInstance.sqlmeta.idName
        c = conn.cursor()
        has_identity = self._hasIdentity(conn, table)
        if id is not None:
            names = [idName] + names
            values = [id] + values
        elif has_identity and idName in names:
            try:
                i = names.index( idName )
                if i:
                    del names[i]
                    del values[i]
            except ValueError:
                pass

        if has_identity:
            if id is not None:
                c.execute('SET IDENTITY_INSERT %s ON' % table)
            else:
                c.execute('SET IDENTITY_INSERT %s OFF' % table)

        q = self._insertSQL(table, names, values)
        if self.debug:
            print 'QueryIns: %s' % q
        c.execute(q)
        if has_identity:
            c.execute('SET IDENTITY_INSERT %s OFF' % table)

        if id is None:
            id = self.insert_id(conn)
        if self.debugOutput:
            self.printDebug(conn, id, 'QueryIns', 'result')
        return id

    def _queryAddLimitOffset(cls, query, start, end):
        if end and not start:
            limit_str = "SELECT TOP %i" % end

            match = cls.limit_re.match(query)
            if match and len(match.groups()) == 2:
                return ' '.join([limit_str, match.group(2)])
        else:
            return query
    _queryAddLimitOffset = classmethod(_queryAddLimitOffset)

    def createReferenceConstraint(self, soClass, col):
        return col.mssqlCreateReferenceConstraint()

    def createColumn(self, soClass, col):
        return col.mssqlCreateSQL(self)

    def createIDColumn(self, soClass):
        key_type = {int: "INT", str: "TEXT"}[soClass.sqlmeta.idType]
        return '%s %s IDENTITY UNIQUE' % (soClass.sqlmeta.idName, key_type)

    def createIndexSQL(self, soClass, index):
        return index.mssqlCreateIndexSQL(soClass)

    def joinSQLType(self, join):
        return 'INT NOT NULL'

    SHOW_TABLES="SELECT name FROM sysobjects WHERE type='U'"
    def tableExists(self, tableName):
        for (table,) in self.queryAll(self.SHOW_TABLES):
            if table.lower() == tableName.lower():
                return True
        return False

    def addColumn(self, tableName, column):
        self.query('ALTER TABLE %s ADD %s' %
                   (tableName,
                    column.mssqlCreateSQL(self)))

    def delColumn(self, sqlmeta, column):
        self.query('ALTER TABLE %s DROP COLUMN %s' % (tableName.table, column.dbName))

    # precision and scale is gotten from column table so that we can create 
    # decimal columns if needed
    SHOW_COLUMNS = """
        select
                name,
                length,
                (       select name
                        from systypes
                        where cast(xusertype as int)= cast(sc.xtype as int)
                ) datatype,
                prec,
                scale,
                isnullable,
                cdefault,
                m.text default_text,
                isnull(len(autoval),0) is_identity
        from syscolumns sc
        LEFT OUTER JOIN syscomments m on sc.cdefault = m.id
                AND m.colid = 1
        where
                sc.id in (select id
                        from sysobjects
                where name = '%s')
        order by
                colorder"""

    def columnsFromSchema(self, tableName, soClass):
        colData = self.queryAll(self.SHOW_COLUMNS
                                % tableName)
        results = []
        for field, size, t, precision, scale, nullAllowed, default, defaultText,
is_identity in colData:
            if field == soClass.sqlmeta.idName:
                continue
            # precision is needed for decimal columns
            colClass, kw = self.guessClass(t, size, precision, scale)
            kw['name'] = str(soClass.sqlmeta.style.dbColumnToPythonAttr(field))
            kw['dbName'] = str(field)
            kw['notNone'] = not nullAllowed
            if (defaultText):
                # Strip ( and )
                defaultText = defaultText[1:-1]
                if defaultText[0] == "'":
                    defaultText = defaultText[1:-1]
                else:
                    if t == "int"    : defaultText = int(defaultText)
                    if t == "float"  : defaultText = float(defaultText)
                    if t == "numeric": defaultText = float(defaultText)
                    # TODO need to access the "column" to_python method here--but the
object doesn't exists yet

            # @@ skip key...
            kw['default'] = defaultText

            results.append(colClass(**kw))
        return results

    def _setAutoCommit(self, conn, auto):
        #raise Exception(repr(auto))
        return
        #conn.auto_commit = auto
        option = "ON"
        if auto == 0:
            option = "OFF"
        c = conn.cursor()
        c.execute("SET AUTOCOMMIT " + option)
        conn.setconnectoption(SQL.AUTOCOMMIT, option)

    # precision and scale is needed for decimal columns
    def guessClass(self, t, size, precision, scale):
        """
            Here we take raw values coming out of syscolumns and map to SQLObject
class types.
        """
        if t.startswith('int'):
            return col.IntCol, {}
        elif t.startswith('varchar'):
            if self.usingUnicodeStrings:
                return col.UnicodeCol, {'length': size}
            return col.StringCol, {'length': size}
        elif t.startswith('char'):
            if self.usingUnicodeStrings:
                return col.UnicodeCol, {'length': size,
                                       'varchar': False}
            return col.StringCol, {'length': size,
                                   'varchar': False}
        elif t.startswith('datetime'):
            return col.DateTimeCol, {}
        elif t.startswith('decimal'):
            return col.DecimalCol, {'size': precision, # be careful for awkward naming
                                   'precision': scale}
        else:
            return col.Col, {}

    def server_version(self):
        try:
            server_version = self.queryAll("SELECT
SERVERPROPERTY('productversion')")[0][0]
            server_version = server_version.split('.')[0]
            server_version = int(server_version)
        except:
            server_version = None # unknown
        self.server_version = server_version # cache it forever
        return server_version

    def can_use_max_types(self):
        if self._can_use_max_types is not None:
            return self._can_use_max_types
        server_version = self.server_version()
        self._can_use_max_types = can_use_max_types = \
            (server_version is not None) and (server_version >= 9)
        return can_use_max_types

Original comment by yangwenchong2003 on 21 May 2010 at 7:28

GoogleCodeExporter commented 8 years ago
Having the same problem here.

Windows XP SP3,
Python 2.6.5
pymssql-1.9.908-py2.6

when:
import web
db=web.database(dbn='mssql',user='tamu',pw='tamu',db='tw_ddms',host='sql')

python 2.6 crashes with message:
tds_init_winsock: WSAEnumProtocols failed with 10055(WSAENOBUFS: No buffer space
 available.)

Original comment by jackie.s...@gmail.com on 21 May 2010 at 8:41

GoogleCodeExporter commented 8 years ago
The same problem here, with python 2.6.5 and latest pymssql, when I try to 
import 
it, crashed python, idle or even ipython. Here you have the dump of the crash:

<?xml version="1.0" encoding="UTF-16"?>
<DATABASE>
<EXE NAME="python.exe" FILTER="GRABMI_FILTER_PRIVACY">
    <MATCHING_FILE NAME="python.exe" SIZE="26624" CHECKSUM="0x2C93E1FF" 
MODULE_TYPE="WIN32" PE_CHECKSUM="0xE869" LINKER_VERSION="0x0" 
LINK_DATE="03/19/2010 
20:53:23" UPTO_LINK_DATE="03/19/2010 20:53:23" />
    <MATCHING_FILE NAME="pythonw.exe" SIZE="27136" CHECKSUM="0xCE0E701E" 
MODULE_TYPE="WIN32" PE_CHECKSUM="0x708C" LINKER_VERSION="0x0" 
LINK_DATE="03/19/2010 
20:56:02" UPTO_LINK_DATE="03/19/2010 20:56:02" />
    <MATCHING_FILE NAME="Removeipython.exe" SIZE="61440" CHECKSUM="0xE589B8AD" 
MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" 
LINK_DATE="05/31/2008 
04:52:45" UPTO_LINK_DATE="05/31/2008 04:52:45" />
    <MATCHING_FILE NAME="Removepy2exe.exe" SIZE="66048" CHECKSUM="0xA032993F" 
MODULE_TYPE="WIN32" PE_CHECKSUM="0x1C7E5" LINKER_VERSION="0x0" 
LINK_DATE="05/31/2008 
04:51:42" UPTO_LINK_DATE="05/31/2008 04:51:42" />
    <MATCHING_FILE NAME="Removepymssql.exe" SIZE="196096" CHECKSUM="0x71414A47" 
MODULE_TYPE="WIN32" PE_CHECKSUM="0x390FC" LINKER_VERSION="0x0" 
LINK_DATE="01/29/2009 
11:57:09" UPTO_LINK_DATE="01/29/2009 11:57:09" />
    <MATCHING_FILE NAME="Removepyodbc.exe" SIZE="66048" CHECKSUM="0xA032993F" 
MODULE_TYPE="WIN32" PE_CHECKSUM="0x1C7E5" LINKER_VERSION="0x0" 
LINK_DATE="05/31/2008 
04:51:42" UPTO_LINK_DATE="05/31/2008 04:51:42" />
    <MATCHING_FILE NAME="Removepyreadline.exe" SIZE="61440" CHECKSUM="0xF0A3B1E4" 
MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" 
LINK_DATE="02/03/2005 
20:37:43" UPTO_LINK_DATE="02/03/2005 20:37:43" />
    <MATCHING_FILE NAME="Removepywin32.exe" SIZE="196096" CHECKSUM="0x71414A47" 
MODULE_TYPE="WIN32" PE_CHECKSUM="0x390FC" LINKER_VERSION="0x0" 
LINK_DATE="01/29/2009 
11:57:09" UPTO_LINK_DATE="01/29/2009 11:57:09" />
    <MATCHING_FILE NAME="RemoveWMI.exe" SIZE="196096" CHECKSUM="0x71414A47" 
MODULE_TYPE="WIN32" PE_CHECKSUM="0x390FC" LINKER_VERSION="0x0" 
LINK_DATE="01/29/2009 
11:57:09" UPTO_LINK_DATE="01/29/2009 11:57:09" />
    <MATCHING_FILE NAME="w9xpopen.exe" SIZE="49664" CHECKSUM="0x4E298DA0" 
MODULE_TYPE="WIN32" PE_CHECKSUM="0xCFCD" LINKER_VERSION="0x0" 
LINK_DATE="03/19/2010 
20:52:14" UPTO_LINK_DATE="03/19/2010 20:52:14" />
    <MATCHING_FILE NAME="DLLs\sqlite3.dll" SIZE="571904" CHECKSUM="0x618C40DE" 
MODULE_TYPE="WIN32" PE_CHECKSUM="0x8F17F" LINKER_VERSION="0x0" 
LINK_DATE="03/19/2010 
20:53:15" UPTO_LINK_DATE="03/19/2010 20:53:15" />
    <MATCHING_FILE NAME="DLLs\tcl85.dll" SIZE="867328" CHECKSUM="0xCF388F56" 
BIN_FILE_VERSION="8.5.2.2" BIN_PRODUCT_VERSION="8.5.2.2" 
PRODUCT_VERSION="8.5.2" 
FILE_DESCRIPTION="Tcl DLL" COMPANY_NAME="ActiveState Corporation" 
PRODUCT_NAME="Tcl 
8.5 for Windows" FILE_VERSION="8.5.2" ORIGINAL_FILENAME="tcl85.dll" 
LEGAL_COPYRIGHT="Copyright © 2001 by ActiveState Corporation, et al" 
VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x4" VERFILETYPE="0x2" 
MODULE_TYPE="WIN32" PE_CHECKSUM="0xDDCB1" LINKER_VERSION="0x0" 
UPTO_BIN_FILE_VERSION="8.5.2.2" UPTO_BIN_PRODUCT_VERSION="8.5.2.2" 
LINK_DATE="11/06/2008 19:29:15" UPTO_LINK_DATE="11/06/2008 19:29:15" 
VER_LANGUAGE="Inglés (Estados Unidos) [0x409]" />
    <MATCHING_FILE NAME="DLLs\tclpip85.dll" SIZE="8192" CHECKSUM="0x13EA3659" 
MODULE_TYPE="WIN32" PE_CHECKSUM="0xBCF1" LINKER_VERSION="0x0" 
LINK_DATE="06/12/2008 
16:15:39" UPTO_LINK_DATE="06/12/2008 16:15:39" />
    <MATCHING_FILE NAME="DLLs\tk85.dll" SIZE="1319936" CHECKSUM="0x499C647D" 
BIN_FILE_VERSION="8.5.2.2" BIN_PRODUCT_VERSION="8.5.2.2" 
PRODUCT_VERSION="8.5.2" 
FILE_DESCRIPTION="Tk DLL" COMPANY_NAME="ActiveState Corporation" 
PRODUCT_NAME="Tk 
8.5 for Windows" FILE_VERSION="8.5.2" ORIGINAL_FILENAME="tk85.dll" 
LEGAL_COPYRIGHT="Copyright © 2001 by ActiveState Corporation, et al" 
VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x4" VERFILETYPE="0x2" 
MODULE_TYPE="WIN32" PE_CHECKSUM="0x145825" LINKER_VERSION="0x0" 
UPTO_BIN_FILE_VERSION="8.5.2.2" UPTO_BIN_PRODUCT_VERSION="8.5.2.2" 
LINK_DATE="11/06/2008 19:37:30" UPTO_LINK_DATE="11/06/2008 19:37:30" 
VER_LANGUAGE="Inglés (Estados Unidos) [0x409]" />
    <MATCHING_FILE NAME="Lib\distutils\command\wininst-6.0.exe" SIZE="61440" 
CHECKSUM="0xE589B8AD" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" 
LINKER_VERSION="0x0" 
LINK_DATE="05/31/2008 04:52:45" UPTO_LINK_DATE="05/31/2008 04:52:45" />
    <MATCHING_FILE NAME="Lib\distutils\command\wininst-7.1.exe" SIZE="65536" 
CHECKSUM="0xA2833DFD" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" 
LINKER_VERSION="0x0" 
LINK_DATE="05/31/2008 04:53:42" UPTO_LINK_DATE="05/31/2008 04:53:42" />
    <MATCHING_FILE NAME="Lib\distutils\command\wininst-8.0.exe" SIZE="61440" 
CHECKSUM="0x8527B654" MODULE_TYPE="WIN32" PE_CHECKSUM="0x1701B" 
LINKER_VERSION="0x0" 
LINK_DATE="10/04/2006 15:16:27" UPTO_LINK_DATE="10/04/2006 15:16:27" />
    <MATCHING_FILE NAME="Lib\distutils\command\wininst-9.0-amd64.exe" SIZE="223744" 
CHECKSUM="0x70C19EE" MODULE_TYPE="WIN32" PE_CHECKSUM="0x41E86" 
LINKER_VERSION="0x0" 
LINK_DATE="01/29/2009 11:57:34" UPTO_LINK_DATE="01/29/2009 11:57:34" />
    <MATCHING_FILE NAME="Lib\distutils\command\wininst-9.0.exe" SIZE="196096" 
CHECKSUM="0x71414A47" MODULE_TYPE="WIN32" PE_CHECKSUM="0x390FC" 
LINKER_VERSION="0x0" 
LINK_DATE="01/29/2009 11:57:09" UPTO_LINK_DATE="01/29/2009 11:57:09" />
    <MATCHING_FILE NAME="Lib\site-packages\isapi\PyISAPI_loader.dll" SIZE="44032" 
CHECKSUM="0x11AE7B41" BIN_FILE_VERSION="2.6.214.0" 
BIN_PRODUCT_VERSION="2.6.214.0" 
PRODUCT_VERSION="2.6.214.0" FILE_DESCRIPTION="" COMPANY_NAME="" 
PRODUCT_NAME="PyWin32" FILE_VERSION="2.6.214.0" 
ORIGINAL_FILENAME="PyISAPI_loader.dll" INTERNAL_NAME="PyISAPI_loader.dll" 
LEGAL_COPYRIGHT="" VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" 
VERFILETYPE="0x2" MODULE_TYPE="WIN32" PE_CHECKSUM="0x114A4" 
LINKER_VERSION="0x0" 
UPTO_BIN_FILE_VERSION="2.6.214.0" UPTO_BIN_PRODUCT_VERSION="2.6.214.0" 
LINK_DATE="07/05/2009 02:40:38" UPTO_LINK_DATE="07/05/2009 02:40:38" 
VER_LANGUAGE="Inglés (Estados Unidos) [0x409]" />
    <MATCHING_FILE NAME="Lib\site-packages\py2exe\run.exe" SIZE="17408" 
CHECKSUM="0xB75F5388" MODULE_TYPE="WIN32" PE_CHECKSUM="0x4D16" 
LINKER_VERSION="0x0" 
LINK_DATE="11/10/2008 09:40:43" UPTO_LINK_DATE="11/10/2008 09:40:43" />
    <MATCHING_FILE NAME="Lib\site-packages\py2exe\run_ctypes_dll.dll" SIZE="19456" 
CHECKSUM="0xAF5F5499" MODULE_TYPE="WIN32" PE_CHECKSUM="0x8D59" 
LINKER_VERSION="0x0" 
LINK_DATE="11/10/2008 09:40:45" UPTO_LINK_DATE="11/10/2008 09:40:45" />
    <MATCHING_FILE NAME="Lib\site-packages\py2exe\run_dll.dll" SIZE="19968" 
CHECKSUM="0xD3D2F6CB" MODULE_TYPE="WIN32" PE_CHECKSUM="0x6821" 
LINKER_VERSION="0x0" 
LINK_DATE="11/10/2008 09:40:44" UPTO_LINK_DATE="11/10/2008 09:40:44" />
    <MATCHING_FILE NAME="Lib\site-packages\py2exe\run_isapi.dll" SIZE="20480" 
CHECKSUM="0x7D1AE27" MODULE_TYPE="WIN32" PE_CHECKSUM="0x6588" 
LINKER_VERSION="0x0" 
LINK_DATE="11/10/2008 09:40:45" UPTO_LINK_DATE="11/10/2008 09:40:45" />
    <MATCHING_FILE NAME="Lib\site-packages\py2exe\run_w.exe" SIZE="17408" 
CHECKSUM="0x91C517D8" MODULE_TYPE="WIN32" PE_CHECKSUM="0x12F3D" 
LINKER_VERSION="0x0" 
LINK_DATE="11/10/2008 09:40:44" UPTO_LINK_DATE="11/10/2008 09:40:44" />
    <MATCHING_FILE NAME="Lib\site-packages\pythonwin\mfc90.dll" SIZE="1156600" 
CHECKSUM="0x3B8F4E43" BIN_FILE_VERSION="9.0.21022.8" 
BIN_PRODUCT_VERSION="9.0.21022.8" PRODUCT_VERSION="9.00.21022.08" 
FILE_DESCRIPTION="MFCDLL Shared Library - Retail Version" 
COMPANY_NAME="Microsoft 
Corporation" PRODUCT_NAME="Microsoft® Visual Studio® 2008" 
FILE_VERSION="9.00.21022.08" ORIGINAL_FILENAME="MFC90.DLL" 
INTERNAL_NAME="MFC90.DLL" 
LEGAL_COPYRIGHT="© Microsoft Corporation.  All rights reserved." 
VERFILEDATEHI="0x0" 
VERFILEDATELO="0x0" VERFILEOS="0x4" VERFILETYPE="0x2" MODULE_TYPE="WIN32" 
PE_CHECKSUM="0x129E67" LINKER_VERSION="0x90000" 
UPTO_BIN_FILE_VERSION="9.0.21022.8" 
UPTO_BIN_PRODUCT_VERSION="9.0.21022.8" LINK_DATE="11/07/2007 06:49:58" 
UPTO_LINK_DATE="11/07/2007 06:49:58" VER_LANGUAGE="Inglés (Estados Unidos) 
[0x409]" /
>
    <MATCHING_FILE NAME="Lib\site-packages\pythonwin\mfc90u.dll" SIZE="1162744" 
CHECKSUM="0xEA777280" BIN_FILE_VERSION="9.0.21022.8" 
BIN_PRODUCT_VERSION="9.0.21022.8" PRODUCT_VERSION="9.00.21022.08" 
FILE_DESCRIPTION="MFCDLL Shared Library - Retail Version" 
COMPANY_NAME="Microsoft 
Corporation" PRODUCT_NAME="Microsoft® Visual Studio® 2008" 
FILE_VERSION="9.00.21022.08" ORIGINAL_FILENAME="MFC90U.DLL" 
INTERNAL_NAME="MFC90U.DLL" LEGAL_COPYRIGHT="© Microsoft Corporation.  All 
rights 
reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x4" 
VERFILETYPE="0x2" 
MODULE_TYPE="WIN32" PE_CHECKSUM="0x1278D3" LINKER_VERSION="0x90000" 
UPTO_BIN_FILE_VERSION="9.0.21022.8" UPTO_BIN_PRODUCT_VERSION="9.0.21022.8" 
LINK_DATE="11/07/2007 06:50:18" UPTO_LINK_DATE="11/07/2007 06:50:18" 
VER_LANGUAGE="Inglés (Estados Unidos) [0x409]" />
    <MATCHING_FILE NAME="Lib\site-packages\pythonwin\mfcm90.dll" SIZE="59904" 
CHECKSUM="0xF8CC0720" BIN_FILE_VERSION="9.0.21022.8" 
BIN_PRODUCT_VERSION="9.0.21022.8" PRODUCT_VERSION="9.00.21022.08" 
FILE_DESCRIPTION="MFC Managed Library - Retail Version" COMPANY_NAME="Microsoft 
Corporation" PRODUCT_NAME="Microsoft® Visual Studio® 2008" 
FILE_VERSION="9.00.21022.08" ORIGINAL_FILENAME="MFCM90.DLL" 
INTERNAL_NAME="MFCM90.DLL" LEGAL_COPYRIGHT="© Microsoft Corporation.  All 
rights 
reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x4" 
VERFILETYPE="0x2" 
MODULE_TYPE="WIN32" PE_CHECKSUM="0x1B0A0" LINKER_VERSION="0x90000" 
UPTO_BIN_FILE_VERSION="9.0.21022.8" UPTO_BIN_PRODUCT_VERSION="9.0.21022.8" 
LINK_DATE="11/07/2007 06:51:04" UPTO_LINK_DATE="11/07/2007 06:51:04" 
VER_LANGUAGE="Inglés (Estados Unidos) [0x409]" />
    <MATCHING_FILE NAME="Lib\site-packages\pythonwin\mfcm90u.dll" SIZE="59904" 
CHECKSUM="0x1504521D" BIN_FILE_VERSION="9.0.21022.8" 
BIN_PRODUCT_VERSION="9.0.21022.8" PRODUCT_VERSION="9.00.21022.08" 
FILE_DESCRIPTION="MFC Managed Library - Retail Version" COMPANY_NAME="Microsoft 
Corporation" PRODUCT_NAME="Microsoft® Visual Studio® 2008" 
FILE_VERSION="9.00.21022.08" ORIGINAL_FILENAME="MFCM90U.DLL" 
INTERNAL_NAME="MFCM90U.DLL" LEGAL_COPYRIGHT="© Microsoft Corporation.  All 
rights 
reserved." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x4" 
VERFILETYPE="0x2" 
MODULE_TYPE="WIN32" PE_CHECKSUM="0x16F4B" LINKER_VERSION="0x90000" 
UPTO_BIN_FILE_VERSION="9.0.21022.8" UPTO_BIN_PRODUCT_VERSION="9.0.21022.8" 
LINK_DATE="11/07/2007 06:51:05" UPTO_LINK_DATE="11/07/2007 06:51:05" 
VER_LANGUAGE="Inglés (Estados Unidos) [0x409]" />
    <MATCHING_FILE NAME="Lib\site-packages\pythonwin\Pythonwin.exe" SIZE="19968" 
CHECKSUM="0xEBEC9D45" BIN_FILE_VERSION="2.6.214.0" 
BIN_PRODUCT_VERSION="2.6.214.0" 
PRODUCT_VERSION="2.6.214.0" FILE_DESCRIPTION="" COMPANY_NAME="" 
PRODUCT_NAME="PyWin32" FILE_VERSION="2.6.214.0" 
ORIGINAL_FILENAME="Pythonwin.exe" 
INTERNAL_NAME="Pythonwin.exe" LEGAL_COPYRIGHT="" VERFILEDATEHI="0x0" 
VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x1" MODULE_TYPE="WIN32" 
PE_CHECKSUM="0x96F3" LINKER_VERSION="0x0" UPTO_BIN_FILE_VERSION="2.6.214.0" 
UPTO_BIN_PRODUCT_VERSION="2.6.214.0" LINK_DATE="07/05/2009 02:40:41" 
UPTO_LINK_DATE="07/05/2009 02:40:41" VER_LANGUAGE="Inglés (Estados Unidos) 
[0x409]" /
>
    <MATCHING_FILE NAME="Lib\site-packages\pythonwin\scintilla.dll" SIZE="416256" 
CHECKSUM="0x918E961F" BIN_FILE_VERSION="1.7.7.0" BIN_PRODUCT_VERSION="1.7.7.0" 
PRODUCT_VERSION="1.77" FILE_DESCRIPTION="Scintilla.DLL - a Source Editing 
Component" 
COMPANY_NAME="Neil Hodgson neilh@scintilla.org" PRODUCT_NAME="Scintilla" 
FILE_VERSION="1.77" ORIGINAL_FILENAME="Scintilla.DLL" INTERNAL_NAME="Scintilla" 
LEGAL_COPYRIGHT="Copyright 1998-2008 by Neil Hodgson" VERFILEDATEHI="0x0" 
VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x1" MODULE_TYPE="WIN32" 
PE_CHECKSUM="0x0" LINKER_VERSION="0x0" UPTO_BIN_FILE_VERSION="1.7.7.0" 
UPTO_BIN_PRODUCT_VERSION="1.7.7.0" LINK_DATE="07/05/2009 02:41:03" 
UPTO_LINK_DATE="07/05/2009 02:41:03" VER_LANGUAGE="Inglés (Estados Unidos) 
[0x409]" /
>
    <MATCHING_FILE NAME="Lib\site-packages\pywin32_system32\pythoncom26.dll" 
SIZE="354304" CHECKSUM="0xB42F350B" BIN_FILE_VERSION="2.6.214.0" 
BIN_PRODUCT_VERSION="2.6.214.0" PRODUCT_VERSION="2.6.214.0" FILE_DESCRIPTION="" 
COMPANY_NAME="" PRODUCT_NAME="PyWin32" FILE_VERSION="2.6.214.0" 
ORIGINAL_FILENAME="pythoncom26.dll" INTERNAL_NAME="pythoncom26.dll" 
LEGAL_COPYRIGHT="" VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" 
VERFILETYPE="0x2" MODULE_TYPE="WIN32" PE_CHECKSUM="0x5D1C4" 
LINKER_VERSION="0x0" 
UPTO_BIN_FILE_VERSION="2.6.214.0" UPTO_BIN_PRODUCT_VERSION="2.6.214.0" 
LINK_DATE="07/05/2009 02:36:42" UPTO_LINK_DATE="07/05/2009 02:36:42" 
VER_LANGUAGE="Inglés (Estados Unidos) [0x409]" />
    <MATCHING_FILE NAME="Lib\site-packages\pywin32_system32\pywintypes26.dll" 
SIZE="110592" CHECKSUM="0xEFC7FB2A" BIN_FILE_VERSION="2.6.214.0" 
BIN_PRODUCT_VERSION="2.6.214.0" PRODUCT_VERSION="2.6.214.0" FILE_DESCRIPTION="" 
COMPANY_NAME="" PRODUCT_NAME="PyWin32" FILE_VERSION="2.6.214.0" 
ORIGINAL_FILENAME="pywintypes26.dll" INTERNAL_NAME="pywintypes26.dll" 
LEGAL_COPYRIGHT="" VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" 
VERFILETYPE="0x2" MODULE_TYPE="WIN32" PE_CHECKSUM="0x24D09" 
LINKER_VERSION="0x0" 
UPTO_BIN_FILE_VERSION="2.6.214.0" UPTO_BIN_PRODUCT_VERSION="2.6.214.0" 
LINK_DATE="07/05/2009 02:35:18" UPTO_LINK_DATE="07/05/2009 02:35:18" 
VER_LANGUAGE="Inglés (Estados Unidos) [0x409]" />
    <MATCHING_FILE NAME="Lib\site-packages\win32\perfmondata.dll" SIZE="12800" 
CHECKSUM="0xA06FF196" BIN_FILE_VERSION="2.6.214.0" 
BIN_PRODUCT_VERSION="2.6.214.0" 
PRODUCT_VERSION="2.6.214.0" FILE_DESCRIPTION="" COMPANY_NAME="" 
PRODUCT_NAME="PyWin32" FILE_VERSION="2.6.214.0" 
ORIGINAL_FILENAME="perfmondata.dll" 
INTERNAL_NAME="perfmondata.dll" LEGAL_COPYRIGHT="" VERFILEDATEHI="0x0" 
VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x2" MODULE_TYPE="WIN32" 
PE_CHECKSUM="0x5687" LINKER_VERSION="0x0" UPTO_BIN_FILE_VERSION="2.6.214.0" 
UPTO_BIN_PRODUCT_VERSION="2.6.214.0" LINK_DATE="07/05/2009 02:35:19" 
UPTO_LINK_DATE="07/05/2009 02:35:19" VER_LANGUAGE="Inglés (Estados Unidos) 
[0x409]" /
>
    <MATCHING_FILE NAME="Lib\site-packages\win32\pythonservice.exe" SIZE="11776" 
CHECKSUM="0xE642C8FF" BIN_FILE_VERSION="2.6.214.0" 
BIN_PRODUCT_VERSION="2.6.214.0" 
PRODUCT_VERSION="2.6.214.0" FILE_DESCRIPTION="" COMPANY_NAME="" 
PRODUCT_NAME="PyWin32" FILE_VERSION="2.6.214.0" 
ORIGINAL_FILENAME="pythonservice.exe" INTERNAL_NAME="pythonservice.exe" 
LEGAL_COPYRIGHT="" VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" 
VERFILETYPE="0x1" MODULE_TYPE="WIN32" PE_CHECKSUM="0x5160" LINKER_VERSION="0x0" 
UPTO_BIN_FILE_VERSION="2.6.214.0" UPTO_BIN_PRODUCT_VERSION="2.6.214.0" 
LINK_DATE="07/05/2009 02:40:38" UPTO_LINK_DATE="07/05/2009 02:40:38" 
VER_LANGUAGE="Inglés (Estados Unidos) [0x409]" />
    <MATCHING_FILE NAME="tcl\dde1.3\tcldde13.dll" SIZE="18944" CHECKSUM="0x5F6F6F2F" 
MODULE_TYPE="WIN32" PE_CHECKSUM="0x138A6" LINKER_VERSION="0x0" 
LINK_DATE="06/12/2008 
19:01:43" UPTO_LINK_DATE="06/12/2008 19:01:43" />
    <MATCHING_FILE NAME="tcl\reg1.2\tclreg12.dll" SIZE="18432" CHECKSUM="0xBEEC9FAD" 
MODULE_TYPE="WIN32" PE_CHECKSUM="0xC2A5" LINKER_VERSION="0x0" 
LINK_DATE="06/12/2008 
19:01:42" UPTO_LINK_DATE="06/12/2008 19:01:42" />
    <MATCHING_FILE NAME="tcl\tix8.4.3\tix84.dll" SIZE="262656" CHECKSUM="0x3E0EAE66" 
MODULE_TYPE="WIN32" PE_CHECKSUM="0x4825B" LINKER_VERSION="0x0" 
LINK_DATE="02/13/2009 
17:17:04" UPTO_LINK_DATE="02/13/2009 17:17:04" />
</EXE>
<EXE NAME="_mssql.pyd" FILTER="GRABMI_FILTER_THISFILEONLY">
    <MATCHING_FILE NAME="_mssql.pyd" SIZE="345088" CHECKSUM="0x3D9DB21F" 
MODULE_TYPE="WIN32" PE_CHECKSUM="0x56780" LINKER_VERSION="0x0" 
LINK_DATE="04/28/2010 
10:16:29" UPTO_LINK_DATE="04/28/2010 10:16:29" />
</EXE>
<EXE NAME="kernel32.dll" FILTER="GRABMI_FILTER_THISFILEONLY">
    <MATCHING_FILE NAME="kernel32.dll" SIZE="1042944" CHECKSUM="0x8B19B2F6" 
BIN_FILE_VERSION="5.1.2600.5781" BIN_PRODUCT_VERSION="5.1.2600.5781" 
PRODUCT_VERSION="5.1.2600.5781" FILE_DESCRIPTION="DLL de cliente API BASE de 
Windows 
NT" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="Sistema operativo 
Microsoft® 
Windows®" FILE_VERSION="5.1.2600.5781 (xpsp_sp3_gdr.090321-1317)" 
ORIGINAL_FILENAME="kernel32" INTERNAL_NAME="kernel32" 
LEGAL_COPYRIGHT="Copyright (C) 
Microsoft Corporation. Reservados todos los derechos." VERFILEDATEHI="0x0" 
VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x2" MODULE_TYPE="WIN32" 
PE_CHECKSUM="0x101E85" LINKER_VERSION="0x50001" 
UPTO_BIN_FILE_VERSION="5.1.2600.5781" UPTO_BIN_PRODUCT_VERSION="5.1.2600.5781" 
LINK_DATE="03/21/2009 14:08:18" UPTO_LINK_DATE="03/21/2009 14:08:18" 
VER_LANGUAGE="Español (alfabetización internacional) [0xc0a]" />
</EXE>
</DATABASE>

Original comment by luisgarc...@gmail.com on 24 May 2010 at 1:41

GoogleCodeExporter commented 8 years ago
Having the same problem here.

Windows XP SP3,
Python 2.6.5
pymssql-1.9.908-py2.6

Original comment by szca...@gmail.com on 5 Jul 2010 at 6:39

GoogleCodeExporter commented 8 years ago
It can be "solved" if you just import pymssql first than anything else.  
I think the "WSAENOBUFS: No buffer space available." is not a problem when 
nobody has used WSAENOBUFS.
It works for me now.

Original comment by aaceves....@gmail.com on 14 Jul 2010 at 6:38

GoogleCodeExporter commented 8 years ago
Problem occurs whether I import pymssql or _mssql first.  This is on 

OS Name Microsoft Windows XP Professional
Version 5.1.2600 Service Pack 3 Build 2600
Python 2.6.4 (r264:75708, Oct 26 2009, 08:23:19) [MSC v.1500 32 bit (Intel)] on 
win32
pymssql-1.9.908.win32.py2.6

Using any GUI interface to python, be it IDLE or pyscripter, etc.  Directly 
from the command line python interface it will import successfully.

Original comment by twal...@thetatts.com on 15 Jul 2010 at 4:16

GoogleCodeExporter commented 8 years ago
Same here. Brand new install of Windows Server 2008 64 bit. import _mssql first 
doesn't solve the problem. Still crashes.

In fact, if I create a one line program of

import _mssql

It still crashes

OS Name:                   Microsoft Windows Server 2008 Standard
OS Version:                6.0.6002 Service Pack 2 Build 6002
OS Manufacturer:           Microsoft Corporation
OS Configuration:          Standalone Server
OS Build Type:             Multiprocessor Free
Registered Owner:          Windows User
Registered Organization:
Original Install Date:     3/1/2010, 11:03:49 PM
System Boot Time:          7/15/2010, 1:57:28 PM
System Manufacturer:       VMware, Inc.
System Model:              VMware Virtual Platform
System Type:               x64-based PC
Processor(s):              1 Processor(s) Installed.
                           [01]: Intel64 Family 6 Model 15 Stepping 1 Ge
el ~1995 Mhz
BIOS Version:              Phoenix Technologies LTD 6.00, 9/22/2009
Windows Directory:         C:\Windows
System Directory:          C:\Windows\system32
Boot Device:               \Device\HarddiskVolume1
System Locale:             en-us;English (United States)
Input Locale:              en-us;English (United States)
Time Zone:                 (GMT-08:00) Pacific Time (US & Canada)
Total Physical Memory:     2,047 MB
Available Physical Memory: 1,166 MB
Page File: Max Size:       4,331 MB
Page File: Available:      3,451 MB
Page File: In Use:         880 MB
Page File Location(s):     C:\pagefile.sys
Domain:                    WORKGROUP

Original comment by abaw...@gmail.com on 16 Jul 2010 at 12:03

GoogleCodeExporter commented 8 years ago
Crashes for me when the `socket` module is imported before `pymssql`.
Example:

python import -c "import socket, pymssql"

crashes, while

python import -c "import pymssql, socket"

works correctly.

Original comment by x...@resolvent.net on 24 Jul 2010 at 1:39

GoogleCodeExporter commented 8 years ago
There doesn't seem to have been any movement in the past several months on this 
showstopper (for a fair number of people, at least) issue. Is the project 
currently stalled/dead?

Original comment by eavesdown on 28 Jul 2010 at 10:04

GoogleCodeExporter commented 8 years ago
I don't know how much development has been going down on this, but I've run 
into this error as well only both Netbeans and when running the script from the 
command line.  If I import it with the python command line, it seems to work 
fine.  I'm running Win7 32-bit w/ 2GB RAM on a Core 2 Duo and Python 2.6.5.

The workaround I have found is to change the module import order at the 
beginning of my file:

import smtplib         import pymssql
import poplib    ->    import smtplib
import pymssql         import poplib

As long as pymssql is imported first the script will execute no problem.  This 
only applies to modules imported from directories other than the current one 
and its subdirectories.  For some reason this crashes the interpreter.  Still 
working on why though.

Original comment by daemonbu...@gmail.com on 19 Aug 2010 at 8:33

GoogleCodeExporter commented 8 years ago
The problem is caused by a bug in freetds, which was fixed here:
http://freetds.cvs.sourceforge.net/viewvc/freetds/freetds/src/tds/mem.c?r1=1.194
&r2=1.195

I attached pymssql win32 binary installer rebuilt against a nightly snapshot of 
freetds.
No guarantees, but it seems to work for me.

Original comment by x...@resolvent.net on 24 Aug 2010 at 9:22

Attachments:

GoogleCodeExporter commented 8 years ago
Thanks for the repack, xi. I no longer see the crashes on my Windows XP or 
Server 2008 systems. I'm noticing a few other bugs with the new version, but I 
still think it would be a good idea to release an official beta build with the 
updated FreeTDS library to allow users that were previously seeing the crashes 
to support the testing process.

Original comment by eavesdown on 24 Aug 2010 at 9:46

GoogleCodeExporter commented 8 years ago
It seems that we need help with pymssql development. If you are able to 
contribute and/or continue the development, don't hesitate to contact me by 
email.

Original comment by akuk...@gmail.com on 24 Aug 2010 at 11:12

GoogleCodeExporter commented 8 years ago
i am using Windows 7 Ulitmate, even tried the repacked version. still it is 
crashing when import.

Original comment by mihi...@mtechlanka.com on 25 Sep 2010 at 12:32

GoogleCodeExporter commented 8 years ago
I have this problem too.
If I import pymssql first and then it is working but when I try to debug then 
on the first line (import pymssql) itself is getting crashed. 
(I haven't tested the repacked pymssql which is available in this thread)

Original comment by radhika....@gmail.com on 26 Sep 2010 at 12:18

GoogleCodeExporter commented 8 years ago
IDLE under Win7 crashed, but just fine in PythonWin and cmd

Original comment by als...@gmail.com on 23 Oct 2010 at 4:22

GoogleCodeExporter commented 8 years ago
Idle & Eclipse crashed.
command line works fine

Windows XP sp3
python 2.6.6
Elcipse 3.6.1(pydev 1.6.3.2010100513)

Original comment by nkgai...@gmail.com on 25 Nov 2010 at 2:03

GoogleCodeExporter commented 8 years ago

Original comment by dam...@gmail.com on 8 Mar 2011 at 3:36

GoogleCodeExporter commented 8 years ago
I had a similar issue. A quick fix is to simply import the pymssql module 
before anything else that might import the socket module. I had the issue with 
suds and pymssql, but if pymssql is imported before suds there's no problem. 

Original comment by lyngsh...@gmail.com on 12 Apr 2011 at 11:13

GoogleCodeExporter commented 8 years ago
I can confirm that this issue is real.  I had a script that when run as main 
worked just fine, but when I tried to import that module into a CherryPy web 
application, I was unable to get it running.  Ostensibly this is an issue of 
competition for ports between CherryPy and pymssql.

However - the installer linked in comment 24 above does in fact work for me.  
Perhaps that ought to be posted as an updated version so that new users can 
hopefully avoid this problem...

Original comment by brad.ala...@gmail.com on 12 Oct 2011 at 8:42

GoogleCodeExporter commented 8 years ago
I haven't seen this behavior in the HG tip version so I'm going to close.

Original comment by rsyr...@gmail.com on 8 Mar 2012 at 2:56

GoogleCodeExporter commented 8 years ago
Python27 crashes when my py2exe created app encounters import _mssql ONLY on 
Win 7 32bit boxes. 64bit works fine.

I have see similar fails reported in past and I have tried all the workarounds 
I could find but none were limited to 32bit Win7 OS only.

Original comment by jimnyfr...@gmail.com on 21 Aug 2014 at 8:22

Attachments: