Home | Advertising Info124 USERS CURRENTLY ONLINE   
PowerASP
   Site Search Contact Us Friday, March 14, 2025  

Active Server Pages what is asp programming how to sample asp example code scripts software asp forum mail sessions applications global.asa CJWSoft ASPProtect ASPBanner ASPClassifieds



Blog Entry: 3/25/2006 1:43:32 PM

http://support.cjwsoft.com/code/moreinfo286-2.htm

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

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

,

no, that only applies to random pictures and stats..

 

The issues you are talking about usually relate to issues created by switching back and forth between a local install and a live server install and not being careful about changing the paths in the settings depending on where you are running it from.

For example.. it trying to use a url at the server level that is only valid when you are running it locally

cwilliams38394.7554976852,



UPDATE

Version 8.1 has code generators for these new methods built in...

, you can whatever you like but like I said those gif files are already in the correct place. The log parser is messing up. ,

Here is what I have in settings.

ServerSoftware Microsoft-IIS/6.0
ServerName www.107threnegades.com
ServerProtocol HTTP/1.1
PathInfo /gallery/gallery_admin
PathTranslated d:\hosting\arisky1\gallery\gallery_admin
FILE SYSTEM OBJECT Installed
ADODB (ActiveX Data Object) Version: 1.2 Installed  
CDONTS Version: 2.80 Installed  
SMTPMail Not Installed  
JMail Not Installed  
AspEmail Not Installed  
AspMail Not Installed  
SAFILEUP Not Installed  
Dundas Upload Not Installed  
ASPImage Not Installed  
AspJpeg Version: 1.4.0.1 Installed  
ImgWriter Not Installed  
Script Engine
Type VBScript
Version 5.6
Build 8515

I do not even see ASPUpload listed but when I run the test_asp_components.asp from the extras/more_component_info folder, it shows that it is installed.

67 Upload
Installed
Persits - ASPUpload
68 Image
Installed
Persits - AspJpeg

 

, It is common when testing a site that this happens because of the nature of session variables.

Admins have access to EVERYTHING so it is very important when testing different user accounts that you specifically log out... and then close every single browser window before logging in as a different user. This is to ensure session info from the previous user does not overlap in any areas.
(The session variable for admin access being the main one)

Under normal circumstances a user would not log in with many different accounts on the same computer this this would only be a problem for a developer who is testing.

So make sure you go to the to log-off page and log off.. then close all browser windows.. then test another user.

If all this is not the case then something else is going on and I will need more information. I pretty much know the level checking code for ASPProtect Version 6 is correct as there has been no reason to change any of it in over a year. I would have heard reports of problems with it. , that is good news... good guess on my part I guess

anyway, try this for your latest issue.

http://support.cjwsoft.com/code/code_info.asp?TID=340&KW =%2D1,

ASPProtect Version 7
Expiry Notices go out to members who have recently renewed by subscription.

When an existing member from ASPProtect Version 6, with an expiry date, renews with SUBSCRIPTION in v7, the previous expiry date remains unchanged.
We assume the expiry date remains blank with NEW Subscriptions and that Paypal takes care of notifications.

 But our notifications to the "about to expire" dating from v6 catches the "Renewed by subscrtiption" as well, as the date has nor been changed or removed, and this REALLY confuses our members.

Can this be resolved?

,

UPDATE:  read whole thread..
Version has been delayed





These are my personal notes on the new version of ASP Photo Gallery that should be out sometime in May/June 2004. Please ingore any typos.

This version may be more expensive than the current pro version as this is a major re-write and there will be a ton of new features.

Regardless, special pricing will be offerered to existing users.

If you see any features not listed that you think would be nice please post them here. We will of course consider them.

 






ASP Photo Gallery Version 4

------------------------------------------------------------ --------------------------------------------

Finished Improvements:

new setup page makes setting up the data connection easier than ever
it attempts to determine the possible data paths and makes suggestions for what to try
when you finally get the data connection working it gives you a link to the admin area of the application
so you can get started using the application

all database table names can be specified in the config_inc.asp file for advanced users that they may need
to change the table names in the database.. helpful for sql installation where one sql database must be
shared by many applications

new data folder is the only folder that needs permissions set
before multiple folders needed permissions
now everything can be put in this folder... database,logfiles,configuration files,picture upload folders...
eventually all cjwsoft applications will do this allowing multiple cjwsoft applications to use that same folder
therefore making it easier than ever to setup more applications without asking your host to set more permissions

new text based config file makes it easier to add new options to the program without making changes to
the database structure... therefore the need for the configuration table in the database has been eliminated
this also reduces system resources needed to load the config data for each page because it eliminates calls to the
database for config data

added voice effects for data connection page, intro users page, and settings page

made it so ratings color was an option (red or blue)

fixed minor bug that wasn't showing fixed category heights when that was selected and am image wasn't originally sized that way during initial upload

changed logfiles dates so they always show up in the proper order 09 vs 9

added config option to change bit query value to 1 or -1
default it to 1.... this is a technical thing

added the extra options currently in the config file to the settings page so people do not have to manually edit that
file any longer...

added new persits email option and authentication options to the settings page

added new CDOSYS emailing option

added support for dundas emailer

added support for ASPSMARTMAIL

fixed word filter so if it is empty it doesn't mess up
also make editing it part of the main settings

made email functions include file and edited all page that email to use it

added css/style sheet support and removed a lot of the old font tags

seperated the settings page into sections because it was too big and confusing

added ability for text watermarking when using the ASPImage component

made the picture upload error message no longer mention browsers that do not support picture uploading
as that is confusing people... and the problem is never that anymore

Made the ASPImage test page delete the bar graph before creating it so if it is already there they will
not think it is working

added crystal ball feature to admin users screen... shows additional user info when you hold the mouse over it

Made search function highlight search word in results.
Made the search function search the image description text files as well

Eliminated the guestbook directory as there was no need for the guestbook to be in it's own directory. This also simplified the menu.asp file as the guestbook section could be removed.

------------------------------------------------------------ --------------------------------------------

Possible Improvements:

eventually make new and much better directions/documentation... html based for multiple reasons

Eliminate the need for parent paths to be enabled on the web server.
(THIS MAY NOT BE POSSIBLE)
Many hosting companies disabled parent paths and will not enable them for their users.
On Windows 2003 Server Parent Paths are disabled by default.

make it so users ability to upload pics can be optionally disabled

possibly make some of the special functions in the extras folder built in to the admin area

Make the category picture uploader smarter because of the jpg gif issue when reuploading cat icons
A jpg loaded over a gif.. doesn't delete the old gif graphic and vice versa

Reduce number of ".asp" pages in general.

Use more functions for redundant tasks.

Optimize all instances of the old filefound function which is using more resources than are necessary

option.explicit the entire application and get all the variables dimmed once and for all

possibly incorporate the new category system I am working on which allows for unlimited categories and levels
also simplifies the heck out of the pages that call the categories

possibly add some cool image manipulation functions such as rotation for the various image components supported

possibly add the ability to move pictures around in an album. and maybe between albums
I must also remember to move the ratings and desc as well for that image.

possibly add the ability to make individual pictures require approval

possibly add the streaming image ability (asp page called from image tag) I came up with as an option for
people that can use it. this will better secure images in password protected albums and also possibly make
it so images can only be viewed from certain urls.. and maybe make an interface for a list of allowed urls

improve the .net support to also resize the larger images.. currently it does not

possibly add a feature to store 3 versions of images uploaded
thumbnail, medium res, and high res/original
this will appeal to professionals or people that may want to sell prints
storing a large version will be optional

possible support for multimedia content other than gif and jpg images

fix... url to link to..   problem on control pics page when both a jpg and a gif are present... which also relates to a another slight
bug that needs to be taken care of

make interface in admin to listen to installed midi files
and also to upload / delete them

possibly make per album guestbook... or call it something else like disussion or comments

add option to store the images orginal name in the images description area during upload
may be helpful to people that name their images in a somewhat descriptive way

change approval settings so they work on a per user basis
eliminate access levels from edit user screen and get rid of the level 4 stuff mentioned
possibly add a per user option for individual pic approval as well if I get that feature implemented

add support for the ibulc bulk upload client that I recently discovered
it is very cool

cwilliams38325.8264583333, [QUOTE=afifm]

I was actually able to do similar thing by allowing our dedicated search engine to access the site unchallanged.

<%
If Trim(Left(Request.ServerVariables("HTTP_USER_AGENT"),11)) = "MYPASSWORD" Then  
 SearchFlag = True
End If
 
If SearchFlag <> True Then
If Session("Access_Level") > CHECKFOR or Session("Access_Level") = "" Then 
%>
<!--#include virtual="/Auth/check_user_Code.asp" -->
<head>
<title>My Title</title>

</head>

<body>

My Protected stuff here

</body>

</html>

For this to work, the search engine must pass the PW to the web site. I just was not sure how to do the same thing with IPs. I will play with the code and see what happens. If it works, I will post it here to help others, if this is OK with forum rules.

Thanks,

Mo

[/QUOTE]

I just added couple of lines and it works fine

If (Request.ServerVariables("REMOTE_ADDR")) = "xxx.xx.xxx.xxx" Then 
 ' Session("PasswordAccess") = "Yes"
 SearchFlag = true
End If

, Thanks, I know, I have it all figured out and have thought about it before. Just no time yet to do it.  It will probably be an add-on/mod when I get time. ,


IMPORTANT UPDATE - READ THIS
http://support.cjwsoft.com/forum/forum_posts.asp?TID=205& ;PN=1


The IPN Subscription Pack which is built in to ASPProtect 7 contains all the pre-built scripts you need to implement PayPal IPN Subscriptions with ASPProtect. IPN stands for (Instant Payment Notification). It allows you to set up scripts on your server so whenever a PayPal payment is processed the PayPal server sends info to your server regarding the transaction and vice versa. This is a fully automated process and allows you to charge users for access by the month or however long you like.

The Subscription feature of PayPal handles recurring billing automatically. The PayPal server will communicate with the ASPProtect system and keep everything up to date with users and their subscriptions.

This Support Pack basically gives you an additional signup and registration directory "paypal_sub_signup" and it should not interfere with any changes or customizations you have made to your ASPProtect setup. New users can register in this directory and sign up for a subscription at the same time. Existing users whether active or expired can be sent to this directory where they can lookup their account and start a subscription. You can also assign various Access and Group Levels during signup and you can set up various prices for various amounts of time as well. This is a real-time setup for the most part. As soon as a user pays via PayPal your system is updated and they will have access.

To use this all you need to do in ASPProtect 7 is enter your PayPal account name into the settings screen. It will be an email address. You'll need a business or premier account with PayPal and you will need log into your PayPal account and turn on IPN in you profile. They make you enter a default IPN URL. We do not use that so if you already have something there leave it there. If you dont have something there you can type in any the full url to any page on your server. It's probably best to send it to an empty ".asp" page or something.

Changing Payment Options

In the "paypal1.asp" file there are some sample payment options set up.

They look like this and you can have as many as you like.

<!-- Begin Payment Option Code -->
<form action="https://www.paypal.com/cgi-bin/webscr" method="post" target="_blank">

<% Label = "Membership (1 Month) $9.99 Recurring" %>
<!-- Begin Form Fields You Can Edit.. See PayPal Subscription Manual For Details -->
<input type="hidden" name="no_shipping" value="1">
<input type="hidden" name="no_note" value="1">
<input type="hidden" name="a3" value="9.99">
<input type="hidden" name="p3" value="1">
<input type="hidden" name="t3" value="M">
<input type="hidden" name="src" value="1">
<input type="hidden" name="sra" value="1">
<!-- Field Below must have 2 commas First two values are optional (access level,groups,user ID)-->
<input type="hidden" name="custom" value=",,<% =User_ID %>">
<!-- End Form Fields You Can Edit.. See PayPal Subscription Manual For Details -->

<!--#INCLUDE FILE="form_data_inc.asp"-->
<input type="image" src="https://www.paypal.com/images/x-click-but20.gif" border="0" name="submit" alt="Make payments with PayPal - it's fast, free and secure!">

</form>
<hr>
<!-- End Payment Option Code -->

 

To really understand what these form values mean it is best to look through the PayPal Subscriptions Manual which is a PDF file you can get from the PayPal Site.

This link was valid the last I checked...
Subscriptions and Recurring Payments Manual

It also may be helpful to use their wizard to create some subscription buttons with different settings and then look at the code generated.


Bascially these are the important ones..

  • a3 - amount to billed each recurrence
  • t3 - time period (D=days, W=weeks, M=months, Y=years)
  • p3 - number of time periods between each recurrence
  • The custom field is something we are using to send info from ASPProtect to PayPal.
    it allows you to set the access_level or groups access (groups support require the ASPProtect Option Pack)

    <input type="hidden" name="custom" value=",,<% =User_ID %>">

    or this example where we are setting the access_level to (2) and also giving the user access to groups (3 and 4)

    <input type="hidden" name="custom" value="
    2,*3*4*,<% =User_ID %>">

    Here is how it works.
    The value setting (red) is essentially and array that can be made up 3 elements separated by comma's

    access_level,groups,User_ID

    If you do not want to set the access_level or groups access.. then you don't even need to edit the setting.

    Values must be separated by a comma even if there is no value and there can be no spaces.  If you didn't want to set an access level or groups there would still be 2 commas at the beginning.  etc etc
    Basically there must always be 2 commas but you only have to set last values which is the User_ID from the ASPProtect system.

    The 1st value is the access level you want to user assigned to.
    The 2nd option is the groups you want the user assigned to. (requires option pack)
    The 3rd option is the User_ID which the system takes care of. Do not edit this option. Leave it as <% =User_ID %>

     

    cwilliams38421.7141782407,

    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?

    , that variable comes from the settings acreen in the admin area. If you do not have it set properly things like what you are describing will happen.,

    That's exactly what it was.

    The site owner couldn't see their own ads because Norton was blocking anything with the word ad in it.

    On another note: I changed the word 'ad' to 'listing' and got it to show even with Norton.

     

    ,

    yes, there is upgrade pricing
    http://www.aspprotect.com/purchase_v7_upgrade_pricing.asp

    and upgrade instructions here in the forums

    if you install it in the same directory structure you wont have to make any changes to the pages in your site you have already protected.. because the code to protect a page will be the same

    now, anytime you upgrade an application like this there is going to be a lot of work involved especially when there have been so many changes
    http://support.cjwsoft.com/code/moreinfo173-1.htm
    whether or not you upgrade is up to you

    Like I said you can make version 6 work with CDOSYS and a remote email server. You just need to do some research on CDOSYS code and spend the time needed to make the code use it. I however am not going to spend time detailing all of that when I created a new version that does it.

    ,

    If I would like a link on my web page that will take someone to the login page (I would also like this page to contain forgot passord? and register)   I am not entirely clear what file to link to to do this.  Would it be check_user_inc.asp?

    Thanks in advance?

     

    cwilliams38456.0972106481,

    Thank you for the response to my question. In the mean time if I can figure any workaround I will post it here.

    ,

    The main users screen... the 1st screen you see when you go to the admin area..  where you email an individual user..

    The settings I am referring to being the various emailing settings on the settings screen, The settings you showed me.

    As for emailing via a remote server over dsl. It may not be working because the ISP's block the port (25) to stop people from running email servers over their dsl.

    Your POP3 works because POP3 uses port 110.

    If you want to send emails from your local server on your dsl you should probably install the SMTP service of IIS if you have not and send emails using that with CDOSYS. Either that or get a commerical DSL account with a static IP that allows for running email servers.

    ,

    Looks great. I can't wait until this will be released. Will there also be an easy way to migrate my current version ?

    Hans

    ,

    New Features added to 7.x

    1. Entire application gone through and updated.
    2. New graphics, new look and feel
    3. Passwords and Cookies are now encrypted using separate keys individual to each customer install.
    4. Groups Feature... powerful way to protect pages based on group access
    5. Ability to upload a picture for each user.
    6. New printable profile user screen.
    7. Supports 13 email components as well as outgoing authentication for a few of the email components
    8. New Lockout option. "However many" try’s to login and you are locked out for a certain amount of time.
    9. PayPal signup routines for both single payments and subscriptions integrated into the application. Everything is handled automatically. Charging for membership couldn't be easier. 
    10. New Newsletter Feature allows you to send newsletters to those subscribed. 
    11. New ability to Email users soon to expire
    12. HTML emailing for people using CDOSYS. This includes an inline html editor so you can send out some really professional looking emails.
    13. Ability to redirect a user anywhere on 1st login
    14. Option to turn off Login Remember Me Feature
    15. Login Form now very easy to edit
    16. All paths for places that need permissions can be easily changed.
    17. Works with Parent Paths Disabled on the web server.
    18. Company Name is now an optional field
    19. Handy javascript popup date selectors
    20. All date functions now internationl date friendly
    21. Password conversion routine to upgrade existing users to the password encryption
    22. Import / Export of user database built in
    23. Protection Code Generators
    24. Notes Feature. Javascript Popup on users screen that allows you to quickly see information without going to their edit screen
    25. Mass email users incuding ability to send them usernames and passwords all at one time.
    26. Option to not allow concurrent logins by the same username
    27. Optional feature to keep track of recent users that have logged in as well as allow you to view the information.
    28. Optional feature to keep track of recent users that have logged in, what pages they accessed, and when, as well as allow you to view the information.
    29. Ability to protect other files types other than just protecting the viewing of the ".asp" pages. We provide working example code showing you how to protect images and file downloads in your protected ".asp" pages. You can protect nearly any type of file from downloading and viewing. (gif, bmp, jpg, zip, exe, pdf, rar, mp3,etc..)
    cwilliams38413.5933680556,

    I am confused.

    Humm, how did ASPBanner 8 come with your purchase of ASPProtect ? That is not something I am aware of or something I do. Please provide more information on how you obtained ASPBanner 8. If I gave yu a copy for some reason please refresh my memory so I can go look up th emails about it. I need to know you have a valid license.

    Now, as for the two not working together and the login screens messing with each other. I am even more confused. Tell me more as I just do not understand what you did ? ASPBanner has it's own user database and login system so there is no reason you should be mixing the two together as far as logins go. The two applications can certainly be in the same web together and not bother each other. ASPBanner can certainly serve banners to any pages you protect with ASPProtect or don't protect, but you certainly should not be protecting any ASPBanner code with ASPProtect code.  ASPBanner already has code in it to do that. If that is the case don't do that. ASPProtect is not meant to protect code that already has a login system. That should just be obvious as far as I am concerned and hopefully you dintn't try to do that.

    (you said you just put the directory in there but there must be more too this than that)

    But again, tell me more. I can't really know everything  ??

    I just dont see how your ASPProtect pages could be effected by ASPBanner unless you really did something wacky like included the ASPBanner "check_user_inc.asp" instead of the one that comes with ASPProtect or overwrote it... etc ect

    If in the same web aspprotect can be wherever and aspbanner needs to be in a folder called "aspbanner". There should be no conflicts under normal use and the two will essentially run seperate of one another.

    ,

    Hello,

    VBScript is the most popular ASP scripting language, and has the most support available. I estimate that less than 5% of the ASP coders out there use anything other than vbscript

    That being said it specifically says on the aspprotect site ASPProtect is only for use in protecting asp using "vbscript" as the language.

    http://www.aspprotect.com/more_info_full_v7.asp

    http://www.aspprotect.com/comparison.asp

    it is something I specified very clearly for this very reason.

    Sorry, but you can not use ASPProtect to protect pages using Language="Javascript". The code is too complex to be mixed with server side Javascript.

    To password protect asp pages written using "Javascript" you really need a an application specifically written in and designed to work with ASP pages written using "Javascript". And then of course that application would not be able to protect ".asp" pages written using "vbscript." (I mean never say never, but it would be a ton of work to get both working and I doubt you will ever see a commercial application that does both)

    as for switching back and forth between vbscript and javascript you really can't except with very simple code. Doing so with anything complex can be extremely problematic because the order of execution sometimes gets all mixed up because of the complexity of the code being used.

    That doesn't mean it can not work....

    You would really want to do something like this.


    do not specify a default language at the top

    surround the aspprotect include file with this

    <SCRIPT Language="vbscript">

    </script>

    surround your javascript code with this

    <SCRIPT Language="JavaScript">

    </script>

    then make sure none the code including the aspprotect include file has any <% or %> tags in it

    that means you have to remove that sort of thing everywhere... that means a lot of work if you used a lot of that sort of thing instead of response.writes to write out html type stuff

    and again... I don't know if you would ever get it all working

    ,

    i've got a client who has handed me a 151 character banner URL, and i see that the database is designed to take 150 characters. i took the obvious step of just increasing the size of that text field in the database, but i still get this error when i try to enter the URL in the proper form field:

    Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

    /banners/aspbanner/save_banner.asp, line 200

    now, line 200 is just this:

    If Banner_Link_URL = "" THEN
     CmdEditBanner.Fields("Banner_Link_URL") = NULL
    Else
     CmdEditBanner.Fields("Banner_Link_URL") = Banner_Link_URL
    End If

    which tells me that something is blocking the assignment of that long value to that field, even though i believed i had extended the length of that field in the source database.

    where else might i look?

     

    ,


    Access to some sections of the forums must be requested.
    Please Click on the following link and read all of it carefully.

    http://support.cjwsoft.com/

     

     

    cwilliams38291.6121296296,

    ok, then I need more information.

    Was the code changed ? Thats the big one. If it worked and now it doesn't something must have changed. Things just don't stop working on their own. I would try putting the original files back in there for everything but the config and dataconn files just to make sure and see and if it works with the original files. (back up your old ones 1st so you can copy them back of course)

    Also, perhaps PM me the site info so I can go look as well.

    ,

    Christopher,

    Thanks for the reply. I think I've found my problem, but can't test until later in the evening as it is on a live site.

    Darrell

    , Come on the threats are not necessary- i got the point the first time you said it.. i thought i made a friend thru this and felt comfortable to say something like that... i am not a big online chatter just do the web stuff as a hobby... i am a network / computer hardware guy (yet i work for a mortgage co. go figure...),

    You not getting a blank page.. you getting an error. You just can't see it because it appears you edited the page background to black.

    error '80040211'

    /aspprotect/scripts/emailing_subs_inc.asp, line 174

    , My guess it they are runnign some sort of ad blocking software like norton ad blocking. Something on the client side blocking ads or anything with the word ad in it.

    I would investigate that.,

    I have a need for more than the current number of custom fields currently available in the registration form.  Is there a documented method of adding additional fields or am I not able to do so?

    Thanks,

    Dave

    ,

    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.

    , One of my users is looking to do mass updates (multiple records). He wants to be able to update the "Expiration Date" for a group of users who work for the same company. , Even if I try to upload the test file that was included with the system I still get the same error.

    My host is using Windows 2003 Server.

    Will send you a private email to see if the issues can be sorted out.

    Thanks
    ,

    Humm, I can see all those pages loading just fine at both domains so you got me pretty confused at this point as you just said they didnt load.

    regardless, the data connection tests are failing with both of them.

    so let me ask you again how are you setting permissions on the database folders?

    ,

    It's probably something I could do for you as a custom project if you are interesting in paying to have that work done, but it is probably not something that will be added to this version of aspbanner as it is in my opinion a feature more suited for a more expensive software package.

    It is also difficult to get ASP code to do things on it's own. Scheduling something to run on the server or some other clever scenario is necessary and that usually means it would be unique to each persons setup.

    http://www.cjwsoft.com/custom_work.asp

     

    ,

    (User Search & Contact Mod) for ASPProtect Version 7.x

    This will allow an individual user to search for other users as well as email or call them.

    Notes: This is a down and dirty mod. The users page from the admin area was used as a starting point. I then edited it up real quick to be used as a user search. The way it is it shows the user email as a regular email link. If you want to set it up so emailing is done from the application and emails are not actually shown you will have to do some extra work. If you don't want phone numbers shown you will have to remove that column which is not very difficult.

    Directions:
    Back up your existing ASPProtect installation.

    copy "search.asp" into your "users" folder

    2006-03-10_143253_User_Search_Contact_Mod.zip

    Direct your users there. They will have to be logged in to view the page.

    WARNING: This has not been extensively tested for SQL Injection attacks.
    I think it is perfectly fine the way it is by looking it over quickly, but use it at your own risk.

    ,

    Version 7 uses.. RC4

    The upgrade process is described here in detail including a procedure to convert existing clear text passwords to the encrypted versions. (Your passwords will need to be clear text as the system shipped of course for the conversion to do its thing)

    http://support.cjwsoft.com/code/info24.htm

    It is also covered in the downloadbale docs
    http://support.cjwsoft.com/code/moreinfo221-1.htm

    Many people have done the upgrade without any issues and Version 7 is getting great feedback.

    Should you decide to go with it there is upgrade pricing.
    http://www.aspprotect.com/purchase_v7_upgrade_pricing.asp

    , I have been using the AspHttp Component method for displaying my ads along with the google adsense code.  However, in the last few days my site was taking too long to load, so I replaced the AspHttp component, with Javascript method.  The site was back to speed.  But now, the Google Adsense banners do not show up.  Is there a solution for that?  Can the Javascript show Adsense banners also?  Because they do show the Flash banners.,

    I need to use SQL for other reasons than efficiency.  If I create 2-seperate databases, would there be a lot of code to edit?

    Thank you.
    Lance

    ,


    Timecard Entry: 3/25/2006 1:43:33 PM

    customer service training at JCC, printed timecards-emailed the slackers, Took general tech calls, Checked voice mail, watched Radlog - and checked Gisco Issues, Answered billing related questions., quality checked sign ups, cancellation, reports, taking sign ups, answering phone, callbacks from voicemail, checked emials. invoice cancellations, , Talked to Beth about Stat communications pager browser interface off premierpaging.com, Called back some of the bp errors, go over fire suppression system disables and enables with saunders guy, 0100 numbers down, travel home to work from home PC, went over changes with Bob Nelson for web site- need to sit down with jason , Reviewed/edited home pages for ODMLS, and Cat. Co. and reviewed status of current customers with Peggy , tech support, Gary and Robbie, email and connection problems, Talked to Chris Williams about Realtor.com stuff and changes needed for NNYmls.com, CHR, Online Supervisor meeting off site. , not busy at all. cowboys went down. had a couple disconnection problems, Picking up the routers from Creg for Seth and dropping them off, Imcnet E-Mail Problems (imcnet mail down), many invoices, lots of billing issues today i.e. signups, cancels, account changes, new user call backs, phone, Gen issues with Tim, emerald billing questions and talked with Jackie on some accts, TaskForce UML Diagramming (DO NOT BILL), noticed the outside door handle was broken. Brought it to the attention of Randy, mostly tech calls and radlogs.. , Clayton - Watertown, Read a little in my 2000 Professional book.... took a few more calls, surfed the web to see if I could get any information on Windows 2000 Training. , w/interruptions, worked on trying to fix radius server in vermont. back up and running,

       Active Server Pages Rule The World
    Contact Us  
    All artwork, design & content contained in this site are Copyright © 1998 - 2025 PowerASP.com and Christopher J. Williams
    Banner ads ,other site logos, etc are copyright of their respective companies.
    STATS Unless otherwise noted - All Rights Reserved.

    PowerASP active server pages asp.net microsoft .net framework sdk learn asp what is asp tutorial learn asp.net CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspclassifieds.com, www.powerasp.com,www.cjwsoft.com,www.aspphotogallery.com,www.codewanker.com,www.aspprotect.com,www.aspbanner.com