[DB-SIG] pyodbc and decimal datatypes

Chris Curvey ccurvey at gmail.com
Fri Mar 31 18:08:28 CEST 2006


I hope I have the right list for this question...

According to the homepage for pyodbc, pyodbc supports decimal data types,
but when I try to copy a row from one table to another, I'm getting:

pyodbc.NotSupportedError: ('Python type Decimal not supported.  param=26',
'HY097')

the code looks like:

srcCursor.execute("select * from foo")
for row in srcCursor:
     targetCursor.execute("insert into bar ( ?, ?, ?, ....", row)

(Where bar is an empty copy of foo).

Using pyodbc 2.0.16 with python 2.4.1 on Windows XP



--
Nervous passengers are advised to wear a blindfold.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.python.org/pipermail/db-sig/attachments/20060331/4a14f60c/attachment.html 


More information about the DB-SIG mailing list