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

Quinet, Joel joel.quinet at be.unisys.com
Fri Aug 8 10:13:05 CEST 2003


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





More information about the Python-list mailing list