like I said you made changes to something to cause that...

users/user_area.asp

runs fine the way it ships "it is one of things I tested earlier when I looked at your installation for you"

If you want I'll go look via FTP and tell you what is wrong

Upgrade from V6 to v7.x with an MSSQL SERVER DATABASE

1st of all, backup your existing ASPProtect files and database before performing this upgrade. Please be really careful while performing this upgrade. Version 7.x  is a highly advanced application compared to any previous versions. CJWSoft under no circumstances is responsible if you lose information or have website downtime.

BOTTOM LINE: (PERFORM THIS UPGRADE AT YOUR OWN RISK)

To do this upgrade you're going to need to have SQL Enterprise Manager and SQL Query Analyzer

That being said, on with the upgrade..

Open your SQL database in SQL Enterprise Manager

Regarding the following Tables

Rename "Users" to "ASPP_Users"
Rename "Groups" to "ASPP_Groups"

If you do not have a "Groups" table do not worry about it right now.

Now right click and DELETE the Config Table.
Yes, delete it..

Now, go into Design View for the "ASPP_Users" Table.

Rename the "Password" field to "Old_Password"
Be sure to spell it perfectly using the Underscore

If you have a "Groups" Field... leave it alone
If you do not have a "Groups" Field add one and make it a "nvarchar" field with a lengh of 255.

Now, we are going to add a few more new fields.

Add a field called "Redirection_URL" make it a "nvarchar" field with a lengh of 150.
Add a field called "PayPal_Subscriber_ID" make it a "nvarchar" field with a lengh of 100.
Add a field called "Newsletter" and make it a "bit" field
Add a field called "Password" and make it a "nvarchar" field with a lengh of 100.

Now close that window and save the changes..

Download these scripts.
2005-02-23_171110_aspprotect_v7_sql_upgrade_scripts.zip

Now open up SQL Query Analyzer
Connect to your SQL server.

Then load the script  "aspprotect_v7_config_table.sql" into the Query Analyzer.  Click the green play button at the top. If everything goes well the response should read something like this.

******************************************************
(1 row(s) affected)
******************************************************

Now, if you had a Groups Table your done with the database changes.

If you didnt have a groups table.

Then load the script  "aspprotect_v7_groups_table.sql" into the Query Analyzer.  Click the green play button at the top.

Now, go back to your database in Enterprise Manager and make sure all 3 tables are there and look ok. You might need to do a refresh or two to see them.

Now make sure an existing or new SQL user has (public / datareader / datawriter) permissions for all three tables. You reference this user in the asp code connection string so this user must be set up correctly. You may need your SQL server admins or hosting company to help you on this step as you may not have access to do this. You may not need to create a user and set permissions as the sql user you were logged in as to use query analyzer may by default get the correct permissions on anything you create.

Regardless, as you can see from this screenshot I have a SQL user called "aspprotectuser" and proceeded to set the permissions for that user. Under database access giving him (public,datareader, and datewriter permissions).


Now, you are done upgrading your SQL Server Database.

The existing passwords still have to be encrytped and moved from the "Old_Password" to the "Password" field

To that we have a special page we run in the application that will take care of that.

So, for now... go install the application, but using the database we just created.
Follow these instructions for the most part...
http://support.cjwsoft.com/forum/forum_posts.asp?TID=181& ; ;PN=1

When you get to the part where you finally get into the admin area and need to make an admin account you will notice that your existing user database is there but none of the users have passwords if you look at them in the edit screen.

That is normal. Simply do what the instructions say and create and admin account using a username that does not exist..

Then log off... then back in as that new admin account. If that works you are ready to convert the passwords.

This part is very easy.

You want to run a special page via the browser.

http://www.mysite.com/password_admin/convert_to_encrypted.asp

Replacing the part in blue with your website info.

Once you get the page running you will see a login prompt and one form field just like before with the "get_me_in.asp" page

You will need to paste the "PasswordEncryptionKey" value that you used in the "config_inc.asp" file in the form field and hit enter.

If all goes well you will see a page telling you to click here to encrypt the passwords and copy them over.

So do what it says... dont click more than once and wait.

Eventually it should say it is finished. So go log in to the admin area of the system using the new admin account.

Now edit some users but dont save... you want to see if the passwords are showing up. If they are the conversion worked. If you see nothing or a garbled mess it did not work and you made a mistake during this whole process.

If things went well backup and delete the conversion file below.

http://www.mysite.com/password_admin/convert_to_encrypted.asp

You do not need it anymore.

Once you are positive every thing is running smoothly and everyone's passwords are ok you can go in and delete the "Old_Password" field as well.



If things didnt go well.. try again from scratch and go slowly.
If they still dont go well get ahold of us for help.

We are here to help, but if you really want us to we can be hired to do the conversion.

It should be released sometime late May 2004 or early June 2004 but no gurantees as I am pretty busy right now with some projects.

There will be upgrade instructions and it should be a fairly easy upgrade.

[/QUOTE]

Like I said no guarantee... I have a lot of things going on... it might not even be finished till the end of July... customers will always be able to get it for the difference in price

You have the version listed on the site when you purchassed it.
Version 3.0

Yes, thats cool.. post it here for sure.

Also, the way you allowed for your search engine is clever and probably was the easiest way to go.

You could do the same thing with the IP. Much easieri than the way I was thinking of doing it.

Hi,

I wanted to see if you had any suggestions for converting from Access to SQL sever database. I attempted this earlier today performing the following steps.

1) Create SQL Tables using Enterprise Manager / SQL Scripts
2) Use DTS to move all of the existing table data to the sql tables.
3) Update dataconn_inc.asp to use SQL and the required connection string.

When these steps were complete I was able to login to ASPProtect as an admin and search / find both groups and users. However, any attempt to edit or create users resulted in a "the page ... had a problem ... " type problem. It seems that I can read from the db fine but and getting errors writing to the tables. The user id that is being used to connect to the db is the [dbo].

Any additional hints for this procedure?

Thanks

Darrell

Hi

I've tried almost anything here... I'm using an online SQL SERVER database with ASPProtect 7, and I can't login after my initial creation of the admin account.

It works fine with Access... I believe I have checked all the fields created by the sql statement (which was run with no errors),

What could be the problem here? could it be a problem that I run my local IIS against the online sql server?

sincerely,

Morten

humm, did you edit any of the registration code ?
this is not something anyone has ever mentioned and the aspprotect 6 code has not been changed in over a year ?

can I see where there is happening ?
I may need ftp or frontpage access to the server in order to troubleshoot unless you can provide me with more details here.

thx..

I have purchased ASPProtect to secure a web site that I administor for a soccer league.  I am having a hard time getting the code to execute.  the instructions are to include this code at the top of the web page under the Language identifier.  Like this I think:

<%@ LANGUAGE="VBSCRIPT" %>

<!-- Begin ASPProtect Code -->
<!-- Groups with access to this page. ( * Admins * ) -->
<% GROUPACCESS = "4" %>
<!--#INCLUDE FILE="check_user_inc.asp"-->
<!-- End ASPProtect Code -->

However, nothing happens.  I am not sure if I am missing something. 

FYI:  the "Check_user_inc.asp" file is in the root directory of the site which is actually two levels down on the d: drive of the server.
      The web page code is located below.

Any help is greatly appreciated.

<html>
<head>
<title>TeamManagers</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#006600">
<div id="Layer1" style="position:absolute; left:125px; top:109px; width:682px; height:597px; z-index:1">
  <table width="655" border="1" name="teambios" bgcolor="#FFFFFF" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF" height="312">
    <tr bordercolor="#006600">
      <td bgcolor="#006600" width="154" height="33"><b><font face="Arial, Helvetica, sans-serif" color="#FFFFFF">Division
        1</font></b></td>
      <td bgcolor="#006600" width="160" height="33"><b><font face="Arial, Helvetica, sans-serif" color="#FFFFFF">Division
        2</font></b></td>
      <td bgcolor="#006600" width="148" height="33"><b><font face="Arial, Helvetica, sans-serif" color="#FFFFFF">Division
        3</font></b></td>
    </tr>
    <tr>
      <td width="154" height="26">&nbsp;</td>
      <td width="160" height="26">&nbsp;</td>
      <td width="148" height="26">&nbsp;</td>
    </tr>
    <tr>
      <td width="154" height="26"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/BHawks/BHawks_search.htm">Black
        Hawks</a></font></b></td>
      <td width="160" height="26"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/Gunners/TFC_search.htm">Gunners</a ></font></b></td>
      <td width="148" height="26"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/InterFC/InterFC_search.htm">Inter
        FC </a></font></b></td>
    </tr>
    <tr>
      <td width="154" height="26"><font face="Arial, Helvetica, sans-serif"><img src="/Images/clearpixel.gif" width="1" height="1"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/DCove/DCove_search.htm">Deep
        Cove Brewers</a></font></b></font></td >
      <td width="160" height="29" valign="top"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/NSReds/NSReds_search.htm">North
        Shore Reds</a></font></b></td>
      <td width="148" height="26"><font face="Arial, Helvetica, sans-serif"><img src="/Images/clearpixel.gif" width="1" height="1"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/BFC%20Blackhawks/BFC_search.htm">LV
        BFC Blackhawks</a></font></b></font>< /td>
    </tr>
    <tr>
      <td width="154" valign="top" height="28"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/FatBoys/FatBoys_search.htm">Fat
        Boys</a></font></b></td>
      <td width="160" valign="top" height="28"> <p><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/NSIndians/NSIndians_search.htm">Squam ish
          Nation United</a></font></b></p></td>
      <td width="148" valign="top" height="28"><b><font face="Arial, Helvetica, sans-serif"><b><font face="Arial, Helvetica, sans-serif"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/NSYoungGuns/NSYoungGuns_search.htm">N orth
        Shore Young Guns</a></font></b></font></b> </font></b></td>
    </tr>
    <tr>
      <td width="154" valign="top" height="29"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/LEI/LEI_search.htm">LEIFC</a>&l t;/font></b></td>
      <td width="160" valign="top" height="29"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/UFK/UFK_search.htm">UFK
        United</a></font></b></td>
      <td width="148" valign="top" height="29"><b><font face="Arial, Helvetica, sans-serif"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/Saints/Saints_search.htm">Northland
        Saints</a></font></b></font></b&g t;</td>
    </tr>
    <tr>
      <td width="160" height="27" valign="top"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/Lightning/Lightning_search.htm">Light ning</a></font></b></td>
      <td width="160" height="27" valign="top"><b><font face="Arial, Helvetica, sans-serif"><a href="/holding/UFK/UFK_search.htm">
        </a><a href="/TeamManagers/Warriors/Warriors_search.htm">Warrior s</a></font></b></td>
      <td width="148" height="29" valign="top"><b><font face="Arial, Helvetica, sans-serif"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/SoccerCityFC/SoccerCityFC_search.htm"> ;Soccer
        City FC</a></font></b> </font></b></td>
    </tr>
    <tr>
      <td width="154" valign="top" height="27"> <p><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/QCHawks/QCHawks_search.htm">Q.C.
          Hawks</a></font></b></p></td>
      <td width="160" valign="top" height="27">&nbsp;</td>
      <td width="148" valign="top" height="27"> <p><b><font face="Arial, Helvetica, sans-serif"><a href="/holding/Cougars/Cougars_search.htm">
          </a></font></b></p></td>
    </tr>
    <tr>
      <td width="154" valign="top" height="32"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/OdlumBrownFC/OdlumBrownFC_search.htm"> ;Odlum
        Brown </a></font></b></td>
      <td width="160" valign="top" height="32">&nbsp;</td>
      <td width="148" valign="top" height="32"><b><font face="Arial, Helvetica, sans-serif"><b><font face="Arial, Helvetica, sans-serif"></font></b></font></b> ;</td>
    </tr>
    <tr valign="top">
      <td width="154" height="27"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/WestwardFC/WestwardFC_search.htm">Wes tward
        Utd F.C.</a></font></b></td>
      <td width="160" height="27">&nbsp;</td>
      <td width="148" height="27"><b><font face="Arial, Helvetica, sans-serif"></font></b></td>
    </tr>
  </table>
  <table width="655" border="1" name="teambios" bgcolor="#FFFFFF" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF" height="289" bordercolor="#000000">
    <tr bordercolor="#006600">
      <td bgcolor="#006600" height="29" colspan="2"> <p><b><font face="Arial, Helvetica, sans-serif" color="#FFFFFF">Over
          30's Division A</font></b></p></td>
      <td bgcolor="#006600" width="349" height="29" colspan="2"> <p><b><font face="Arial, Helvetica, sans-serif" color="#FFFFFF">Over
          30's Division B</font></b></p></td>
    </tr>
    <tr>
      <td height="15" colspan="2"><font face="Arial, Helvetica, sans-serif"><img src="/Images/clearpixel.gif" width="1" height="1"></font></td>
      <td width="349" height="15" colspan="2"><font face="Arial, Helvetica, sans-serif"><img src="/Images/clearpixel.gif" width="1" height="1"></font></td>
    </tr>
    <tr>
      <td valign="top" colspan="2" height="31"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/BBear/BBear_search.htm">Villa
        Roma FC</a></font></b></td>
      <td width="349" valign="top" colspan="2" height="31"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/Comrades/Comrades_search.htm">Comrade s</a></font></b></td>
    </tr>
    <tr>
      <td valign="top" colspan="2" height="30"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/JESpurs/JESpurs_search.htm">Maplewood
        Spurs</a></font></b></td>
      <td width="349" valign="top" colspan="2" height="31"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/NS%20Chiefs/NSChiefs_search.htm">NS
        Chiefs </a></font></b></td>
    </tr>
    <tr>
      <td height="29" valign="top" colspan="2"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/NSRangers/NSRangers_search.htm">N.S.
        Rangers</a></font></b></td>
      <td width="349" valign="top" colspan="2" height="30"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/SVikings/SVikings_search.htm">Screami ng
        Vikings </a></font></b></td>
    </tr>
    <tr>
      <td height="29" valign="top" colspan="2"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/RGullStrikers/RGullStrikers_search.htm"& gt;Rusty
        Gull Strikers</a></font></b></td>
      <td width="349" height="29" valign="top" colspan="2"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/Spareboy/Spareboy_search.htm">Sparebo y</a></font></b></td>
    </tr>
    <tr>
      <td colspan="2" valign="top" height="32"> <p><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/Shysters/Shysters_search.htm">Shyster s</a></font></b></p></td>
      <td colspan="2" valign="top" height="32" width="349"> <p><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/Titans/Titans_search.htm">Titans</ a></font></b></p></td>
    </tr>
    <tr>
      <td valign="top" colspan="2" height="30"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/Wanderers/Wanderers_search.htm">Wande rers</a></font></b></td>
      <td width="349" valign="top" colspan="2" height="30"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/VeniceFC/VeniceFC_search.htm">Venice
        F.C.</a></font></b></td>
    </tr>
    <tr valign="top">
      <td height="30" colspan="2">&nbsp;</td>
      <td width="349" height="30" colspan="2">&nbsp;</td>
    </tr>
  </table>
  <h1>Suspended Player Information</h1>
  <table width="650" border="0" height="71">
    <tr>
      <td width="157" height="45">&nbsp;</td>
      <td width="148" height="45">&nbsp;</td>
      <td width="171" height="45">&nbsp;</td>
      <td width="157" height="45">&nbsp;</td>
    </tr>
    <tr>
      <td width="157" height="30">&nbsp;</td>
      <td width="148" height="30">&nbsp;</td>
      <td width="171" height="30">&nbsp;</td>
      <td width="157" height="30">&nbsp;</td>
    </tr>
    <tr>
      <td width="157" height="30">&nbsp;</td>
      <td width="148" height="30">&nbsp;</td>
      <td width="171" height="30">&nbsp;</td>
      <td width="157" height="30">&nbsp;</td>
    </tr>
    <tr>
      <td width="157" height="30">&nbsp;</td>
      <td width="148" height="30">&nbsp;</td>
      <td width="171" height="30">&nbsp;</td>
      <td width="157" height="30">&nbsp;</td>
    </tr>
    <tr>
      <td width="157" height="30">&nbsp;</td>
      <td width="148" height="30">&nbsp;</td>
      <td width="171" height="30">&nbsp;</td>
      <td width="157" height="30">&nbsp;</td>
    </tr>
    <tr>
      <td width="157" height="30">&nbsp;</td>
      <td width="148" height="30">&nbsp;</td>
      <td width="171" height="30">&nbsp;</td>
      <td width="157" height="30">&nbsp;</td>
    </tr>
    <tr>
      <td width="157" height="30">&nbsp;</td>
      <td width="148" height="30">&nbsp;</td>
      <td width="171" height="30">&nbsp;</td>
      <td width="157" height="30">&nbsp;</td>
    </tr>
    <tr>
      <td width="157" height="30">&nbsp;</td>
      <td width="148" height="30">&nbsp;</td>
      <td width="171" height="30">&nbsp;</td>
      <td width="157" height="30">&nbsp;</td>
    </tr>
    <tr>
      <td width="157" height="30">&nbsp;</td>
      <td width="148" height="30">&nbsp;</td>
      <td width="171" height="30">&nbsp;</td>
      <td width="157" height="30">&nbsp;</td>
    </tr>
    <tr>
      <td width="157" height="30">&nbsp;</td>
      <td width="148" height="30">&nbsp;</td>
      <td width="171" height="30">&nbsp;</td>
      <td width="157" height="30">&nbsp;</td>
    </tr>
    <tr>
      <td width="157" height="30">&nbsp;</td>
      <td width="148" height="30">&nbsp;</td>
      <td width="171" height="30">&nbsp;</td>
      <td width="157" height="30">&nbsp;</td>
    </tr>
    <tr>
      <td width="157" height="30">&nbsp;</td>
      <td width="148" height="30">&nbsp;</td>
      <td width="171" height="30">&nbsp;</td>
      <td width="157" height="30">&nbsp;</td>
    </tr>
  </table>
  <p>&nbsp;</p>
</div>
<p><img src="/Images/ateammanag.png" width="235" height="46"><img src="/Images/MILLERS5.gif" width="410" height="53"></p>
<p><img src="/Images/Millersmenu5.gif" width="90" height="25">
<p>
<p><a href="/index.html"><img src="/Images/buttonhome.gif" width="93" height="20" border="0"></a></p>
<p><a href="/newLeagueInfo.html"><img src="/Images/button1.gif" width="93" height="29" border="0"></a></p>
<p><a href="/Schedule/SchedulesMain.asp"><img src="/Images/button2.gif" width="93" height="20" border="0"></a></p>
<p><a href="/newFields.html"><img src="/Images/button5.gif" width="93" height="29" border="0"></a></p>
<p><a href="/newTeamContacts.html"><img src="/Images/button6.gif" width="93" height="29" border="0"></a></p>
<p><a href="/newTeamInfo.html"><img src="/Images/button7.gif" width="93" height="29" border="0"></a></p>
<p><a href="/TeamRosters/newTeamRoster.html"><img src="/Images/teamrosterbtn.png" width="93" height="29" border="0"></a></p>
<p><a href="/newStandings.html"><img src="/Images/button3.gif" width="93" height="20" border="0"></a></p>
<p><a href="/Stats/stats_input.asp"><img src="/Images/playerstatbutton.png" width="93" height="29" border="0"></a></p>
<p><a href="/newTeammangers.html"><img src="/Images/Managerbutton.png" width="93" height="29" border="0"></a></p>
<p><a href="/newAdministrators.html"><img src="/Images/adminbutton.png" width="93" height="29" border="0"></a></p>
<p><a href="/newRefs.html"><img src="/Images/refereebutton.png" width="93" height="29" border="0"></a></p>
<p><a href="/newLinks.html"><img src="/Images/soccerlinks.gif" width="86" height="25" border="0"></a></p>
<p>&nbsp;</p>
<p>&nbsp;</p>
</body>
</html>

Just wanted to say how much I like the program! I hunted for days and finally purchased a Perl based product. After several days of goofing with it I gave up. ASPPhoto worked right on first install!!!!

Way to go!

When did you download the ASPProtect Version 7 zip file ?

what did you enter as a wrong password to make that happen ?

does it it do it when other wrong passwords are entered ?

I am an experienced ASP developer. Can you tell me whether this would be a very involved process, or whether it is pretty straightforward? I don't yet have a merchant account, so I am not yet familiar with any aspect of accepting credit cards online.

Thanks.

I checked with our web hosting company and CDOSYS is installed and properly registered on the Windows 2003 Server our site resides on.

How do I go about changing the ASPProtect code to use CDOSYS?

Please advise.

If things are not perfect there will be no log files and no errors.. it can only be one of these things really
http://support.cjwsoft.com/code/moreinfo313-2.htm

You may also want to make your the filesystem on the server is working and not disabled by norton script blocking or anything random like that. Testing the filesystem object is best done by writing a simple text file to a folder. Plenty of examples of doing that can be found at www.aspin.com

Recent activity is temporary and admin activity in the admin area is not tracked. If your application in IIS has reset or there has been no activity in the users area or in pages you protected there will be nothing there. The busier your site the more chance something will be there. For example usually our online demo has something there except right after 4am when my server does an iisreset.

Okay,  I deleted out the aspprotect folder and started over.  I also took out the dsn connection to the ecommerce database and deleted out the subweb that had it, I decided to use another provided where the database is resident on thier servers not mine.

I broke my txt file into groups and it's loading sort of.  The first 1000 users uploaded fine...the second said it timed out, but when I looked at the access database it showed 2000 people.   The login still times out and every page seems to load incredibly slow still.

Where is the system getting the random user name and password, and why does it keep selecting the same user name and password every time?

Hi, I am glad you like the system.
Thx for the comments..

The banner logic in aspbanner it tweaked for speed and performance.. that sort of thing really wouldn't fit into the current code structure very well. It would slow things down and be a nightmare to code because of the way aspbanner uses ultra fast application variables for the banner rotation. Basically its a feature I didnt incorporate for performance and pricing reasons.

I would suggest making different zones for different conditions.. then surrounding the banner calling code with if else logic so a different baner zone was called under certain conditions.

That way performance would not be effected and you could actually show a different group of banners based on certain conditions.

Sorry, but that is the best advice I can offer at this time.

I built ASPBanner for performance and at this time I refuse to sacrifice that for any feature that will slow it down and consume more resources.

The redirection feature isn't working as I exected.

If I clear a user's redirection_URL, they can navigate to any protected page on my website as expected.

However, if I set the user's redirection_URL to a protected page, they cannot login. More specifically, their browser just keeps displaying the login form while the browser's progress bar just increments ad infinitum.

If I set the user's redirection_URL to a NON-protected page, the user is directed to that non-protected page, but if they then try to navigate to a protected page, they are redirected back to the redirection_URL.

Is this the way the redirection feature is supposed to work?

My application requires that a user is directed to a protected page and from there, they can navigate to any page that they are allowed to go to.

What can I do?

thanks!! the file took care of the extra slash. I also fixed the problem by modifying the permissions.

dazed

Yeah, its working great witht he Access database. Now I just need to get it all set up. I like how the config file is set up with all the comments, it really helped allieviate the 40k thumbnails, .

Hi all

I logged in myself to my website, and I tried to log in to another with same username and password. But I was able to log in again.

It was supposed to block me from logging in, but it let me to log in.

there has got to be some configurations I must have missed.

Could you instruct me on this Concurrrent login so mine works as well...

thanks

Hi Chris

I've just recently purchased ASPBanner and have been testing out serving multiple Tradedoubler code using the IFRAME method. I have four types of banner on the same page refreshing every 15 seconds. (this will change on the live site) 

I've been leaving the IE page up for x hours and coming back to find between 1-3 of the banners has stopped and in place is an "internal error".

BannerZone=3&Refresh=15|40|800a0046|Permission_denied 80

I thought it may have been the SQL permissions from one of your other messages so I gave the banner user the DataReader and DataWriter permissions.

Its still happening and around the same time in the logs theres a couple of file not found errors.

BannerZone=2&Refresh=15|23|800a0035|File_not_found 80 - 80.65.240.159

BannerZone=4&Refresh=15|25|800a0035|File_not_found 80 - 80.65.240.159

BannerZone=1&Refresh=15|25|800a0035|File_not_found 80 - 80.65.240.159

Any ideas? I'm hoping its not the server as there is currently only 2 sites on it and this is pretty much the only traffic.

Thanks

Colin

I know what is happening.. its the old single quote thing messing up the query string..
but it shouldnt be happening with the newer code as I fixed it.

If you like I can go in and reproduce/fix the issue. I can not think of any other way I can help you as other users have not reported the issue.

Chances are if it is happening in one situation it will happen again in the future.. it really all depends on the passwords being used and your encyrption key... other passwords may produce the issue even if the password is correct

basically once the password gets encrypted it by chance has a single quote in it... then it messes up the query

I take care of the situation by replacing the single quote with a double quote but it looks like you found a situation where that didn't work out

Connecting user is dbo of database.

User_ID is primary key with auto increment identity.

SQL Script of current table:
CREATE TABLE [dbo].[Security_Users] (
 [User_ID] [int] IDENTITY (1, 1) NOT NULL ,
 [First_Name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [Last_Name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [Company_Name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [Username] [nvarchar] (75) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [Password] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [Access_Level] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [Notes] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [Admin] [bit] NOT NULL ,
 [Active] [bit] NOT NULL ,
 [Expiration_Date] [smalldatetime] NULL ,
 [Email] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [Address] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [City] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [State_Province] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [Zipcode_Postal_Code] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [Phone] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [Counter] [int] NULL ,
 [Last_Access] [smalldatetime] NULL ,
 [Login_Limit] [int] NULL ,
 [Custom1] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [Custom2] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [Custom3] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [Custom4] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [Custom5] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [Custom6] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [ValidateEmailCode] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [Date_Created] [datetime] NULL ,
 [Validated] [bit] NOT NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Security_Users] WITH NOCHECK ADD
 CONSTRAINT [PK_Security_Users] PRIMARY KEY  CLUSTERED
 (
  [User_ID]
 )  ON [PRIMARY]
GO

You need to make sure you created the SQL database using the SQL scripts we provide and that no errors occur whatsoever. That is extremely important. You must use our SQL creation scripts.

Then, when you create the user you need to go back to that user and make sure you check the admin account and save that user again. (many times when setting up a system for someone I find myself forgetting that step and then I have to go back in and check the admin box for the user I created.)

And of course create the user from the ASPProtect admin area web interface. Do not add the user to the database manually because you will have no way to enter the password correct as it is encrypted. And do not change the encryption key after making the user/.

It would also be wise to check the SQL server database at every step to make sure the user info gets created and that all the field info looks correct for the most part.

You also want to be sure to specify SQL as the database type side the connection string info as the SQL directions go over

a remote sql server should not an issue.

thats really all I can think of right now

The random password is generated during signup and the function that creates it is located on this page of code.

users/register.asp

it looks like this

Function RndStr(Length, UseChrs)
 If IsNull(UseChrs) OR (UseChrs = "") Then UseChrs = "0123456789abcdefghijklmnopqrstuvwxyz!@#$%^&*()_+=-"
 NewStr = ""
 Randomize(CByte(Left(Right(Time(),5),2)))
 For gpIndex = 1 To Length
  NewStr = NewStr & Mid(UseChrs, Int((Len(UseChrs)) * Rnd + 1), 1)
 Next
 RndStr = NewStr
End Function

For example go to this page and hit refresh and watch the password change.

http://www.aspprotect.com/demo2/users/register.asp

Yes, sometimes if you hit refresh quickly over and over you'll get the same password, but not generally. Also that is not something that would happen normally as a user isnt going to sit at that screen and hit refresh over and over.

Anyway... when signing up the new user of course has the option to change that password to something they would like better...

As far as... "selecting the same user name and password every time"

I need more information. That does not make sense for a lot of reasons.

Most importantly because usernames are not generated. The are inputed by the user during signup. They are then checked to ensure they do not already exist before the user is allowed to complete their signup.

So under normal circumstances there can never be duplicate usernames in the system or even users with duplicate emails as that is checked as well.

Now of course if you edited the code in any way it is possible all this is not working correctly ?

What am i supposed to do now... i do have another member server that is not a domain controller-

However, i have like 5 websites running on this domain controller already. I have thought about this before how its a HUGE security risk but it will take too long to configure everything on the other computer :(

I'm trying to use CDOSYS.

It seems to work fine on the web page, however the mail never gets
delivered.

I can see my messages sitting in c:\inetpub\mailroot\pickup but they never leave it.

I found another folder after doing a search for "pickup".... it is:
d:\program files\Exchsrvr\Mailroot\vsi 1\PickUp     If I paste the files
into there, they get delivered.

How can I get the email to be delivered without doing the cut and paste?

I've tried it both with and without authorization.

I am running a Windows 2000 server with Exchange 2000.

Thanks.

humm, I dont know.

If you want me too I would be glad to go into your web site and troubleshoot. If so PM me the info I need and I will take a look and see if I can figure it out.

CJW

Banners no longer show up on my site ?

If banners were working fine and now they are just not showing up.
1st check to see that you are calling a valid zone with live banners in it.
If you are then most likely this it what hapened.

The web server must have crashed or lost power and now the application variables are in limbo/not working.

I have seen this happen a few times.

Basically the application variable system gets messed up because it was not shut down properlly.

The way to cure it are as follows.

Edit and save a banner in the system. Hopefully that gets things going again.

ok.. Chris.. I am now kicking myself in the butt.  In the setting section, I had to redirect certain urls and directories to the right spot.  I forgot that I renamed the root folder. 

Thank you, thus far for your continued help.  It is greatly appreciate.