PWS/IIS

Guest_imported · Feb 7, 2002

Hi all!
I have windows 2000 pro.
I am starting out the ASP.
My questions are:
1, is IIS/PWS automatically installed with win2000?
If yes, how do I check to see that it is installed and working?
2, Is there any links on how to configure IIS/PWS on your pc.
In the past, when I was not interested in it, it used to be under

http://wwwroot.

I can't find

http://wwwroot

anywhere.
Thanks in advance.

link9 · Feb 7, 2002

Contol Panel --> Add/Remove Programs --> Windows Components

Check IIS, stick in your CD, and away you go.

paul

BeckahC · Feb 7, 2002

I thought you needed to be running 2K Server in order to run ASP off of it... at least that's what I was told when they installed my machine (before they just recently installed XP Pro) You can run IIS, but when I tried to run the ASP pages it didn't work - could be my old machine, could be some kind of way they set it up for me that I never found out how to change.... BeckahC

Guest_imported · Feb 7, 2002

Thanks for the response!
I successully installed it from cd, then created a a subdirectory called EmpDB under

http://wwwroot.

tried to test it like this

http://127.0.0.1/EmpDB/myfile.asp.

but I am getting a 'page not found' error.
I also tried

http://wwwroot/EmpDB/myfile.asp

but still no cigar.
Any help on how to make it past this stage will be highly appreciated.
sam

BeckahC · Feb 7, 2002

I belive that's the same trouble I had when I had Pro instead of Server - They wound up fresh installing server for me. BeckahC

mithrilhall · Feb 7, 2002

Have you tried putting the myfile.asp page in the directory

http://wwwroot

itself (not that it should make a different, I am just curious)?

Also, go to Start-->Run then type in "Command" without the quotes. When the dos window opens type "ipconfig" without the quotes and then hit enter. This should give you the correct IP address to use (just in case your 127.0.0.1 is incorrect).

Now try connecting with the IP address you got back from ipconfig.

Good luck

Guest_imported · Feb 7, 2002

Thanks Mithrilhall and BeckahC for your response.
First, I have determined that my localhost (ip address)
is 127.0.0.1.
Infact, last year, a friend, (he has since 'disappeared')
was able to make connect with the is address and hit the database with the same win2000 pro that I have now.
What happened was that my win2000 was corrupted and I had to reinstall.
Everything works fine except this iis thing.
Any additional help will be appreciated as usual.

mithrilhall · Feb 7, 2002

Was there a Personal Web Manager icon placed on your desktop when you installed IIS? If so, double-click this, there should be a button or something to start the service if it's not already started.

Guest_imported · Feb 7, 2002

Thanks Mithrilhall for the tip! I was able to start the iis service. Yes, some progress has been made because I have been able to display the html screen. However, asp is still not hitting the database. Could it be my code?
Sorry guys, I am a complete newbie.
Please take a look at asp and the accompanying html.
Any pointers will, as usual be highly appreciated.
********************
ASP version
*******************
<%@ Language=VBScript%>
<%Response.buffer=true%>

<html>
<head>
<title>Class Records</title>
</head>

<body>

<%
Set connectionToDatabase=Server.CreateObject("ADODB.Connection&quot

Set recordSet=Server.CreateObject("ADODB.Recordset&quot

connectionToDatabase.Open "DSN=EmpDB;UID=samantha;PWD=orion"

recordSet.Open "SELECT * FROM EMP",connectionToDatabase,1,3

Dim ename, job, validate
validate=true

for each qryItem in Request.Form
if Request.Form(qryItem) = "" Then
validate = false
Response.Write("Missing : " & qryItem & "<BR>&quot

End if
next

if not validate then
Response.Write("<body bgcolor=steelblue><BR><font color=red><h3><b>" &_
"Please click the back button and complete the missing fields. " &_
"Thank You</b></h3></font></body> &quot

else

recordSet.AddNew

recordSet("EMPNO&quot

= Request.Form("Employee Id&quot

recordSet("ENAME&quot

= Request.Form("Employee Name&quot

recordSet("JOB&quot

= Request.Form("Job&quot

recordSet("MGR&quot

= Request.Form("Manager&quot

recordSet("HIREDATE&quot

= Request.Form("Hiredate&quot

recordSet("SAL&quot

= Request.Form("Salary&quot

recordSet("COMM&quot

= Request.Form("Commission&quot

recordSet("DEPTNO&quot

= Request.Form("DEPARTMENT ID&quot

recordSet.Update

connectionToDatabase.Close
Set connectionToDatabase=Nothing

end if
%>

</body>
</html>

**********************
HTML version
**********************
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE>Student Class</TITLE>
</HEAD>
<CENTER>
<BODY bgcolor="steelBLUE">
<FORM ACTION="employee.asp" METHOD="POST">
<H2><CENTER>Enter fields to be validated</CENTER></H2>
<TABLE>
<TR>
<TD ALIGN='LEFT'><EM>Employee ID</EM></TD>
<TD ALIGN='LEFT'><INPUT TYPE='TEXT' SIZE='16' MAXLENGTH='16' NAME='EMPNO' VALUE="">
</TD>
</TR>
<TR>
<TD ALIGN='LEFT'><EM>Employee Name</EM></TD>
<TD ALIGN='LEFT'><INPUT TYPE='TEXT' SIZE='16' MAXLENGTH='16' NAME='ENAME' VALUE="">
</TD>
</TR>
<TR>
<TD ALIGN='LEFT'><EM>Job</EM></TD>
<TD ALIGN='LEFT'><INPUT TYPE='TEXT' SIZE='16' MAXLENGTH='16' NAME='JOB' VALUE="">
</TD>
</TR>
<TR>
<TD ALIGN='LEFT'><EM>Manager</EM></TD>
<TD ALIGN='LEFT'><INPUT TYPE='TEXT' SIZE='16' MAXLENGTH='16' NAME='MGR' VALUE="">
</TD>
</TR>
<TR>
<TD ALIGN='LEFT'><EM>Hire Date</EM></TD>
<TD ALIGN='LEFT'><INPUT TYPE='TEXT' SIZE='16' MAXLENGTH='16' NAME='HIREDATE' VALUE="">
</TD>
</TR>
<TR>
<TD ALIGN='LEFT'><EM>Salary</EM></TD>
<TD ALIGN='LEFT'><INPUT TYPE='TEXT' SIZE='16' MAXLENGTH='16' NAME='SAL' VALUE="">
</TD>
</TR>
<TR>
<TD ALIGN='LEFT'><EM>Commission</EM></TD>
<TD ALIGN='LEFT'><INPUT TYPE='TEXT' SIZE='16' MAXLENGTH='16' NAME='COMM' VALUE="">
</TD>
</TR>
<TR>
<TD ALIGN='LEFT'><EM>Department ID</EM></TD>
<TD ALIGN='LEFT'><INPUT TYPE='TEXT' SIZE='16' MAXLENGTH='16' NAME='DEPTNO' VALUE="">
</TD>
<TD ALIGN='LEFT'><INPUT TYPE="SUBMIT" VALUE="Validate it!">
</TD>
</TR>
</TABLE>
</FORM>
</BODY>
</CENTER>
</HTML>

JennyPeters · Feb 7, 2002

Try using:

http://localhost/wwwroot/EmpDB/myfile.asp

Jenny

Guest_imported · Feb 7, 2002

Thanks Jenny!
Still getting the same stupid error:

The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.

--------------------------------------------------------------------------------

Please try the following:

Open the localhost home page, and then look for links to the information you want.
Click the Refresh button, or try again later.

Click Search to look for information on the Internet.
You can also see a list of related sites.

HTTP 500 - Internal server error
Internet Explorer

Sorry folks for clogging up the forum

Salibas · Feb 7, 2002

try

http://localhost/EmpDB/myfile.asp

1-you must create a virtual directory named "EmpDB"
2- check the security to the virtual directory from both windows security and from IIS. The group USERS must have permission to read and to write/modify on the folder of the database.

mithrilhall · Feb 8, 2002

Also, have you tried a simple <%Response.Write ("Hello World!&quot

%> ? This will tell you whether or not your asp is working.

Also, try putting <%Option Explicit%> right under <%@ Language=VBScript%>.

JennyPeters · Feb 8, 2002

I know in PWS, I have to go to the 'advanced section', highlight my 'Home' folder and then check off 'execute' in its access properties.

I don't know why this wasn't a default setting, as it took me a while to figure it out (well, this chat forum really deserves the credit...)

I'm not sure if you have to do that in IIS.

Jenny

Maroney · Feb 8, 2002

I've just used IIS for the first time and managed to do just what you're stuggling with...

I created a folder called myproject under

http://wwwroot.

created an ASP file called default.asp

in IE I typed

http://computer/myproject/default.asp

and it displayed no problems.

Everything is case sensitive so you might want to check that out. Also check the NT permissions out - you need to have sufficient priveleges to access the

http://wwwroot

directory.

Guest_imported · Feb 8, 2002

I wholeheartedly thank all of you for your time and helpful hints.
I will try them all out and let you all know it goes.
Again, please accept my thank you for your responses.

Guest_imported · Feb 8, 2002

right now, i have reached a conclusion that the problem i am having is more of secutity issue than coding issue.
I tried all your suggestions and infact i discovered a very resourceful and intuitive ASP site and after following instructions on how to install and configure iis, it still did not work.
I believe it is a security issue because the jdbc program i wrote works hits the oracle database to either retrieve, insert, delete or update records depending on what the functionality is but when i run an applet, i am having the same problem i am having with ASP.
I guess I need a win2000 pro manual to figure this thing out.
Thanks for all your responses.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

PWS/IIS

Guest_imported

New member

link9

Programmer

BeckahC

Programmer

Guest_imported

New member

BeckahC

Programmer

mithrilhall

Programmer

Guest_imported

New member

mithrilhall

Programmer

Guest_imported

New member

JennyPeters

Programmer

Guest_imported

New member

Salibas

Programmer

mithrilhall

Programmer

JennyPeters

Programmer

Maroney

Programmer

Guest_imported

New member

Guest_imported

New member

Similar threads

Part and Inventory Search

Sponsor