Web Wiz Forums - Syntax Error for News Letter Intergration

Print Page | Close Window

Syntax Error for News Letter Intergration

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

Topic: Syntax Error for News Letter Intergration

Posted By: anthony
Subject: Syntax Error for News Letter Intergration
Date Posted: 01 October 2008 at 2:54pm

When a user clicks on the News letter link on the forum (Bulletins) you get this error msg on your browers

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[MySQL][ODBC 3.51 Driver][mysqld-5.0.41-community-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 '.`tblNPNews(

/news/rss_view_newsletter.asp, line 109

Can someone please assist me.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 01 October 2008 at 4:08pm

You need to be using the myODBC 3.51.23 driver or below to prevent this error with newspad 1.x

-------------
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: anthony
Date Posted: 01 October 2008 at 4:43pm

Where and how may places to i did to make that change.

Posted By: WebWiz-Bruce
Date Posted: 01 October 2008 at 5:25pm

This is the myODBC database driver which is installed on the web server by the server admin.

-------------
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: anthony
Date Posted: 02 October 2008 at 3:16pm

The driver installed on the server is ODBC mysql driver 3.51.04.00

Do you have any other suggestions?

Posted By: WebWiz-Bruce
Date Posted: 02 October 2008 at 4:49pm

It is compatible with myODBC 3.51.11 through to 3.51.23.

For the best stability the SQL Server version is best.

The mySQL version tends to break each time a new myODBC driver is released.

-------------
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: anthony
Date Posted: 02 October 2008 at 5:29pm

I just purchased 4 licenses (2 forums 2 newspads) all running on mysql data. (roughly 2 weeks ago)

How can i make this switch to SQL Server.

Posted By: WebWiz-Bruce
Date Posted: 02 October 2008 at 5:44pm

Unfortunately you can not change to mySQL as it uses a different schema as the SQL Server and Access versions use a relational database schema. mySQL is not a relation database management system and so has to have a different database schema.

mySQL is used more in the PHP Linux environment were it runs best. However, due to it's popularity as it is free there are mySQL versions available of our software but they are not as stable as using Microsoft technologies throughout such as Windows IIS with ASP and SQL Server.

Web Wiz Forums though has been updated recently to work with the latest myODBC 3.51 driver and the newer myODBC 5.1 driver. NewsPad will need to be updated again to work with these newer myODBC drivers.

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