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.

The login page sends the user to redirect.asp (which is as follows)

<%@ LANGUAGE="VBSCRIPT" %>
<!--#INCLUDE FILE="check_user_inc.asp"-->
 
<%
If InStr(Session("Groups"),"*1*") Then
    Response.Redirect("gp01.asp")
End If
%>

<%
If InStr(Session("Groups"),"*2*") Then
    Response.Redirect("gp02.asp")
End If
%>

I am not being redirected to gp02.asp if I am a member of group2.  Also, we wish users who are part of group 2 and 3 to go to a different page (ie. gp2-3.asp)

Thanks in advance.

Please be aware folks..

This file is not provided by CJWSoft. Though this may work very well use of it is not supported in any way. We have not tested it.

This user is not using the option pack so this file will not be compatible with anyone using that because it does not have support for groups and some of the other new features.

Regardless..we appretiate users sharing ideas and solutions that they have come up with.

If the physical path isnt right and the permissions are not right it just plain will not work. You will not get an error.

If the filesystem object is disabled on the webserver it will not work either.
Something has to be wrong.

Please start a new thread when the topic changes.. thanks

It helps to keep the forums organized for other users in the future.

Chris,

2Checkout.com has added to their required cart parameters:

https://www.2checkout.com/documentation/newparameters.html

Do you have a version of 2checkout2.asp that will support these?

Thanks,

Nick

Hello,

Thank you for the feedback.

I would like to point out the requirements of the application however as this is something I am aware of and do address.

http://support.cjwsoft.com/code/moreinfo165-1.htm

These requirments are directly linked to from the ASPProtect v7 web page, so its not like I dont try to tell people the deal regarding SQL server.

Basically I only have the resources to provide scipts and instructions for using SQL Enterprise Manager and that is all I officially support. I also personally think anyone using a SQL Server should be using SQL Enterprise Manager because later on down the road there are things you may want to do such as backups/etc etc

Take Care,

Chris Williams
www.CJWSoft.com

Hey, I run a business and I will not have things like that mentioned in these forums.

hello,

There is no built in option. You would have to add code to do that.
Its not difficult but custimization like that is not something I support.

UPDATE..

Installed a new rack mount 1u server this week.

3.2 ghz hyperthreading 1 mb l2 cache prescott cpu
2 gb pf pc3200 kingston memory
SATA Raid.. (2) 120 gb drives running hardware raid 1

It is a supermicro 1u server case and server motherboard.
The hard drives are SATA 150 120 gb 7200 rpm Diamondmax Maxtors

All high end server type stuff... It's a very powerful server and has been running great all week. 500+ hours uptime so far.

Running Windows 2003 Server Enterprise
SQL 2000 Enterprise SP3
SmarterMail
SmarterStats
Windows DNS
ZipEnable (which I am reviewing for them)
ServerMask (which I am reviewing for them)
A ton of ASP Components which I have purchased over the years.

So that means I can now focus my attention on creating software again instead of being a system admin. (Due to these server issues over the past few months I am now back to godly status as far as windows system administration goes.. not to mention I am now back up to speed on the latest processors and hardware)

So, getting back to ASP Photo Gallery...

I spent about 20 more hours this week on the new version of ASP Photo Gallery Pro.. I have another 40 or more to put into it as I have a lot I want to do.

I think it will be ready within the next three weeks. I know a lot of you have been waiting for something.

I just told you a lot of different things to try... and I doubt you have tried them in the time since I mentioned them

The problem was in config_inc.asp. we had renamed the field in the DB but didn't change it in this file.

But we changed it, it is back to normal.

Thanks

as far as sql goes if you follow the instructions with give for setting up a new database you shouldnt have any issues and permissions should be already set. because we handle that in the sql script we give you.. "its a good thing to look at and it is pretty easy to understand what is going on""

however using another account could cause permissions issues.."yes, even sa"     basically the username your using needs datareader and datawriter permissions to all tables used by the photo gallery system and you probably have to go specifically set them usin ght e security tab for your database in enterprise manager. This is more of SQL server 101 than anything to do with the Photo Gallery Code so I am not going to get into it too deeply, but that is definetly the issue.  Permissions...

here is a thread that may help you if this is what you were getting at

http://support.cjwsoft.com/code/moreinfo389-1.htm

Hello,

I dont know exactly how you go about that and it would really depend on a lot of things like when the ad started and how yu wanted t handle that. it would involve custom coding though, not a change in the database.

Is it actually possible, with your product, to password-protect the folder that has the actual database without having to require customers browsing the listings to enter a password, or will password-protecting the database folder prevent customers from browsing the classifeds listings?

My hosting company uses ASPEMAIL - and I am trying to setup the mailing settings on ASPPROTECT - but cant seem to get it to work.   I've tried many different options - here are two that are the closest - but have issues:

1. If I use the settings:

email component: aspemail

Mail remote server: my internal server name

*no smtp authentication

email mail notification - my email address on my internal server

***I get the following results:

       I can get get notified when a new user logs in, email a user from aspprotect user screen if they are in my company and have a valid email -- but I can not send to the outside world - I get an relay prohibited error.

2. If i try to change the setting to use the Hosting Website email server - I get the following results:  I dont get notified when a new user registers, I cant send to internal company people - but I can send to the outside world.

**any suggestions on what to do? I'm trying to work with the people who manage the mail servers - but since I dont know anything about them - its a bit difficult.

[/QUOTE]

The relay error is because when you send emails outside your email domain smtp authentication is required.

I suggest trying to use CDOSYS with the smtp authentication option. CDOSYS is on all servers by default and is really the way to go. Use a real email account and password to send the emails through the server.  Be sure to check smtp authentication for cdosys and to specify all that info for your email account and password in the settings screen.

If you want to know about CDOSYS read my article.
http://www.powerasp.com/content/new/sending_email_cdosys.asp

thx, thats a known error I forgot about.

I just updated the zip archive so the error is gone but if you bought ASPBanner Unlimited Version 7.3 Before April/06/2004 you can optionally apply the fix.


To fix it (only if you want to use the option explicit method of calling banners and not even a really necessary fix as this is just an error in the generated code your supposed to use)

Just edit aspbanner/zones.asp with a text editor.

Where you see the double dim carefully remove one of the "dim" s and save the file.

its part of how the skins load.. regardless you got bigger problems here..

I am beginning to wonder if you unzipped the download correctly because I see things in folders they should not be in...

you should have ended up with a bunch of folders and files...

It you just ended up with a ton of files in one directory you did not unzip the zip file correctly... if so check your zip program settings.. I mean that error is because it is looking for a file in the skins folder that isn't there and it should be there

better yet, unzip the downloaded zip file using windows xp built in unzipping features which will do it correctly...

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

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>

I think you may be using old code where that was an issue... I am going to PM you the latest version..

to be safe upgrade all the ASP files except the dataconn_inc.asp files and your config_inc.asp files

"be real careful not to lose your current encryption keys in the "config_inc.asp" file or you will be in real trouble

You can use your existing database

Yes, you are right.

We have now tested it using the DSN less connection with Access 2002 and it works fine. We have also tested it again with a DSN using 2002 and this also seems to work.

The comment about speed is a consideration although I have not noticed any differences. ( we only have a few database entries at this time).

Thanks for your help

Can I have the logon be in a top frame while having the protected pages displayed in a main frame?

Using frames with forms based authentication is not the best thing to be doing. Your much better off not using frames and using includes files to do a virtual frames sort of thing (search google) but if you are going to use frames I would suggest password protecting the frameset page as well as any pages it contains.

If you want to have a login form in a non protected top frame all the time.. that posts to a lower frame that is password protected.. you would do this
http://support.cjwsoft.com/code/moreinfo169-1.htm
but change the target of the form to one of your frames

personally though I think that would be a somewhat goofy setup to have going on


Also, how will it behave if a user moves in between a protected page to a public page and back to the protected page again?

As long as they have cookies enabled which is required for session variables to work... then you will have no issues because once they come back to a page they have permission to they will just be allowed in without login.. at least while that session is still active.. or for a longer time if they choose the remeber me option which keeps track of them with a cookie .

Really, the best thing to do is expirment and see how things behave.

Right,  I've done that.  My concern is that it will time out again while I'm trying to import the file.

The import/export manager does not show up under the users tab when I log in normally.  I have to pull up the page in frontpage and then preview it a browser to get it to show.

All of the fields with the expected paths show the correct file structure, so now I've put them in them in the boxes

it might also be a good idea for you to try a simple text file writing example like this on your server and see if it hangs as well

http://www.devasp.com/samples/writetofile.asp

for troubleshooting sake

this is sounding more and more like the filesystem object is blocked or disabled on your server

Thanks for your rapid responses, your support is excellent!

It may be best that I stick with html then. You mention that is stresses the Version 7 software, would the unlimited version perform any differently if I use multiple zones?

Also, if I do go with a single zone, would either program be able to make sure each banner is unique, or would there by duplicates for each page view?

Sorry to post so many questions in one day.

We can't seem to find the purchase emails for this install of ASPProtect.

It would have been in May 2004 for NetOptions LLC or CareerMatrix.com

We noticed it should have been v6 of ASPProtect.

Can you resend the download links?