| Author |
 Topic Search  Topic Options
|
NickBits 
Newbie
Joined: 13 October 2003
Location: United Kingdom
Status: Offline
Points: 9
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Forum Errors
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
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
NickBits
Newbie
Joined: 13 October 2003
Location: United Kingdom
Status: Offline
Points: 9
|
Post Options
Thanks(0)
Quote Reply
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
|
|
ticsa
Mod Builder Group
Joined: 02 July 2003
Location: China
Status: Offline
Points: 203
|
Post Options
Thanks(0)
Quote Reply
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
|
|
NickBits
Newbie
Joined: 13 October 2003
Location: United Kingdom
Status: Offline
Points: 9
|
Post Options
Thanks(0)
Quote Reply
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
|
|
NickBits
Newbie
Joined: 13 October 2003
Location: United Kingdom
Status: Offline
Points: 9
|
Post Options
Thanks(0)
Quote Reply
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
|
|
maw_
Newbie
Joined: 27 January 2004
Location: United Kingdom
Status: Offline
Points: 1
|
Post Options
Thanks(0)
Quote Reply
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
|
|
