Issue 33: karrigell crash
Status:  NoFix
Owner: ----
Closed:  Sep 2010
Reported by ld2...@21cn.com, Feb 7, 2009
with karrigell
when refresh webpage, python.exe crashes


Feb 7, 2009
Project Member #1 mkleehammer
What kind of troubleshooting information do we have available?

What operating system and version of pyodbc are you using?  (Also, make sure you are
using a 2.1.x version, not 2.0.x).  What database driver and what was passed to pyodbc?

If you can simplify the test to a single page and a single query, it would be easier
to isolate.
Status: Investigating
Feb 8, 2009
#2 ld2...@21cn.com
winxp python2.54 karrigell2.40 pyodbc2.13
code:
# -*- coding:utf-8 -*-

import pyodbc

cnxt_str = "DSN=datang;UID=datang;PWD=datang"
sql_select = "select * from bp_j_stat_rtj order by item_code asc"

try:
    cursor = pyodbc.connect(cnxt_str).cursor()
    rows = cursor.execute(sql_select).fetchall()
except:
    print u"找不到服务器!"
    raise SCRIPT_END

print "<TABLE border = 1>"
for rec in rows:
    print "<TR>"
    print "<TD>", rec[3], "</TD>"
    print "<TD>", rec[2], "</TD>"
    print "<TD>", rec[4], "</TD>"
    print "</TR>"
print "</TABLE>"

first succeed, refresh this page down
Clipboard.jpg
37.3 KB   View   Download
Feb 8, 2009
#3 ld2...@21cn.com
sorry
Clipboard2.jpg
38.3 KB   View   Download
3768_appcompat.txt
12.7 KB   Download
Feb 8, 2009
#4 ld2...@21cn.com
btw, ceODBC no problem
http://ceodbc.sourceforge.net/
Dec 31, 2009
Project Member #5 mkleehammer
I've got to be honest here, I can't really make sense of the language :)

What database are you using?  The code only shows the DSN, not the reset of the connection information.

Also, can you create a script *outside* of the web application to reproduce this?
Sep 6, 2010
Project Member #6 mkleehammer
Closing due to lack of response.  Sorry.  Please retest with 2.1.8 and reopen if you are still having problems.

Status: Invalid
Nov 21, 2010
Project Member #7 mkleehammer
(No comment was entered for this change.)
Status: NoFix