Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Professional For advanced coder questions in ASP 3. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old January 4th, 2006, 02:35 AM
Authorized User
 
Join Date: Nov 2005
Location: , , .
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default Weired Behavior ASP Files in VPN Network

I don't know how I should describe this matter :D

Okay, I have some asp pages running fine on regular ISP network environments.

I use VPN connection in order to connect with the network my company provided. When I browse in VPN environments, the pages passes only upto two asp pages (which contains database connection to use select statement). On the 3rd pages, the page doesn't go anywhere.

The page it got shopped as follows

<%@ Language=VBScript %>

<%

    If Session("Access_ok") = "" then
      Response.Redirect ("Session_End.asp")
    Else
    'Search table based on the inserted User ID
        sqlstr = "SELECT * FROM xxxx WHERE PIN_NUM = '" & pin_num & "'"
        sqlstr = sqlstr & "AND REMOTE_IP = '" & Request.ServerVariables("REMOTE_ADDR") & "'"
        set rs = dbCon.Execute(sqlstr)

        If not rs.EOF Then

%>
    <script language="javascript">
        alert("You are already voted");
        location.href = "../index.asp";
    </script>
<%
    else 'if this is the first time to participate the survey

%>

<%

      'for the first voter; save IP address and pin number

        sqlstr2 = "INSERT INTO xxxxx (PIN_NUM, REMOTE_IP) VALUES"
        sqlstr2 = sqlstr2 & "('" & Session("Access_ok") & "'"
         sqlstr2 = sqlstr2 & "," & "'" & Request.ServerVariables ("REMOTE_HOST") & "'"
         sqlstr2 = sqlstr2 & ")"

         dbCon.Execute (sqlstr2)


        End if 'end if If not rs.EOF Then

  %>
   <meta http-equiv="Refresh" Content="0; url=../en_xxx_01.asp?">

 <%
    RS.Close
    Set RS = Nothing
    dbCon.Close
 End if
 %>

I tried to save IPAddress so that once someone already came this page then I'd like to stop to access it.

I could type http://www.xxx.com/en_xxx1.asp and it goes fine.

The problem starts now.

I thought the page can't be displayed becuase I uses REMOTE_ADDR in VPN environment. So, I deleted this page and made to go to en_xxx1.asp. Now, I can't display en_xxx1.asp and can't type en_xxx1.asp to display.

Can anyone tell me what's going on??





Similar Threads
Thread Thread Starter Forum Replies Last Post
VPN on Server08 nordic Windows Server 0 September 12th, 2008 04:00 AM
do not understand asp web form behavior dhx10000 Classic ASP Professional 9 December 13th, 2006 06:34 PM
Copy Files and Folders on Local Network rupakroy5 VB.NET 2002/2003 Basics 1 May 22nd, 2006 10:09 AM
Accessing network files from IIS PC badgolfer ASP.NET 1.0 and 1.1 Basics 3 March 2nd, 2004 07:51 AM
Access VPN carlos .NET Web Services 3 November 14th, 2003 10:17 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.