Access DB unable to open

I am using Windows XP with IIS and Access 2000 DB. I receive the following
ASP error:

Error Type:
Provider (0x80004005)
Unspecified error
/TEST3/sds-test/default.asp, line 9

The code at line 9 is the Con.Open "accessDSN" statement in the following
code:


<%
' Get User ID
userID = TRIM( Request.QueryString( "uid" ) )
' Get Cat
cat= TRIM( Request.QueryString( "cat" ) )
' Open Database Connection
Set Con = Server.CreateObject( "ADODB.Connection" )
Con.Open "accessDSN"
%>

Everything was fine until I tried to backup the folder on a CD. Since then I
have not been able to open the DB on any ASP page. I was unsuccessful in
burning the CD. Does any know what I can do to find out what's going on
here?

Re: Access DB unable to open

Srop using a DSN, then you might get a more specific error.
http://www.aspfaq.com/2126

Also, stop using ADOVBS.INC!
http://www.aspfaq.com/2112

--
http://www.aspfaq.com/
(Reverse address to reply.)




wrote in message
news:OHfycpaxEHA.2676@TK2MSFTNGP12.phx.gbl...
> I am using Windows XP with IIS and Access 2000 DB. I receive the following
> ASP error:
>
> Error Type:
> Provider (0x80004005)
> Unspecified error
> /TEST3/sds-test/default.asp, line 9
>
> The code at line 9 is the Con.Open "accessDSN" statement in the following
> code:
>
>
> <%
> ' Get User ID
> userID = TRIM( Request.QueryString( "uid" ) )
> ' Get Cat
> cat= TRIM( Request.QueryString( "cat" ) )
> ' Open Database Connection
> Set Con = Server.CreateObject( "ADODB.Connection" )
> Con.Open "accessDSN"
> %>
>
> Everything was fine until I tried to backup the folder on a CD. Since then
I
> have not been able to open the DB on any ASP page. I was unsuccessful in
> burning the CD. Does any know what I can do to find out what's going on
> here?
>
>

Re: Access DB unable to open

westernnord@webtv.net wrote:
> I am using Windows XP with IIS and Access 2000 DB. I receive the
> following ASP error:
>
> Error Type:
> Provider (0x80004005)
> Unspecified error
> /TEST3/sds-test/default.asp, line 9

Have you checked this out?
http://www.aspfaq.com/show.asp?id=2009


>
> The code at line 9 is the Con.Open "accessDSN" statement in the
> following code:
>
>

Instead of using the large include file, check this out:
http://www.aspfaq.com/show.asp?id=2112

> <%
> ' Get User ID
> userID = TRIM( Request.QueryString( "uid" ) )
> ' Get Cat
> cat= TRIM( Request.QueryString( "cat" ) )
> ' Open Database Connection
> Set Con = Server.CreateObject( "ADODB.Connection" )
> Con.Open "accessDSN"

Instead of using a DSN, use an OLEDB connection string:
http://www.aspfaq.com/show.asp?id=2126

> %>
>
> Everything was fine until I tried to backup the folder on a CD. Since
> then I have not been able to open the DB on any ASP page. I was
> unsuccessful in burning the CD. Does any know what I can do to find
> out what's going on here?

Can you open the database in Access? It may be corrupted.

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.