search

tanrj / pyodbc

Automatically exported from code.google.com/p/pyodbc
MIT No Attribution
0 stars 0 forks source link

karrigell crash #33

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
with karrigell
when refresh webpage, python.exe crashes

Original issue reported on code.google.com by ld2...@21cn.com on 7 Feb 2009 at 11:04

GoogleCodeExporter commented 8 years ago 
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.

Original comment by mkleehammer on 7 Feb 2009 at 3:35

GoogleCodeExporter commented 8 years ago 
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

Original comment by ld2...@21cn.com on 9 Feb 2009 at 12:38

Attachments:

GoogleCodeExporter commented 8 years ago 
sorry

Original comment by ld2...@21cn.com on 9 Feb 2009 at 12:40

Attachments:

GoogleCodeExporter commented 8 years ago 
btw, ceODBC no problem
http://ceodbc.sourceforge.net/

Original comment by ld2...@21cn.com on 9 Feb 2009 at 12:43

GoogleCodeExporter commented 8 years ago 
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?

Original comment by mkleehammer on 1 Jan 2010 at 6:43

GoogleCodeExporter commented 8 years ago 
Closing due to lack of response.  Sorry.  Please retest with 2.1.8 and reopen 
if you are still having problems.

Original comment by mkleehammer on 6 Sep 2010 at 6:11

GoogleCodeExporter commented 8 years ago

Original comment by mkleehammer on 21 Nov 2010 at 4:43