[pywin32-bugs] [ pywin32-Bugs-1257754 ] dbi.internal-error executing stored procedure

[SourceForge.net <no...@so...>]

Bugs item #1257754, was opened at 2005-08-12 10:48
Message generated for change (Settings changed) made by goldfita
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=551954&aid=1257754&group_id=78018

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: win32
Group: None
>Status: Closed
Resolution: None
Priority: 5
Submitted By: Todd (goldfita)
Assigned to: Nobody/Anonymous (nobody)
Summary: dbi.internal-error executing stored procedure

Initial Comment:
Sorry if this is not a bug.  I haven't been able to find 
much documentation.  I get the following error:
dbi.internal-error: [Microsoft][ODBC SQL Server Driver]
Invalid Descriptor Index
in FETCH

The table has an image column and a timestamp 
column, and I just select a single row.  I was able to 
execute other stored procedures without trouble.  And I 
can execute the one that causes a problem without 
trouble using jdbc.  I tried shortening the data in the 
image column to just a few bytes, but that didn't help.

The code is below.

import dbi, odbc
try:
        s = odbc.odbc('xxx/xxx/xxx')
        cur = s.cursor()
        cur.execute('exec my_proc 5')
        print cur.fetchone()
except NameError,e:
        print 'error ', e, 'undefined'

See also - http://mail.python.org/pipermail/tutor/2001-
March/004637.html

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=551954&aid=1257754&group_id=78018