|
From: SourceForge.net <no...@so...> - 2005-03-10 07:27:19
|
Bugs item #1160437, was opened at 2005-03-10 07:27 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=551954&aid=1160437&group_id=78018 Category: None Group: None Status: Open Resolution: None Priority: 5 Submitted By: 江文 (jiangwen365) Assigned to: Nobody/Anonymous (nobody) Summary: Connect different DSNs servial times and Python would crash. Initial Comment: Hi, When I run the script listed below, Python VM would crash, and usually within 20 seconds. "HScode_MDB" is the ODBC DSN pointing to an Access MDB file, "HScode" is the ODBC DSN pointing to a PostgreSQL Server. Dunno it's a bug of ODBC module or the ODBC drivers. But somehow it seems more like the ODBC module's bug. import dbi,odbc while True: print 'connecting MDB' a=odbc.odbc("HScode_MDB") # a DSN print 'getting MDB cursor' ac=a.cursor() ac.execute('SELECT * FROM [latest_parts]') # some operations ac.fetchall() ac.close() a.close() print 'connecting Postgres' b=odbc.odbc("HScode") # another DSN print 'getting postgres cursor' bc=b.cursor() bc.execute('select * from latest_parts limit 1') # some operations #print bc.fetchall() bc.close() b.close() ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=551954&aid=1160437&group_id=78018 |
