Print Page | Close Window

Group Permissions - OLE DB Error 80040e21

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=16787
Printed Date: 16 April 2026 at 6:33am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Group Permissions - OLE DB Error 80040e21
Posted By: MortiOli
Subject: Group Permissions - OLE DB Error 80040e21
Date Posted: 03 October 2005 at 1:42pm
Hi,
 
I'm hoping someone can help me with this problem, please?
 
I've recently converted from MS Access to MS SQL, with the help of dj air, but I've hit a problem when modifying group permissions;
 
 
Microsoft OLE DB Provider for SQL Server error '80040e21'

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

/forum/admin/create_group_permissions.asp, line 112

 
This occurs when I go to group permissions, and add any permissions to the moderator group (and maybe other groups too).
 
Could someone give me some info on how I can sort this problem out please, as I'm currently moderator-less Ouch
 
Thanks!



Replies:
Posted By: dj air
Date Posted: 03 October 2005 at 4:18pm
just to make it so i get replies but also

the primary key/ increment is working ok and the values entered are ok

im not to sure on this one,


Posted By: MortiOli
Date Posted: 06 October 2005 at 1:27pm
Anyone have any ideas please?  I'm the only person moderating my forums, and it's getting a bit mad... Ouch


Posted By: JJLatWebWiz
Date Posted: 06 October 2005 at 5:59pm
This sounds like a bug in the MDAC.  But, if I assume the asp is unchanged from a fresh 7.92 install, line 112 says, ".Fields("Group_ID") = intUserGroupID".  Is that correct?
 
dj air, you said that the "primary key / increment" is working.  In my SQL test install, there is no primary key or increment on the tblPermissions table.  That could expose the MDAC flaw.


-------------
p.s. I'm not affiliated with Web Wiz Guide in any way. I'm just an average Web Wiz user repaying my debt for the use of their fine forum by trying to help other Web Wiz Guide users.


Posted By: dj air
Date Posted: 06 October 2005 at 6:35pm
lgood point

oli, ill take off the primary/increment



Posted By: MortiOli
Date Posted: 07 October 2005 at 1:58pm
Seems to have done the trick!  Cheers guys Smile



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net