CoverYourASP --> Newsletter archives

Free membership

Join in the fun! Sign in
Member Services

Site navigation
Download the entire site!
Search my articles
Free Magazines
Browse the directory

Send me feedback
Buy my boxer shorts

Recommend this page
Printer-friendly page

Resources I recommend
Link to my site
Advertising slashed!
About your privacy
Legal stuff
Site statistics
79 active users
4383 visitors today
3285 pages today
(only part of today)
Tools I use

Copyright © 1999-2016 James Shaw.
All rights reserved.

RSS submissions

Now open source with SourceForge!

Pick a newsletter to read - you can receive these every Saturday by subscribing.

You can also read the article that describes how this is implemented.

undefined NaN NaN

Jun 5 2002

Apr 30 2002

Mar 31 2002

Feb 28 2002

Jan 23 2002

Jan 22 2002

Jan 15 2002

Jan 14 2002

Jan 7 2002

Dec 24 2001

Dec 11 2001

Nov 27 2001

Nov 12 2001

Aug 1 2001

Jul 14 2001

Jun 24 2001

Jun 10 2001

May 26 2001

May 12 2001

Apr 30 2001

Apr 22 2001

Apr 14 2001

Apr 8 2001

Mar 29 2001

Mar 24 2001

Mar 17 2001

Mar 10 2001

Mar 3 2001

Feb 24 2001

Feb 17 2001

Feb 10 2001

Feb 3 2001

Jan 27 2001

Jan 20 2001

Jan 13 2001

Jan 6 2001

Dec 30 2000

Dec 23 2000

Dec 16 2000

Dec 9 2000

Dec 2 2000

Nov 29 2000

Nov 25 2000

Nov 18 2000

Nov 11 2000

Nov 4 2000

Oct 28 2000

Oct 21 2000

Oct 14 2000

Oct 9 2000

Oct 7 2000

Oct 3 2000

Oct 1 2000

Sep 29 2000

Sep 27 2000

Sep 25 2000

Sep 23 2000

Sep 21 2000

Sep 18 2000

Sep 14 2000

Sep 11 2000

Dec 2 2000

Welcome to the latest CoverYourASP newsletter!

Another fun-filled week! I'll let the diary speak for
itself first..

29 Nov
- Not only the worst day ever (see below), but the best
day ever too. The site got listed on as a Top
ASP site - Charles Carrolls site gets 22,000 visitors a
day, so Im hoping the traffic improves...which means the
site improves.

- Serious problems here this morning. I lost the entire
database - members, newsletter subscribers, everything. I
would like to say it was lightning or some other act of
god, but it wasnt. I was using a new FTP program and hit
the wrong button - and uploaded an old corrupt database
over the live one. Big oops. I hadnt backed up the
database for 3 days, so all memberships and subscriptions
to my newsletter since then have been lost. Sorry folks.

26 Nov
- Don Welsh was the first to point out that the database
in the download didnt have the diary table! Its now fixed
of course...

- Ken Reed pointed out a bug in the way that all the links
work in the latest download. I added a tag recently to
utils/Init.asp to define where the relative links are
relative to.

By default it assumes you run from http://localhost/cya,
but many of you dont. I've now published an article
about how to set this up - see

- I wanted to make the default front page smaller for
non-members, so I turned off the diary and whats new. I
also added a new page - AllContent.asp - that displays
everything that the front page doesnt, so members or
non-members can both see all the content. This reduced
the non-members front page from 25k to 14k!

25 Nov
- Found a bug in utils/login.asp - I was reading the
personalization flags into the wrong variables, so when
you signed in the next time your settings would look

In fact whats stored in the database is correct, and you
should now see what you asked for.


As soon as I uploaded the bad database I knew this wasn't
the normal kind of screw up. I was very lucky to have a
fairly recent back up. I had to take the site down quickly
though, so I quickly typed in a new html page called
Maintainance.htm, and added a line to the top of my
Init() function in utils/init.asp.

Redirect ( '/Maintainance.htm' );

(Redirect is just a wrapper function for either
Response.Redirect or Server.Transfer, depending on IIS

This line was all that was required to send every page on
the site to the emergency maintainance page. I've left
that line in Init(), but commented it out.

Let's hope I don't have to use it again!


Hero of the Week!

Hakan Eskici - of TableEditor fame - has helped a lot
this week, including an email asking if there was
anything he could do to help when he saw the maintainance
page up.

What does he do, live on my site? ;-)

Of course, I've said in my DBAdmin.asp article that I
based the idea of my db pages on his TableEditor - and now
he's come out with updates to that I shall be unashamedly
looking through to see how I can improve mine!

Thanks Hakan.

See his growing site at


Yuri Smetsers helped out too this week, I appreciate his
patience! He couldn't get the site to work with the new
relative links and <base href> tag, so he prompted me
to solve the problem and publish a new page that helped
with setting up include/config.asp, line by line.

Read it at

He also suggested that I add a new download containing
all the images, so that is now available at


No-one has reported a problem with the cookies that the
membership system uses, but I got the following anonymous
email this week. Thank you to whoever sent it!

"There is a problem (caused by microsoft) and the article
about it:

function KillLoginCookies ( )
Response.Cookies ( sCookieEmail ) = '';
Response.Cookies ( sCookieEmail ).Expires = '11/27/1980';
Response.Cookies ( sCookiePassword ) = '';
Response.Cookies ( sCookiePassword ).Expires = '11/27/1980';

Those days were added by me and now it is working."

All that was changed was the date format.


The number 1 question I get emailed is asking to solve:

ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed.

This has been mentioned before in the newsletter, but maybe
all the emails this week warrant another mention.

This error means that the relevant ADODB driver is not
installed. First, check that you have Access installed.

Check which version, and use the appropriate setting for
sDBDriver in include/config.asp. Try different settings.

Here's what MSDN says about the issue. (It talks about SQL
server, but it applies to Access too).

The MSDASQL OLE DB provider is either unavailable or is
not registered. This can be caused by an incomplete upgrade
or a bad install of the Microsoft Data Access Components
(MDAC) components.

Here are two ways to resolve this problem:

- Register the Msdasql.dll using the following command:
REGSVR32 "C:\Program Files\Common Files\System\ole db\MSDASQL.DLL"

- Reinstall the Microsoft Data Access Components used. The
newest version of MDAC can be downloaded from the following
Web site:

After installing, again experiment with the setting of the
sDBDriver in include/config.asp


Next week I will publish a new article about visitors who
leave your pages before they have finished loading, and I'll
start to update my categories section to use my own Yahoo
style layout. That'll probably take more than a week of my
evenings though! A search facility might even come out of

James Shaw

[email protected]

Recommend my site to your colleagues, go to
If I've helped you, help me keep going!
To subscribe/unsubscribe from this mail, please visit

Featured sponsor
My favorite resources

Qualify for Free Trade Magazines

Free subscriptions to industry leading publications for those who qualify!

See my source code
wherever you see this icon...

You can also download the entire site source code for FREE!

CoverYourASP Mugs, T-shirts, caps - even Boxer shorts...
I don't make a penny from these, but they're a lot of fun! Don't you need a new mouse mat?

New Proposal Kit Professional 5.1
Brand yourself as a top professional: create quotes and amazing proposals and get many legal documents free!

The latter saved me 3 times the purchase price on the first day I owned it!

I share my content

Supporting ASPRSS

Do you need a quick and easy way to link to my articles? All the information you need is published with ASPRSS...