Bill wrote:
When the output is a html table it says:
Provider error '80004005'
Unspecified error
/myreport.asp, line 644
line 644 is: objRS.movefirst (goto the first line in the record set)
When the output is excel the error occurs after you accept the file
download:
Internet Explorer cannot download myreport.asp from mysite.
Internet Explorer was not able to open this Internet site. The
requested site is either unavailable or cannot be found.
We are building the file on the server then downloading or displaying
it.
These report have been working since January but we just upgraded
hardware and now we have a problem. Go figure :-)
TIA, Bill
Tim replies:
After some research, it looks like most of the 80004005 errors are
related to Access DB connections; if you're using Access, here's some
suggestions I collated from various places:
1. Upgrade the your version of MDAC (I think 2.7 is the latest stable
version).
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.
com:80/support/kb/articles/q225/0/42.asp&NoWebContent=1
2. Double-check the connection string for correct permissions; sometimes
username and password are needed even when not required. Better yet,
move to a DSN-less connection.
3. Make sure your TEMP folder (usually C:/temp) is present and has
adequate permissions, if using Access (we fought this problem on some
new machines, and it's a common problem with new hardware). You may
need to tweak environment variables to make sure the TEMP folder is
recognized. Access uses the TEMP folder to do intermediate work.
http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=115
4. Make sure you're not using any reserved words as field or column
names.
5. Other suggestions regarding MDAC and Access:
http://www.aspfaq.com/show.asp?id=2009 They recommend MDAC 2.8; I don't
know that I'd go that far...we've used MDAC 2.7 successfully for awhile.
2.5 is considered quite stable as well.
6. If using Access, make sure nothing else is connected to it at the
same time the ASP is running, including IDEs like InterDev.
Another thought (for the download version): IE shouldn't be trying to
download the "myreport.ASP" file. Might want to check MIME types for
Excel. I haven't downloaded Excel files myself, but usually when a
browser tries to directly download an ASP file there's either something
screwy with permissions or the page code. Might want to verify that the
file is actually being built on the server (and has enough time to
complete building, for long ones) before the download is attempted.
Hope one of these helps.
Tim
____ • The WDVL Discussion List from WDVL.COM • ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To set a personal password send an email to [EMAIL PROTECTED] with the words: "set
WDVLTALK pw=yourpassword" in the body of the email.
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
