Win32 Extension ADO with SQL Server Problem to insert money datatype with a stored procedure

[Quinet, Joel]

Hi all,

I use the Win32 extension (Build 157) module with Python 2.3 to add row in a
sql server 2000 sp3 DB.
My problem is I can not insert data of type money in the DB.
I use the following command to create the parameter :

prm = cmd.CreateParameter('Open', constants.adCurrency,
constants.adParamInput, 8, 12.10)
cmd.Parameters.Append(prm)

Here is the error message I receive
| rs, res = cmd.Execute()
| File
"C:\Python23\lib\site-packages\win32com\gen_py\EF53050B-882E-4776-B64
3-EDA472E8E3F2x0x2x7.py", line 1823, in Execute
| return self._ApplyTypes_(5, 1, (9, 0), ((16396, 18), (16396,
17), (3, 49
)), 'Execute',
'{00000556-0000-0010-8000-00AA006D2EA4}',RecordsAffected, Paramet
ers, Options)
| File
"C:\Python23\lib\site-packages\win32com\client\__init__.py", line 445
, in _ApplyTypes_
| return
self._get_good_object_(self._oleobj_.InvokeTypes(*((dispid, 0, wF
lags, retType, argTypes) + args)), user, resultCLSID)
| com_error: (-2147352567, 'Exception occurred.', (0, 'Microsoft
OLE DB Provid
er for SQL Server', 'Error converting data type char to int.', None,
0, -2147217
913), None)



Thanks in advance for your help
Joel