SitePoint Sponsor

User Tag List

Results 1 to 10 of 10
  1. #1
    SitePoint Member
    Join Date
    Aug 2010
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Help! ASP classic with IIS7

    Hi Guys,

    Ok. Let me open this discussion but letting you all know that I am not a programmer in ASP classic or aspx. I have a website installed on my local computer which is a course i need to take. I just purchased a new laptop with win 7 and I cant seem to make it work. Prior to that it worked fine on win xp.

    The first page index.asp works fine, but once you enter user, password it will give the error 500. The file its supposedly needs to go to is memebers.asp which is in that same root directory.

    Before coming on the forum, I have tried numeroud tutorials on how to get asp classic to work on win 7, and was not successful. I also consulted a friend which had some experience with asp but still no results.

    Please help me get this local site running as it is very important for my career.

    Looking forward to hearing from you,

    Gil Alon

  2. #2
    SitePoint Wizard siteguru's Avatar
    Join Date
    Oct 2002
    Location
    Scotland
    Posts
    3,629
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    To work out what's wrong you need to be seeing proper error messages, not "friendly" errors. First port of call is (if you're using IE) to uncheck "Show friendly HTTP error messages" in the Advanced tab of Internet Options.

    After that you may need to updated the IIS7 config to pass-through error messages. Google will yield help on this, but try the IE setting change above first.
    Ian Anderson
    www.siteguru.co.uk

  3. #3
    SitePoint Member
    Join Date
    Aug 2010
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi Siteguru,

    So I checked the options both in ie and in iis manager and they are both set as follows:

    1) IE Dont display friendly error messages

    2) IIS Manager: Display detailed messages

    When loading the index.asp file, i get this error on the page along with the page it self:

    An error occurred on the server when processing the URL. Please contact the system administrator.
    If you are the system administrator please click here to find out more about this error.


    When I click on the link, this is where it takes me:
    http://learn.iis.net/page.aspx/559/r...70-and-iis-75/


    Any ideas?

    Thanks,
    Gil Alon

  4. #4
    SitePoint Wizard siteguru's Avatar
    Join Date
    Oct 2002
    Location
    Scotland
    Posts
    3,629
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    http://learn.iis.net/page.aspx/564/c...er-by-default/

    That's the appropriate link for your issue.
    Ian Anderson
    www.siteguru.co.uk

  5. #5
    SitePoint Member
    Join Date
    Aug 2010
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi Site guru,

    Thanks, the error was a db not created. I will create the db and link it to the microsoft access db file i have

    Ill get back if i have issues

    Thanks again guys!

    Gil

  6. #6
    SitePoint Member
    Join Date
    Aug 2010
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ok. I am back.

    So I have this .mdb file. I opened it with ms access but i have no idea how to link the file to the site. Any one?

  7. #7
    SitePoint Guru
    Join Date
    Jun 2007
    Posts
    689
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    we can't teach ytou everything about ASP here

    take a look at this site it has lots of valuable "how to" stuff

    http://www.maconstateit.net/tutorials/default.aspx

  8. #8
    SitePoint Member
    Join Date
    Aug 2010
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question

    Ouch,
    That last comment hurt.

    I am not here to learn asp. I am here because I have a course which was installed on my laptop. (Previously windows xp) and it worked flawlessly.

    Now, its windows 7, so its all new to me, Now I have advanced alot by myself, but again I am stuck. This time, its a permission issue. I have searched the net with no success. Here is the error i am getting:

    [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.

    /local-wings/db/conn.asp, line 8


    Here is conn.asp:

    Code ASP:
    <%
      dim conn,rs
     
      sub opener(byref conn,byref rs)
    	set conn=server.CreateObject("adodb.connection")
    	set rs=server.CreateObject("adodb.recordset")
     
    	conn.Open "DSN=localwings;"
      end sub
     
      sub closer(byref conn,byref rs)
    	conn.Close
    	set conn=nothing
    	set rs=nothing
      end sub
     
      function CSpell(byval word)
    	if word<>"" then
    		CSpell=replace(word,"'","''")
    	end if
      end function
     
      function DSpell(byval word)
    	if word<>"" then
    		DSpell=replace(word,"<","&lt;")
    		DSpell=replace(DSpell,">","&gt;")
    		DSpell=replace(DSpell,"&","&amp;")
    		DSpell=replace(DSpell,vbcrlf,"<br/>")
    	end if
      end function
     
       function PSpell(byval word)
    	if word<>"" then
    		PSpell=replace(word,"<","&lt;")
    		PSpell=replace(PSpell,">","&gt;")
    		PSpell=replace(PSpell,"&","&amp;")
    		PSpell=replace(PSpell,vbcrlf,"<br>")
    		PSpell=replace(PSpell,"/::","<")
    		PSpell=replace(PSpell,":/:","</")
    		PSpell=replace(PSpell,"::/",">")
     
    	end if
      end function
     
      function PSpell2(byval word)
    	if word<>"" then
    		PSpell2=replace(word,"""","&quot;")
    		PSpell2=replace(PSpell2,"'","'")
    	end if
      end function
     
      dim REQUIRED
     
      REQUIRED="<span class=""required"">*</span>" 'adding before a required field in a form
      const MAX_RECORDS=20
    %>



    I have tried changing folder permissions, and permissions via the iis7 application. Ofcourse I created a System DSN named "localsings" via odbc. Couldnt find anything on the net. Please help me as this is a course I am taking. Not that it matters to you, but I am a corpoate jet pilot and this course will help me advance to bigger and faster aircrafts.

    Once again, thank you in advance.

    Gil
    Last edited by Mittineague; Aug 25, 2010 at 22:05. Reason: adding bbcode tags

  9. #9
    SitePoint Guru
    Join Date
    Jun 2007
    Posts
    689
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    look for a " loc" file in the folder where the database resides. if one exists delete it.

    make sure access is closed and no other application is using the database.

    also make sure access does not have password protection on the database

  10. #10
    SitePoint Wizard siteguru's Avatar
    Join Date
    Oct 2002
    Location
    Scotland
    Posts
    3,629
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Or if it does, make sure you define the password in your connection string/DSN.
    Ian Anderson
    www.siteguru.co.uk


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
  •