[python-win32] python.exe crashes while connecting to the MSSQL Database on remote machine using pyodbc module

[siddhartha veedaluru]

Hi,

Summary-:  python.exe crashes while connecting to the MSSQL Database on
remote machine using pyodbc module
OS-: win 2003 server, 32bit
Installed python products: python 2.5,pyodbc-2.0.52,pywin32-211

Problem Description & Steps followed:
i have MSSQL Database on a remote machine
i have created a System DSN in my local machine using python script which
uses ctypes module
using pyodbc module i'm trying to connect to remote database.

sometimes python.exe crashes in the connect function

if i reboot the machine, i can connect it,but next try to connect crashes
python.exe

Attached are the dmp files of the crash.

Following is the code snippet of my script that are used to do the above
tasks

Script to Create a System DSN
----------------------------------------------
def create_sys_dsn(driver, **kw):
    "Create a  system DSN"
    ODBC_ADD_SYS_DSN = 4
    nul = chr(0)
    attributes = []
    for attr in kw.keys():
        atrbStr = "%s=%s" % (attr, kw[attr])
        #print atrbStr
        attributes.append(atrbStr)
    #print driver
    return ctypes.windll.ODBCCP32.SQLConfigDataSource(0, ODBC_ADD_SYS_DSN,
driver, nul.join(attributes))

retCode = create_sys_dsn("SQL Server", SERVER=server, DESCRIPTION="TestDB
DSN", DSN="TestDB", Database="testDB")
if retCode != 1:
    mesg = "Cannot Create TestDB DSN"
    print mesg
    sys.exit(1)
else:
    mesg = "TestDB DSN Created"
    print mesg
    sys.exit(0)
---------------------------------------------------------------------------

Script to connect to database
---------------------------------------------------------------------------
import pyodbc
try:
            DBCon = pyodbc.connect("DSN=TestDB;UID=tester;PWD=tester")
except pyodbc.Error, erno:
            mesg = "Unable to connect testDB Database check the UserID and
Password"
            print mesg,erno
            return 1
return 0
:
:
:
:
DBCon.close()

Please Help me out
take a look or forward to concerned developers
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-win32/attachments/20081217/a14a18bb/attachment-0001.htm>