Web Wiz Forums - Can’t add Poll in 7.5

Print Page | Close Window

Can’t add Poll in 7.5 - SQL Server

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=6168
Printed Date: 03 April 2026 at 11:38am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Can’t add Poll in 7.5 - SQL Server

Posted By: Mojo_Risin
Subject: Can’t add Poll in 7.5 - SQL Server
Date Posted: 05 October 2003 at 1:45am

I've just upgraded from 7.01 Access to 7.5 SQL Server. Everything seems to have gone way better than expected. Thanks for a great update!

I did run into one problem however. Now when I try to create a poll I get the following error:

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/post_message.asp, line 517

I'm afraid I don't know what an OLE DB status value is, so I don't know what to check. Is the Poll table between the Access and SQL Server different? I used to be able to create polls before the update.

Thanks for any assistance.

-------------
Dave

Replies:

Posted By: WebWiz-Bruce
Date Posted: 05 October 2003 at 6:50am

Your poll question is to long. You need to increae the size of the Poll_question field in the table tblPoll to at least 80 characters.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: Mojo_Risin
Date Posted: 05 October 2003 at 10:03am

Thanks very much, borg! Worked like a charm. I'm a happy camper now.

By the way, things have gone so well with this upgrade and conversion that I think I'll be sending some money your way again. This forum software rocks!

-------------
Dave