ADO error loading ASP webpage?

From: Dave K. (canadave_at_shawyouwill.ca)
Date: 02/29/04 

Date: Sun, 29 Feb 2004 01:37:33 GMT

Hi everyone,

I'm relatively new to databases and ADO connections and such...so please
bear with me :)

I'm designing a web page for my charity; the page is going to list the
parenting programs we offer. I figured I'd do a simple MS Access 2002
database and post the info from the database onto the web page using ASP.
The database simply has information on our programs such as the program
name, dates offered, text description of the program, and building location.
There are only about ten programs in the database. (First question--is this
the best way to do this? Or is there a better way, especially given how
small the database is?)

Everything seemed to be going swimmingly. I entered three programs' worth
of data just to test it out, and the ASP web page loaded perfectly. I could
even hit "Refresh" and the page would reload without any errors.

I noticed the database file size was getting a tiny bit large (500KB, after
I had only entered three programs' worth of data!), so I chose to do
"Compact and Repair". This lowered the file size to 144KB. I then uploaded
the database to the webserver.

Now, when I go to the ASP web page, it loads the page without any problems
as it did before; but if I *refresh* the page, now it gives me an error:

Provider error '80004005'
Unspecified error

/programs.asp, line 29

Hmmmm. OK, line 29 points to a line of code in my ASP page which reads:

adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath("APFAprograms.mdb")

I usually then have to wait about a minute; then, if I reload the web page a
second time, the page loads normally again.

I have the sinking feeling I've done something silly, but I don't know
enough about all this to figure out what it could be. Does anyone know what
I'm doing wrong?

Thanks!
Dave K.

Relevant Pages

  • security settings.
    ... I'm using IIS 6.0 ... >database with an asp web form, ... >permissions and IIS permissions correctly so I can avoid ...
    (microsoft.public.inetserver.iis.security)
  • Re: ADO error loading ASP webpage?
    ... relatively static information, especially the one which is not going to ... > database and post the info from the database onto the web page using ASP. ... > of data just to test it out, and the ASP web page loaded perfectly. ... > Provider error '80004005' ...
    (microsoft.public.data.ado)
  • Re: Help.. how to browse to file and create hyperlink in database
    ... form header. ... > the file name and path to be put into the database. ... > J. Paul Schmidt, Freelance ASP Web Designer ... > ASP Designer Tips, ASP Web Database Demo, Free ASP Bar Chart Tool... ...
    (microsoft.public.inetserver.asp.general)
  • if.. else.. statement problem
    ... It's for asp web page, and is linked to my database, but i figured since ... All i am trying to, is, on my web page I have a table cell, that feeds off ... content in the above field, i want to display a different field, called ...
    (microsoft.public.inetserver.asp.general)
  • Re: if.. else.. statement problem
    ... >> It's for asp web page, and is linked to my database, but i figured since ... >> it to be displayed, If not, then rather the cell return a blank field, I ... >> content in the above field, i want to display a different field, called ...
    (microsoft.public.inetserver.asp.general)