Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Webwiz forum database errors
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Webwiz forum database errors

 Post Reply Post Reply Page  12>
Author
Mystic Briton View Drop Down
Newbie
Newbie


Joined: 10 June 2003
Status: Offline
Points: 13
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mystic Briton Quote  Post ReplyReply Direct Link To This Post Topic: Webwiz forum database errors
    Posted: 26 July 2003 at 3:01am

Hi

I have had webwiz forums working for about 3 months now (ver 7.01), you can find them at http://mysticteam.com/mb/forum/

I have recently had the following errors coming up after about 25% of posts:


Microsoft JET Database Engine error '80004005'

'E:\kunden\homepages\27\d83157758\mb\forum\admin\database\spam.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

/mb/forum/common.asp, line 233

heres another one:


Provider error '80004005'

Unspecified error

/mb/forum/common.asp, line 233


heres another one


Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x3c98 Thread 0x3968 DBC 0x9409034 Jet'.

/mb/forum/common.asp, line 233

Line 233 of common.asp is the connection open command - I am using access database (2002) and the following connection string:

strDbPathAndName = Server.MapPath("admin/database/spam.mdb")

strCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & strDbPathAndName

 

I have also tried using:

'strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & strDbPathAndName 

But this gives even more frequent errors.

Do you have any idea what could be wrong?

Thanks

BriTon

Back to Top
Mystic Briton View Drop Down
Newbie
Newbie


Joined: 10 June 2003
Status: Offline
Points: 13
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mystic Briton Quote  Post ReplyReply Direct Link To This Post Posted: 26 July 2003 at 3:02am

P.S. I changed the name of the database here to protect it, however, its very worrying when the name and path of the actual database comes up in an error!!

BriToN

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 26 July 2003 at 4:00am
It could be that your web hosts have changed something on their system so that the path is no-longer correct, try contacting your web hosts and see if they can shed some light on the problem.
Back to Top
Bunce View Drop Down
Senior Member
Senior Member
Avatar

Joined: 10 April 2002
Location: Australia
Status: Offline
Points: 846
Post Options Post Options   Thanks (0) Thanks(0)   Quote Bunce Quote  Post ReplyReply Direct Link To This Post Posted: 26 July 2003 at 4:30am

You should try to trap your database errors in code to avoid showing database paths.

I would recommend using the Jet driver (your second string) instead of the Access DB one.  It *should* be more reliable.

Also might pay to compact/repair your DB often is possible to avoid corruption.

Cheers,
Andrew

There have been many, many posts made throughout the world...
This was one of them.
Back to Top
Mystic Briton View Drop Down
Newbie
Newbie


Joined: 10 June 2003
Status: Offline
Points: 13
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mystic Briton Quote  Post ReplyReply Direct Link To This Post Posted: 26 July 2003 at 4:46am

How can you compact your DB without downloading it to your machine first?

I will try trapping the errors, trouble is, it often hides the real error and makes debugging more difficult

Cheers

Briton

Back to Top
Bunce View Drop Down
Senior Member
Senior Member
Avatar

Joined: 10 April 2002
Location: Australia
Status: Offline
Points: 846
Post Options Post Options   Thanks (0) Thanks(0)   Quote Bunce Quote  Post ReplyReply Direct Link To This Post Posted: 26 July 2003 at 5:04am

Ideally you should send the error message to yourself / webmaster or store it in a log for you to access to debug.

To repair your database you will need to take your site offline for a short period.

Andrew

There have been many, many posts made throughout the world...
This was one of them.
Back to Top
Mystic Briton View Drop Down
Newbie
Newbie


Joined: 10 June 2003
Status: Offline
Points: 13
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mystic Briton Quote  Post ReplyReply Direct Link To This Post Posted: 26 July 2003 at 6:44am

Well I downloaded the database and it loads up fine into msaccess, so I presume theres no errors in it. Therefore the error must be with the ISP or the forums.

The error logging is a good idea, I will implement that as soon as I can

Briton

Back to Top
Mystic Briton View Drop Down
Newbie
Newbie


Joined: 10 June 2003
Status: Offline
Points: 13
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mystic Briton Quote  Post ReplyReply Direct Link To This Post Posted: 28 July 2003 at 11:27pm

I have put on error logging, but not I get Access Denied - the file permissions asp script shows up if I use on error resume next.

This is a nightmare. Are these forums here hosted on SQl server? - Because they are much faster and more error-free than mine.

BriToN

Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.