Print Page | Close Window

Webwiz forum database 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=4540
Printed Date: 02 April 2026 at 9:14pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Webwiz forum database errors
Posted By: Mystic Briton
Subject: Webwiz forum database errors
Date 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/ - 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




Replies:
Posted By: Mystic Briton
Date 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



Posted By: WebWiz-Bruce
Date 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.

-------------
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: Bunce
Date 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.


Posted By: Mystic Briton
Date 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



Posted By: Bunce
Date 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.


Posted By: Mystic Briton
Date 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



Posted By: Mystic Briton
Date 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



Posted By: Bunce
Date Posted: 28 July 2003 at 11:55pm
Have you contacted your host yet? If you're receiving a permissions error then they've either stuffed up the permissions on the folder containing the database, or yoru connection string is incorrect.

-------------
There have been many, many posts made throughout the world...
This was one of them.


Posted By: Mystic Briton
Date Posted: 29 July 2003 at 1:03am

Heres my connection string:

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

As a graphical example, heres the latest kind of errors:

All I have done is put On error resume next  in the common.asp script (in forums folder not the admin one)

BriToN



Posted By: Mystic Briton
Date Posted: 29 July 2003 at 1:05am

Btw - this only happens about once ever 5 or 6 times the page is displayed, so 90% of the time it works fine !!!

Briton



Posted By: Mystic Briton
Date Posted: 03 August 2003 at 4:10am

Well now the ISP has done something and the errors are less-frequent. And I find the OLEDB connection string is better, however, sometimes I get an error which actually lists the path to the database and the name! - Now the programmer says "change the name of the database for security reasons" - whats the point in this if the OLEDB driver gives away the path in an error message. The error message (although infrequent) is that the DB is not found in the path e:\bahbah etc\....

I have tried using on error resume next, but this is hopeless, many more frequent errors

How can I stop the path and DB name dfrom showing up ?

BriToN



Posted By: Mystic Briton
Date Posted: 26 August 2003 at 3:06am

Just reporting back, a month or so later, to let you know that the forums ROCK. It was my host that sucked. I am now with new hosts and the forums work like a dream.

If anyone else uses a host that don't know what they are doing, they will get similar unpredictable errors, its not the forums which are at fault.

Thanks for your help, sorry for wasting your time

BriToN




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