Help! ASP classic with IIS7

[giladal]

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

[siteguru]

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.

[giladal]

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

[siteguru]

http://learn.iis.net/page.aspx/564/c...er-by-default/

That's the appropriate link for your issue.

[giladal]

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

[giladal]

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?

[webber123456]

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

[giladal]

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:

<%
  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

[webber123456]

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

[siteguru]

Or if it does, make sure you define the password in your connection string/DSN.