Multiple-step OLE DB operation generated errors

[abienz]

I've created a blank ASP page which simply calls a stored procedure which inserts data into a table in my MS SQL Server 7 DB. I created this page using Dreamweaver Ultradev, and I've done this hundreds of times before and mostly in a more complicated manner. The data for this page is obtained from a previous htm page that submits a form with three fields.

Whenever I run through this process I get an wrror like this...

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/******/*****/******/******.asp, line 30

Where line 30 is the line that says command.Execute()

I don't understand this error at all! Can someone out there help me please!

Cheers,
Al.

 

[Guest_imported]

I was just getting this same error the other day. I was passing variables into the stored procedure that I believed to be integers, however, it turned out they were actually strings that looked like numbers. Anyway, I just forced the variables to integers by using Cint(variable) and it worked! I hope that helps!

 

[abienz]

I've been fiddling around with the table and the datatypes and I've found that when I use certain datatypes such as decimal (Which I've noticed doesn't seem to be recognised too well in VBScript) I get this error, but when I change to float or even varchar there's no problem at all!

How strange,