Web Wiz NewsPad - News Bulletin Error

Print Page | Close Window

News Bulletin Error

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz NewsPad
Forum Description: Support forum for the Web Wiz NewsPad application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=25402
Printed Date: 29 March 2026 at 12:35am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: News Bulletin Error

Posted By: freakdaddy
Subject: News Bulletin Error
Date Posted: 06 March 2008 at 11:35am

Seems I'm getting an error when people click on the link to read the latest new bulletin from the forum:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[MySQL][ODBC 3.51 Driver][mysqld-5.0.45-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.`tblNPNewsletter` SET RSS_views=1 WHERE (RSS_views=0 )' at line 1

/NewsPad/rss_view_newsletter.asp, line 109

I've actually had several other errors related to the database, some of which I've figured out, and some of which needed to be changed from driver=mysql to point to the odbc driver. Like I said, earlier, a bit strange because I've never had any of these issues with the forum, and it's running off the same Godaddy server.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 06 March 2008 at 12:44pm

This issue does effect some mySQL installation and we are trying to find a fix.

If you can I would recommend using SQL Server instead as it runs much better with ASP.

mySQL is a good database but it is let down when using with ASP or ASP.NET as the myODBC driver which has to be used for ASP to talk to a mySQL database is very buggy.

-------------
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: freakdaddy
Date Posted: 06 March 2008 at 8:50pm

Hi Bruce,

I don't have anymore SQL server database in my account. Your answer seems a little odd since the forums run fine with mySQL, and I have several mySQL databases on my site, and don't have any issues. I mean, I believe you that it may be buggy, but really the only place I've ever had issues is with this Newspad program. Never had any other issues with the 7 other scripts I use with ASP, my server, and mySQL.

Is there some work around I can put in for now, because my site is live, and has many members, and this just looks a bit un-professional.

Thanks.

Posted By: WebWiz-Bruce
Date Posted: 06 March 2008 at 9:31pm

You should raise a support ticket so that it can be looked into

-------------
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: freakdaddy
Date Posted: 07 March 2008 at 5:43am

Sure, how do I do that?

Posted By: WebWiz-Bruce
Date Posted: 10 March 2008 at 8:57am

To raise a support ticket log into your Client Area account and click on Support.

These support forums are for people using free editions and therefore you are not garanteed and response.

Paying licensing holders and those who purchase premium support can raise support tickets which take priority and are guaranteed a response as setup in the Terms and Conditions.

-------------
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