473,225 Members | 1,599 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,225 software developers and data experts.

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

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

Jul 18 '05 #1
0 1881

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Chris Kennedy | last post by:
I am pulling a decimal value from SQL server and trying to use the format currency and format number function. I am using these values in a large string of HTML to be used in a CDONTS Email. If I...
5
by: Matt | last post by:
Hello I am running a SP from the SQL Server Agent, the job has one step that looks like this. exec q_spr_inlevextsystem This job fails with the following message Job 'AutoInlev' : Step...
3
by: Niyazi | last post by:
Hi, Me again. I want to create a SQL Server StoreProcedure and I want to access it with ADO.NET. I am using VB.NET. Creating StoreProcedure it was easy but my question is this. I have table...
26
by: David W. Fenton | last post by:
A client is panicking about their large Access application, which has been running smoothly with 100s of thousands of records for quite some time. They have a big project in the next year that will...
6
by: fumanchu | last post by:
I've got to let end users (really just one person) load billing batch files into a third party app table. They need to specify the billing cycle name, the batch name, and the input file name and...
3
by: mahajanvit | last post by:
Hi one and all I got this problem during my project. So in order to solve this I made a very small application. I am trying to insert using SP and sqldatasource control. I know that while using...
10
by: J. S. EDV | last post by:
Hello, I have got a little problem with stored procedures and C#. I have got a stored procedure which should only insert something in a table. For example: ALTER PROCEDURE DBO.PROC1 AS...
0
by: Melanie | last post by:
Hi - my problem is as follows: I'm writing an ASP.Net 2.0 app with C#. From the app, I call a stored procedure that updates some data in the app's database (SQL Server 2000). This stored procedure...
1
by: Jeff | last post by:
hey ..net 2.0 I have some .net code which calls a stored procedure. This stored procedure returns a value of SqlDbType.Money... I'm wondering what datatype I should use on the variable which...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.