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:
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, ------------- 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 |