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
>
> **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
>
>
_______________________________________________
python-win32 mailing list
python-win32@python.org
http://mail.python.org/mailman/listinfo/python-win32
