|
From: SourceForge.net <no...@so...> - 2005-03-10 08:19:42
|
Bugs item #1160437, was opened at 2005-03-10 07:27 Message generated for change (Comment added) made by jiangwen365 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() ---------------------------------------------------------------------- >Comment By: 江文 (jiangwen365) Date: 2005-03-10 08:19 Message: Logged In: YES user_id=1147025 Oh, when commenting out the MDB block and leaving the Postgres block, Python would crash much sooner. Exactly the fifith loop, aftter printing out "connecting Postgres" on my machine! But it seems to work pretty smoothly with the MDB block only. So it's more likly a Postgres ODBC driver bug. I'v submitted this to the postgres odbc developer group: http://gborg.postgresql.org/project/psqlodbc/bugs/bugupdate.php?1207 I don't know if it would be helpful if somebody here can provide some debug info to the postgres ODBC team? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=551954&aid=1160437&group_id=78018 |
