-----Original Message-----
From: Ryan vd Merwe [mailto:ryanvdm@i...]
Sent: 28 February 2003 07:31
To: ASP Web HowTo
Subject: RE: [asp_web_howto] Re: Microsoft OLE DB Provider for SQL
Server (0x80040E21)


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

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

Are you running the same MDAC on each machine?
Did you copy the databases from one machine to all the other machines?

www.microsoft.com/data/

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "Ryan vd Merwe" <ryanvdm@i...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Monday, March 03, 2003 5:09 PM
Subject: [asp_web_howto] Re: Microsoft OLE DB Provider for SQL Server
(0x80040E21)


:
:
: -----Original Message-----
: From: Ryan vd Merwe [mailto:ryanvdm@i...]
: Sent: 28 February 2003 07:31
: To: ASP Web HowTo
: Subject: RE: [asp_web_howto] Re: Microsoft OLE DB Provider for SQL
: Server (0x80040E21)
:
:
: 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
:
: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
:
:
:
:

Hi Ken

The databases are the same. The MDAC versions are the same.

What I also don't understand is that the select sprocs work but not the 
insert sprocs.




> Are you running the same MDAC on each machine?
Did you copy the databases from one machine to all the other machines?

www.microsoft.com/data/

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "Ryan vd Merwe" <ryanvdm@i...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Monday, March 03, 2003 5:09 PM
Subject: [asp_web_howto] Re: Microsoft OLE DB Provider for SQL Server
(0x80040E21)


:
:
: -----Original Message-----
: From: Ryan vd Merwe [mailto:ryanvdm@i...]
: Sent: 28 February 2003 07:31
: To: ASP Web HowTo
: Subject: RE: [asp_web_howto] Re: Microsoft OLE DB Provider for SQL
: Server (0x80040E21)
:
:
: 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
:
: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
:
:
:
: