Print Page | Close Window

Forum Errors

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=6898
Printed Date: 07 April 2026 at 6:54pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Forum Errors
Posted By: NickBits
Subject: Forum Errors
Date Posted: 01 November 2003 at 1:45am

Hi All,

Ok I have IIS installed on my machine for testing all of my sites locally.  I have been using the webwiz forum, guestbook and news apps no problems.  Something I done yesturday, to the machine not the code, has caused problems.  The Guestbook and forum now just come up with internal server error 500 whilst the news app comes up with:

  • Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
  • [Microsoft][ODBC Microsoft Access Driver] Unknown
  • /web_wiz/news/default.asp, line 93

I havnt a clue what I have done to the machine to cause this.  Does anyone have any ideas?

Cheers,

Nick




Replies:
Posted By: WebWiz-Bruce
Date Posted: 01 November 2003 at 3:36am
It could be corrupted database drivers, download them from www.microsoft.com/data

Could also be a corrupted database, also access 97 isn't supported by MS's latest DB drivers, so open the database in Access make sure it is in Access 2000 format and try a comapct and repair from the tools menu.


-------------
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: NickBits
Date Posted: 01 November 2003 at 8:39am

Hi boRg,

Ok, I have reinstalled the drivers and no luck.

I have check all of the files, I have even take a copy from my website which works.  Yet it still dosnt work on my local system.

I have uninstalled IIS and reinstalled it.  All it tells me is that it is an internal error (500:100).  The error I am getting from trying to run the forum is:

  • Microsoft JET Database Engine (0x80040E14)
  • The SELECT statement includes a reserved word or an
  • argument name that is misspelled or missing, or the
  • punctuation is incorrect.
  • /web_wiz/forum/common.asp, line 264

The error when trying to run the guestbook is

  • Microsoft JET Database Engine (0x80040E14)
  • Unknown
  • /web_wiz/guestbook/Default.asp, line 90

And running the news feed I get:

  • Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
  • [Microsoft][ODBC Microsoft Access Driver] Unknown
  • /web_wiz/news/default.asp, line 93

Ok, I know its not the code or that the files are corrupt as I have a known working copy.  I have reinstalled IIS and can run other ASP files.  It appears to be only ASP code that trys to access databases.   I am completly lost, has anyone any ideas at all?

Nick



Posted By: ticsa
Date Posted: 02 November 2003 at 1:18am
  • Microsoft JET Database Engine (0x80040E14)
  • The SELECT statement includes a reserved word or an
  • argument name that is misspelled or missing, or the
  • punctuation is incorrect.
  • /web_wiz/forum/common.asp, line 264

i think you should chang the reserved word or argument name to others.

may be the date type is not match ,

or its value can't be empty !

change it in Access!

my english is not very well,can you understand ?

 good luck!



Posted By: NickBits
Date Posted: 02 November 2003 at 2:52am

Hi ticsa,

May be I didnt make it clear.  There is nothing wron with the forum, guestbook or news.  I have a working copy on my website ( http://www.nickbits.co.uk - www.nickbits.co.uk ) which is not hosted by me.  I have a webserver (IIS) running on my own machine which I use for developing my sites offline.  This is where the problem comes from.  I have a perfect, working copy from my host, however when I view it from my web-server, I get the errors mention in my previous post.  So therefore I know it is nothing to do with the code but something to do with either IIS or the database drivers.  Since I am relativly new to IIS (hosting with windows) I havnt a clue about settings for IIS or database drivers.

(It was working fine at one stage!!!)

As I said earlier, I have reinstalled IIS and the MDAC 2.8 and still get no joy!!!

Anyone any ideas, please!!!

Nick



Posted By: NickBits
Date Posted: 02 November 2003 at 2:58am

Hi All,

Have just solved it...

I have reinstalled an earlier version of MDAC (2.7) AND put Microsoft.NET update (from the windows update site) back on and the forum/news and guestbook have all started working again.  I can only assume that one of these was responsible. 

Thanks for your help.  Hope this is helpful for anyone else who get similar problems.

Nick



Posted By: maw_
Date Posted: 27 January 2004 at 9:02am

I am suddenly getting the same error on the live version of my site.. hosted with discountasp.net

The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.

/mari/gaytard/forum/common.asp, line 247

I believe this refers to the configuration select statement

I havent touched it for some time .. so I assume it is some change on the server that is causing this. I am not sure if it is/will give similar errors on others bits as I am not able to get beyond this point.

I was hoping someone could advise me on what my host may have changed to cause this .. or what part of the select statement the error might be with?

Any advice at all would be greatly appreciated

Thanks in advance

maw




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