Microsoft IIS
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsSystem AdministrationMicrosoft IIS

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old February 14th, 2005, 02:00 PM
scottb scottb is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Nov 2004
Location: UK
Posts: 30 scottb User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 3 h 58 m
Reputation Power: 4
Exclamation Can't display or get login page to work?

Hi

I am trying to create a simple login page for my website in asp. I am using Dreamweaver and have setup a simple database in access containing just one table with username and password. I have set the DSN and put in the asp code, but it just isn’t working for!

I have got as far as the login screen being displayed, but when I type in the username and password it just takes me to the ‘this page can not be displayed message’. It doesn’t matter whether or not the details are right or wrong, it still displays this page.

Now it won’t display at all and I am getting the following error message:


Quote:
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:



  • Click the Refresh button, or try again later.
  • Open the localhost home page, and then look for links to the information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services




Technical Information (for support personnel)



  • Error Type:



    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)



    [Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.



    /Fairfield/login.asp, line 8
  • Browser Type:



    Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.5) Gecko/20041107 Firefox/1.0
  • Page:



    GET /Fairfield/login.asp
  • Time:



    Monday, February 14, 2005, 7:51:40 PM
  • More information:



    Microsoft Support



I have looked at the MS knowledge base articles and stuff from macromedia and have set all the correct permissions for the database file and have also changed the ‘timeout’ option of the DSN to 5000 as advised.

I just can’t get this to work and don’t know where to turn.


Any help will be greatly appreciated.

Reply With Quote
  #2  
Old February 14th, 2005, 02:06 PM
scottb scottb is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Nov 2004
Location: UK
Posts: 30 scottb User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 3 h 58 m
Reputation Power: 4
Here is the error message from IE - is there a possibility that the asp code contains an error?

Quote:
Technical Information (for support personnel)


  • Error Type:

    Provider (0x80004005)

    Unspecified error

    /Fairfield/login.asp, line 8
  • Browser Type:

    Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
  • Page:

    POST 25 bytes to /Fairfield/login.asp
  • POST Data:

    user=&pass=&Submit=Submit
  • Time:

    Monday, February 14, 2005, 8:03:18 PM
  • More information:

    Microsoft Support

Reply With Quote
  #3  
Old February 14th, 2005, 06:21 PM
Doug G Doug G is offline
Grumpier Old Moderator
ASP Free God 11th Plane (10000 - 10499 posts)
 
Join Date: Sep 2003
Posts: 10,143 Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 3 Weeks 4 Days 21 h 32 m 23 sec
Reputation Power: 180
My guess is you haven't granted the correct file permissions to the .mdb file & folder.
__________________
======
Doug G
======
I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain

Reply With Quote
  #4  
Old February 14th, 2005, 06:23 PM
lewy's Avatar
lewy lewy is offline
Alter Ego Wizard
ASP Free Specialist (4000 - 4499 posts)
 
Join Date: Jun 2004
Location: Edinburg Tx
Posts: 4,376 lewy User rank is General 6th Grade (Above 100000 Reputation Level)lewy User rank is General 6th Grade (Above 100000 Reputation Level)lewy User rank is General 6th Grade (Above 100000 Reputation Level)lewy User rank is General 6th Grade (Above 100000 Reputation Level)lewy User rank is General 6th Grade (Above 100000 Reputation Level)lewy User rank is General 6th Grade (Above 100000 Reputation Level)lewy User rank is General 6th Grade (Above 100000 Reputation Level)lewy User rank is General 6th Grade (Above 100000 Reputation Level)lewy User rank is General 6th Grade (Above 100000 Reputation Level)lewy User rank is General 6th Grade (Above 100000 Reputation Level)lewy User rank is General 6th Grade (Above 100000 Reputation Level)lewy User rank is General 6th Grade (Above 100000 Reputation Level)lewy User rank is General 6th Grade (Above 100000 Reputation Level)lewy User rank is General 6th Grade (Above 100000 Reputation Level)lewy User rank is General 6th Grade (Above 100000 Reputation Level)lewy User rank is General 6th Grade (Above 100000 Reputation Level)  Folding Points: 1009 Folding Title: Novice Folder
Time spent in forums: 1 Month 1 Week 1 Day 21 h 21 m 31 sec
Reputation Power: 1391
Post your relevant code for line 8 and your connection details.

Reply With Quote
  #5  
Old February 15th, 2005, 12:10 PM
scottb scottb is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Nov 2004
Location: UK
Posts: 30 scottb User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 3 h 58 m
Reputation Power: 4
Thanks for the replys!

Got it sorted, permissions were fine but there was an error in the code that Dreamweaver generated! It had listed two lines the same - @LANGUAGE="VBSCRIPT"
@LANGUAGE="VBSCRIPT"

I have got the login working and i am well pleased but the only bit left at the minute which is posing a problem is the search page.

Quote:
Error Type:
Active Server Pages, ASP 0126 (0x80004005)
The include file '/Connections/bookstore.asp' was not found.
/Fairfield/search_results.asp, line 2

I have setup the connection in dreamweaver and put it in the connections folder in the WWWROOT, is there anything i am missing?

Thanks again

Reply With Quote
  #6  
Old February 15th, 2005, 12:12 PM
Memnoch's Avatar
Memnoch Memnoch is offline
Unholy Moderator
ASP Free God 14th Plane (11500 - 11999 posts)
 
Join Date: Oct 2003
Location: In hell, where did you think?
Posts: 11,760 Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level) 
Time spent in forums: 3 Weeks 5 Days 5 h 22 m 16 sec
Reputation Power: 443
mmm...how about making sure that file is actually there??

Reply With Quote
  #7  
Old February 15th, 2005, 01:58 PM
scottb scottb is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Nov 2004
Location: UK
Posts: 30 scottb User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 3 h 58 m
Reputation Power: 4
Yes it is there, obviously that was the first thing I checked!

Anything else it might be?

Reply With Quote
  #8  
Old February 15th, 2005, 06:28 PM
Doug G Doug G is offline
Grumpier Old Moderator
ASP Free God 11th Plane (10000 - 10499 posts)
 
Join Date: Sep 2003
Posts: 10,143 Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 3 Weeks 4 Days 21 h 32 m 23 sec
Reputation Power: 180
Post the include code. The file might exist but it's obviously not at the path your code is providing.

Reply With Quote
  #9  
Old February 16th, 2005, 10:13 AM
scottb scottb is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Nov 2004
Location: UK
Posts: 30 scottb User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 3 h 58 m
Reputation Power: 4
Arrow

Right, here is the include file code:

Quote:
<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_bookstore_STRING
MM_bookstore_STRING = "dsn=bookstore;"
%>


and here is where it refers to it in my search page code:

Quote:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include virtual="/Connections/bookstore.asp" -->
<%

I have the include file in the wwwroot directory of IIS and its in Fairfields/Connections/bookstore.asp

Hope this helps! Cheers again

Reply With Quote
  #10  
Old February 24th, 2005, 08:52 PM
Doug G Doug G is offline
Grumpier Old Moderator
ASP Free God 11th Plane (10000 - 10499 posts)
 
Join Date: Sep 2003
Posts: 10,143 Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 3 Weeks 4 Days 21 h 32 m 23 sec
Reputation Power: 180
You are using a DSN, are you sure it's set up properly on the web server?

Reply With Quote
Reply

Viewing: ASP Free ForumsSystem AdministrationMicrosoft IIS > Can't display or get login page to work?


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway