Group Permissions - OLE DB Error 80040e21

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
MortiOli Members Profile Find Members Posts Senior Member Joined: 26 May 2002 Location: United Kingdom Status: Offline Points: 514	Post Options Post Reply Quote MortiOli Report Post Thanks(0) Quote Reply Topic: Group Permissions - OLE DB Error 80040e21 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 Thanks!

dj air Members Profile Find Members Posts Senior Member Joined: 05 April 2002 Location: United Kingdom Status: Offline Points: 3627	Post Options Post Reply Quote dj air Report Post Thanks(0) Quote Reply 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,

MortiOli Members Profile Find Members Posts Senior Member Joined: 26 May 2002 Location: United Kingdom Status: Offline Points: 514	Post Options Post Reply Quote MortiOli Report Post Thanks(0) Quote Reply 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...

JJLatWebWiz Members Profile Find Members Posts Groupie Joined: 02 March 2005 Location: United States Status: Offline Points: 136	Post Options Post Reply Quote JJLatWebWiz Report Post Thanks(0) Quote Reply 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.

dj air Members Profile Find Members Posts Senior Member Joined: 05 April 2002 Location: United Kingdom Status: Offline Points: 3627	Post Options Post Reply Quote dj air Report Post Thanks(0) Quote Reply Posted: 06 October 2005 at 6:35pm
	lgood point oli, ill take off the primary/increment

MortiOli Members Profile Find Members Posts Senior Member Joined: 26 May 2002 Location: United Kingdom Status: Offline Points: 514	Post Options Post Reply Quote MortiOli Report Post Thanks(0) Quote Reply Posted: 07 October 2005 at 1:58pm
	Seems to have done the trick! Cheers guys

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.