Not linking to ASP Page

[chmilz]

Hi I have a user sign in form set up on my website. After signing in the form is supposed to go to the Validate Login page. But it can't seem to find it.

All of my ASP and HTML pages are in the webroot folder on my Server. Why is the form not re-directing to the ASP page???? Here is my opening form tag

<form name=&quot;Login Form&quot; method=&quot;post&quot; action=&quot;valiidate_login.asp&quot;>

Can anyone help??? Thanks in advance.

Cheers,

Chmilz

 

[chmilz]

Hey.. I have somemore information...

I tried going directly to the validate_login page using my browser and got this message...

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NOESIS\IUSR_SERVER'.
/validate_login.asp, line 22


I set my DNS on my ASP like this:

strUsername = Request.Form(&quot;Username&quot
strPassword = Request.Form(&quot;Password&quot
SQL = &quot;SELECT * FROM Users Where Username='&quot; & Username & &quot;'&quot;

set adoConn = Server.CreateObject (&quot;ADODB.Connection&quot
set adoRS = Server.CreateObject (&quot;ADODB.RecordSet&quot
adoConn.Open &quot;DSN=LocalServer&quot;
adoRS.Open SQL,adoConn

 

[GaryC123]

Well I assume the validate form is in the same directory, apart from that your sql statement is trying to reference a name that is undefined, you assign strUsername but in your sql statement you use Username. <p><b><font face=&quot;Arial&quot; size=&quot;2&quot;>
<span style=&quot;FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial&quot;>
Saturday...... &nbsp; 12:00hrs.....</span></font></b><img src=&quot;

http://www.booknowlimited.com/iconimages/image006.gif&quot;><img

height=&quot;50&quot; src=&quot;

http://www.booknowlimited.com/iconimages/image002.gif&quot;

wi

 

[chmilz]

Hello again,

I figured out the problem with getting to the ASP page but I still can't access my SQL Server. Like I said, I have SQL Authentication set up but I may not have it configed properly. I am currently connecting thru a system DSN called localServer. do I have to supply a username and password when I declare it in my ASP page????

This is the error I get:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NOESIS\IUSR_SERVER'.
/validate_login.asp, line 22


This is how I connect my DSN:
set adoConn = Server.CreateObject (&quot;ADODB.Connection&quot
set adoRS = Server.CreateObject (&quot;ADODB.RecordSet&quot
adoConn.Open &quot;DSN=LocalServer&quot;
adoRS.Open SQL,adoConn