<% ' 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? [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => [ip] => westernnord@web [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 1 [islastshown] => [isfirstshown] => 1 [attachments] => [allattachments] => ) --> > <% > ' 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[/ref] I[ref] > 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? > >[/ref] [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => <#oJOStaxEHA.4028@TK2MSFTNGP15.phx.gbl> [ref] => [htmlstate] => on_nl2br [postusername] => Aaron [ip] => ten.xoc@dnartre [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 2 [islastshown] => [isfirstshown] => [attachments] => [allattachments] => ) -->[/ref] Instead of using the large include file, check this out: http://www.aspfaq.com/show.asp?id=2112 [ref] > <% > ' 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"[/ref] Instead of using a DSN, use an OLEDB connection string: http://www.aspfaq.com/show.asp?id=2126 [ref] > %> > > 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?[/ref] 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. [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => Bob [ip] => reb01501@NOyaho [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 3 [islastshown] => 1 [isfirstshown] => [attachments] => [allattachments] => ) --> Access DB unable to open - ASP Database

Access DB unable to open - ASP Database

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: <!-- #INCLUDE FILE="adovbs.inc" --> <% ' 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 ...

  1. #1

    Default 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:

    <!-- #INCLUDE FILE="adovbs.inc" -->
    <%
    ' 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?


    Guest

  2. #2

    Default 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.)




    <net> wrote in message
    news:phx.gbl... 



    Aaron Guest

  3. #3

    Default Re: Access DB unable to open

    net wrote: 

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

     

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

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

    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.


    Bob Guest

Similar Threads

  1. Unable to open....
    By kreizharris in forum Macromedia Flash Player
    Replies: 2
    Last Post: April 30th, 01:31 AM
  2. Replies: 1
    Last Post: April 9th, 05:06 PM
  3. FH MX unable to open PDF from InD-CS
    By Eric Otto in forum Macromedia Freehand
    Replies: 1
    Last Post: March 7th, 02:27 PM
  4. dl() unable to open library
    By Eike Umlauf in forum PHP Development
    Replies: 0
    Last Post: August 20th, 11:51 AM
  5. Unable To Open File "..." Because It Is Already Open With Write Permission
    By PixelaseR webforumsuser@macromedia.com in forum Macromedia Director Basics
    Replies: 1
    Last Post: August 18th, 06:33 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •