Problem with IIS

[Ed Richter]

I'm trying to use IIS as a personal web server. Running XP Pro. I've added my website to IIS by following instructions of creating a "virtual directory". That seemed to work and could go to browser window, type in http://name_of_machine/alias_name and website default page would open. Can browse to any htm pages fine, but as soon as I try to retieve an ASP page, it just sits there churning. Doesn't give me an error or times out, but won't display page either. Any idea's on what I'm doing wrong??

 

[Kathleen Anderson [MVP - FP]]

Are you running Norton Antivirus? If so, disable the Enable Script Blocking
function.
http://service1.symantec.com/SUPPOR...5694500552355&dtype=&prod=&ver=&osv=&osv_lvl=

 

[Ed Richter]

Yes am running Norton. That helped! Got me further than before. Now page
attempts to load, but then get the following error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 3.
website_reg/login_validate.asp, line 79


However, when I log in from real site on remote server on web, this works
fine. Why would IIS only give me this error? Line 79 BTW is opening the
database as listed below. Again works on web, but not local though IIS??

Set rsObj= objConn.Execute("SELECT ID_num, L_name, Info, Pass_wd,
Updated_date FROM personal_info WHERE L_name='" & Request.Form("L_name") &"'
AND Pass_wd='" & Request.Form("Pass_wd") &"'")

 

[Jon Spivey]

Hi,
There's only 2 things that can go wrong with a database query
1/ you're not getting the data you expect (from your form) to build a valid
sql statement
2/ you are building a valid sql statement but the database isn't returning
the data you expect
first thing I'd try is response.writing the sql, eg
<%
sql = "SELECT ID_num, L_name, Info, Pass_wd, Updated_date FROM personal_info
WHERE L_name='" & Request.Form("L_name") &"' AND Pass_wd='" &
Request.Form("Pass_wd") &"'"
resonse.write sql
response.end
%>
This should tell us if you're getting the data you expect from your form.
If the sql looks sensible try copying and pasting it into Access and see if
it returns anything. Most times I've had this error it 's been something
silly like typo in a column name - double check.

--
Cheers,
Jon
Microsoft MVP - FP

Yes am running Norton. That helped! Got me further than before. Now page
attempts to load, but then get the following error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 3.
website_reg/login_validate.asp, line 79


However, when I log in from real site on remote server on web, this works
fine. Why would IIS only give me this error? Line 79 BTW is opening the
database as listed below. Again works on web, but not local though IIS??

Set rsObj= objConn.Execute("SELECT ID_num, L_name, Info, Pass_wd,
Updated_date FROM personal_info WHERE L_name='" & Request.Form("L_name") &"'
AND Pass_wd='" & Request.Form("Pass_wd") &"'")

Are you running Norton Antivirus? If so, disable the Enable Script Blocking

http://service1.symantec.com/SUPPOR...v.nsf&view=aab56492973adccd8825694500552355&d
type=&prod=&ver=&osv=&osv_lvl=

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

 

[Ed Richter]

But why would it work fine when I go to my actual website on the web, but
not work when I'm using IIS as a webserver?

Hi,
There's only 2 things that can go wrong with a database query
1/ you're not getting the data you expect (from your form) to build a valid
sql statement
2/ you are building a valid sql statement but the database isn't returning
the data you expect
first thing I'd try is response.writing the sql, eg
<%
sql = "SELECT ID_num, L_name, Info, Pass_wd, Updated_date FROM personal_info
WHERE L_name='" & Request.Form("L_name") &"' AND Pass_wd='" &
Request.Form("Pass_wd") &"'"
resonse.write sql
response.end
%>
This should tell us if you're getting the data you expect from your form.
If the sql looks sensible try copying and pasting it into Access and see if
it returns anything. Most times I've had this error it 's been something
silly like typo in a column name - double check.

--
Cheers,
Jon
Microsoft MVP - FP

Yes am running Norton. That helped! Got me further than before. Now page
attempts to load, but then get the following error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 3.
website_reg/login_validate.asp, line 79


However, when I log in from real site on remote server on web, this works
fine. Why would IIS only give me this error? Line 79 BTW is opening the
database as listed below. Again works on web, but not local though IIS??

Set rsObj= objConn.Execute("SELECT ID_num, L_name, Info, Pass_wd,
Updated_date FROM personal_info WHERE L_name='" & Request.Form("L_name") &"'
AND Pass_wd='" & Request.Form("Pass_wd") &"'")

Are you running Norton Antivirus? If so, disable the Enable Script Blocking

http://service1.symantec.com/SUPPOR...v.nsf&view=aab56492973adccd8825694500552355&d

type=&prod=&ver=&osv=&osv_lvl=