Hi I get the following error when trying to update a table using a stored 
proc

______________________________

Microsoft OLE DB Provider for SQL Server (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status 
value, if available. No work was done.
/inc_ibt_newform3.asp, line 131

_______________________________

line 131 looks like 
objRS.Open "Exec sp_insert_HIFIibtProductDetails " & ibtCode & ", '" & 
ibtProductCode & "','" & ibtProductDesc & "'", DataConn


my connection looks like:
Session("ConnectionString")="Provider=SQLOLEDB.1;Persist Security 
Info=False;User ID=sa;Initial Catalog=hifiData;Data Source=file-server"

Set DataConn = Server.CreateObject("ADODB.Connection")
'DataConn.Provider = "MSDataShape"
Set cmdSQL = Server.CreateObject("ADODB.Command")
Set objRS = Server.CreateObject("ADODB.Recordset")
DataConn.Open Session("ConnectionString")

cmdSQL.CommandType = 1
Set cmdSQL.ActiveConnection = DataConn

Stored Proc looks like:
CREATE Procedure sp_insert_HIFIibtProductDetails
	(@ibtCode				 	[numeric](9),
	 @ibtProductCode 			[nvarchar](100),
	 @ibtProductDesc	 		[nvarchar](300))

AS INSERT INTO [hifiCorp].[dbo].[HIFIibtProductDetails] 
	 ( [ibtCode],
	 [ibtProductCode],
	 [ibtProductDesc])
 
VALUES 
	(@ibtCode,
	 @ibtProductCode,
	 @ibtProductDesc)
return



I know all my code is working fine because it works on our production 
server (windows 2000) but not on our clients server (windows 2000 server).
Both systems running SQL Server 7.0

Any help will be appreciated.

thanks
Ryan

www.adopenstatic.com/faq/80040e21.asp

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Ryan vd Merwe" <ryanvdm@i...>
Subject: [asp_web_howto] Microsoft OLE DB Provider for SQL Server
(0x80040E21)


: Hi I get the following error when trying to update a table using a stored
: proc
:
: ______________________________
:
: Microsoft OLE DB Provider for SQL Server (0x80040E21)
: Multiple-step OLE DB operation generated errors. Check each OLE DB status
: value, if available. No work was done.
: /inc_ibt_newform3.asp, line 131

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Hi Ken

I have checked this url as I found this in previous post and tried so sort
it out before I made my post but to no avail.

I have set-up two machines one with windows 2000 server iis5, all my update
procs (about 6 of them) work fine on both machines. Yet the procs do not
work on client. also a windows 200 server iis5.

Can you tell me if this error is caused by design, or perhaps software needs
upgrading? If it is by design then why does it work on most machines but not
on another machine that has the same os?

thanks

-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: 28 February 2003 03:58
To: ASP Web HowTo
Subject: [asp_web_howto] Re: Microsoft OLE DB Provider for SQL Server
(0x80040E21)


www.adopenstatic.com/faq/80040e21.asp

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Ryan vd Merwe" <ryanvdm@i...>
Subject: [asp_web_howto] Microsoft OLE DB Provider for SQL Server
(0x80040E21)


: Hi I get the following error when trying to update a table using a stored
: proc
:
: ______________________________
:
: Microsoft OLE DB Provider for SQL Server (0x80040E21)
: Multiple-step OLE DB operation generated errors. Check each OLE DB status
: value, if available. No work was done.
: /inc_ibt_newform3.asp, line 131

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~