Web Wiz Support and Community Forums : DB Error after Compacting & Repair https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 04:13:47 +0000 Wed, 19 Apr 2006 09:40:45 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=19370 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[DB Error after Compacting & Repair : MS SQL Server 2000 or 2005 will...]]> https://forums.webwiz.net/db-error-after-compacting-repair_topic19370_post104845.html#104845 Author: WebWiz-Bruce
Subject: 19370
Posted: 19 April 2006 at 9:40am

MS SQL Server 2000 or 2005 will give the best performance.

But I do recall another user with GoDaddy who said that they don't allow remote connections to their SQL Server database, which meant they could not backup or move the database to another web host.

I would recommend moving away from GoDaddy to a better host, as reports on this forum are not very good.
]]> Wed, 19 Apr 2006 09:40:45 +0000 https://forums.webwiz.net/db-error-after-compacting-repair_topic19370_post104845.html#104845 <![CDATA[DB Error after Compacting & Repair : OK I just checked out my hosting...]]> https://forums.webwiz.net/db-error-after-compacting-repair_topic19370_post104789.html#104789 Author: Susan0722
Subject: 19370
Posted: 18 April 2006 at 7:07pm

OK I just checked out my hosting at godaddy.  They offer all 3.  Access, mySQL and SQL.

Which one do I want?
]]> Tue, 18 Apr 2006 19:07:58 +0000 https://forums.webwiz.net/db-error-after-compacting-repair_topic19370_post104789.html#104789 <![CDATA[DB Error after Compacting & Repair : Version 8 final is now out and...]]> https://forums.webwiz.net/db-error-after-compacting-repair_topic19370_post104781.html#104781 Author: WebWiz-Bruce
Subject: 19370
Posted: 18 April 2006 at 5:48pm

Version 8 final is now out and been downloaded over 1500 times.

No bugs have been found in it, although people keep saying they find them, but they all seem to be that people have not setup the software to work with their server correctly.

GoDaddy from posts on here are not a good web host. You will need to check with them the SQL database they support and the version. Watch out because SQL Server and mySQL are 2 completely different databases.

The reason why upgrades are free on web wiz guide software is to cut down on support time and costs by only supporting the latest version, so you should upgrade as soon as possible.
]]> Tue, 18 Apr 2006 17:48:52 +0000 https://forums.webwiz.net/db-error-after-compacting-repair_topic19370_post104781.html#104781 <![CDATA[DB Error after Compacting & Repair : First of all I think what happened...]]> https://forums.webwiz.net/db-error-after-compacting-repair_topic19370_post104775.html#104775 Author: Susan0722
Subject: 19370
Posted: 18 April 2006 at 5:19pm

First of all I think what happened was I after I activated the compact and repair, I went to a page.  I hadn't given it enough time to do it's thing.

And I have to giggle, because Bruce you are determined to get me to upgrade to the new V8.  Is this the final version that is ready for download now?
I kinda want to wait until all the bugs are worked out.  It took me over a year to upgrade to 7.97!

I host with godaddy, and I haven't really looked at , but I know they offer me 10 sql databases with my hosting plan.  So yesterday I was looking on here trying to find out how to switch over to that instead of access, but the search on the site wouldn't let me kept getting the message "one of your querys is 3 characters or less" Confused

So if there is a good thread that shows the step by step migration to sql, can someone point it out for me.  I am thinking I would like to try it.


]]> Tue, 18 Apr 2006 17:19:41 +0000 https://forums.webwiz.net/db-error-after-compacting-repair_topic19370_post104775.html#104775 <![CDATA[DB Error after Compacting & Repair : A couple of things I would recommend.If...]]> https://forums.webwiz.net/db-error-after-compacting-repair_topic19370_post104687.html#104687 Author: WebWiz-Bruce
Subject: 19370
Posted: 18 April 2006 at 8:56am

A couple of things I would recommend.

If you upgrade to version 8.01 it uses a different way of doing dates so you shouldn't get CDate errors.

The other one, is if you have database support with your hosting for SQL Server or mySQL, I would switch to using that as Access is a desktop file and has a bad problem of becoming corrupted.
]]> Tue, 18 Apr 2006 08:56:23 +0000 https://forums.webwiz.net/db-error-after-compacting-repair_topic19370_post104687.html#104687 <![CDATA[DB Error after Compacting & Repair : This is so strange. While waiting...]]> https://forums.webwiz.net/db-error-after-compacting-repair_topic19370_post104666.html#104666 Author: Susan0722
Subject: 19370
Posted: 18 April 2006 at 1:53am

This is so strange.  While waiting for a response, I went out and did errands, came back and now my board is working again.

I didn't do anything to it after I posted this problem.

I think I am in the Twilight Zone.
]]> Tue, 18 Apr 2006 01:53:19 +0000 https://forums.webwiz.net/db-error-after-compacting-repair_topic19370_post104666.html#104666 <![CDATA[DB Error after Compacting & Repair : My forum was running slow so I...]]> https://forums.webwiz.net/db-error-after-compacting-repair_topic19370_post104626.html#104626 Author: Susan0722
Subject: 19370
Posted: 17 April 2006 at 6:38pm

My forum was running slow so I used the "compact and repair" tool in admin. (V7.96)

Now I am getting this error:

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'CDate'

/new/forum/default.asp, line 166


]]> Mon, 17 Apr 2006 18:38:29 +0000 https://forums.webwiz.net/db-error-after-compacting-repair_topic19370_post104626.html#104626