Web Wiz Support and Community Forums : Forum Errors https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 07 Apr 2026 18:46:59 +0000 Tue, 27 Jan 2004 09:02:12 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=6898 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Forum Errors : I am suddenly getting the same...]]> https://forums.webwiz.net/forum-errors_topic6898_post49341.html#49341 Author: maw_
Subject: 6898
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

]]> Tue, 27 Jan 2004 09:02:12 +0000 https://forums.webwiz.net/forum-errors_topic6898_post49341.html#49341 <![CDATA[Forum Errors : Hi All, Have just solved it... I...]]> https://forums.webwiz.net/forum-errors_topic6898_post34241.html#34241 Author: NickBits
Subject: 6898
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

]]> Sun, 02 Nov 2003 02:58:07 +0000 https://forums.webwiz.net/forum-errors_topic6898_post34241.html#34241 <![CDATA[Forum Errors : Hi ticsa, May be I didnt make...]]> https://forums.webwiz.net/forum-errors_topic6898_post34239.html#34239 Author: NickBits
Subject: 6898
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 (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

]]> Sun, 02 Nov 2003 02:52:56 +0000 https://forums.webwiz.net/forum-errors_topic6898_post34239.html#34239 <![CDATA[Forum Errors : Microsoft JET Database Engine...]]> https://forums.webwiz.net/forum-errors_topic6898_post34229.html#34229 Author: ticsa
Subject: 6898
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!



Edited by ticsa]]> Sun, 02 Nov 2003 01:18:50 +0000 https://forums.webwiz.net/forum-errors_topic6898_post34229.html#34229 <![CDATA[Forum Errors : Hi boRg, Ok, I have reinstalled...]]> https://forums.webwiz.net/forum-errors_topic6898_post34134.html#34134 Author: NickBits
Subject: 6898
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



Edited by NickBits]]> Sat, 01 Nov 2003 08:39:44 +0000 https://forums.webwiz.net/forum-errors_topic6898_post34134.html#34134 <![CDATA[Forum Errors : It could be corrupted database...]]> https://forums.webwiz.net/forum-errors_topic6898_post34101.html#34101 Author: WebWiz-Bruce
Subject: 6898
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 byMS's latest DB drivers, so open the database in Access make sure it isin Access 2000 format and try a comapct and repair from the tools menu.
]]> Sat, 01 Nov 2003 03:36:49 +0000 https://forums.webwiz.net/forum-errors_topic6898_post34101.html#34101 <![CDATA[Forum Errors : Hi All, Ok I have IIS installed...]]> https://forums.webwiz.net/forum-errors_topic6898_post34098.html#34098 Author: NickBits
Subject: 6898
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

]]> Sat, 01 Nov 2003 01:45:22 +0000 https://forums.webwiz.net/forum-errors_topic6898_post34098.html#34098