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

Active Server Pages asp search engine active server page asp application components tutorial CJWSoft ASPProtect ASPBanner ASPClassifieds



Blog Entry: 3/25/2006 1:37:41 PM

[QUOTE=spider]At the bottom of my "users" list page, it asks the question "number of users displayed per page"?  After hitting a larger number than the default of 1-25, it increases the number of users per page to that number.  But as soon as I leave that page, it goes back to the default.  Any thoughts?[/QUOTE]

That is how it is supposed to work. It is not supposed to remember that info after you leave. If you want it to always start at some default number simply copy the URL info after picking a number. You'll see the querystrings that tell the page what to do in the address field of your browser. Take that entire URL and  edit the button in the admin area to link to that. The links for the buttons are in the "header_inc.asp" file and you should edit that file with a text editor.

That's the easy non technical way to set a default on the users page and that applies to anything including doing a sort or whatever.

example...

you might change this

<a href="default.asp"><img src="../images/users.gif" border="0" alt="Users"></a>

to something like this

<a href="http://www.yoursite.com /aspprotect/password_admin/default.asp?SORTBY=Email+DESC& ;MyPageSize=500="><img src="../images/users.gif" border="0" alt="Users"></a>

,

I have activated both activity and log files. The directories exist on my server and don't give any errors.

When I check the activity tab, some times there are a number of items in it.  Other times, there is only my login info.  From what I can see, it is supposed to show the last 50 items of activity at all times.  Am I missing something?

Also, when I click on the log file tab, there is no file or information to see.  Is there something I need to do beyond activating it in the settings area and making sure the directory has write permissions?

Thanks.

,



Now, back in the dark ages we had to use the command prompt to setup the MySQL database and all that fun stuff. I am not going to show you that method.

What happened was 100 different  3rd party companies developed interfaces to work with the MySQL server visually. Within the past year MySQL actually released its own little GUI for doing just that so I am going to show you how to do things using that.

Let's download and install it.

Go here
http://www.mysql.com/products/tools/

and download Windows (x86) MySQL Administrator
(1.1 is the most current version at the time of this article)

Installing that is a no-brainer as well. Just stick to the defaults and it will do its thing.

Now that it is finished.. run MySQL Administrator from your start menu.



It will ask for your "root" password that we entered when we set up the server.

Hit OK



You should see this if your MySQL server is runnign and you entered the correct password.

Now select the Catalogs Icon on the right.. go down to the Schemata section.. right click in the lower white area and choose Create New Schema



It will look like this



Essentially this is your database name. I am going to call my database "aspbanner"

Hit ok

Your now have a new database with nothing in it. We now need to run the MySQL database creation scripts that I provide which will create the Tables and Fields needed.

The easiest way when using the MySQL Administrator is to select the Restore icon on the left.



The choose "Open Backup File" in the lower right corner.. Browse to the "aspbanner_mysql.sql" file we provide. You can also download that file here. 2006-03-14_164927_MySQL_Script.zip

Once you select that file choose open...



Now, it is very important you choose the database you created earlier. Also known as Target Schema.. in this case I choose "aspbanner"

Now hit "Start Restore"



Ok, now the database has Tables and Fields

Click on the Catalogs Icon on the left and then select aspbanner from the schemata area in the lower left



You'll see we now have tables in the aspbanner database,

Is there a way to know if it is a SQL server with IIS5? My database type is MSACCESS.

Thanks!
Rhona (rookie)

, I believe that solved the problem as I have not heard from this person since I sent him the code.,

Redirecting is not something ASPProtect does because you can
do that sort of thing using simple ASP redirects.


In all of these examples you are going to want to protect the pages you send these users to accordingly.
So that if they know the url they just cant go their directly without loging in.

 


Redirecting example..
This page will redirect admins or level 4 users to a certain page  and anyone else to
another page.
 
 
<%@ LANGUAGE="VBSCRIPT" %>
<!--#INCLUDE FILE="check_user_inc.asp"-->
 
<%
If Session("Admin") = "True" or Session("Access_Level") = "4"  Then
    Response.Redirect("sompage.asp")
Else
    Response.Redirect("someotherpage.asp")
End If
%>

 

 

Redirecting example..
This page will redirect level 1 users to a certain page. level 2 users to certain page, and anyone else to
another page.
 
 
<%@ LANGUAGE="VBSCRIPT" %>
<!--#INCLUDE FILE="check_user_inc.asp"-->
 
<%
If Session("Access_Level") = "1"  Then
    Response.Redirect("level1.asp")
ElseIf Session("Access_Level") = "2" Then
    Response.Redirect("level2.asp")
Else
    Response.Redirect("allothers.asp")
End If
%>

 

 

Redirecting example..
This page will redirect user "PistolPete" to a certain page.

 
<%@ LANGUAGE="VBSCRIPT" %>
<!--#INCLUDE FILE="check_user_inc.asp"-->
 
<%
If Session("Username") = "PistolPete" Then
    Response.Redirect("somedirectory/somepage.asp")
End If
%>


 
then just make sure the page you send the user to to also checks to see if the user is the right user.... to make sure others users can't access each others pages
 
<%
If Session("Username") <> "PistolPete" Then
    Response.Write("You do not have access to this page.")
    Response.End
End If
%>

 

 

etc etc etc.... these code snippets should point you in the right direction...

,

Why all the pages at the directory .../password_admin/ are very slow to open online?

vaghelis38300.5280208333,

Ok i am having an issue with my other comp. I have spent ANOTHER 3 hours researching this one.... it WONT START THE IIS SERVICE!!!

I get this error:

The service did not respond to the start or control request in a timely fashion

ANYWAY---

I decided to use one of my client's hosts; which happens to be Network Solutions.

ANYWAY again-

I uploaded the whole thing there and they advised me they cannot do the explicit permissions on that _database folder. This is what they said: I would also would like to point out that ASP.NET applications and permissions do not extend to any other folder, other than the root, (/htdocs/), and the bin, (/htdocs/bin/) folders.  Sub-directories and folder after bin and htdocs will not have ASP.NET permission (read or write).

 

If you could move or reconfigure your application to save all your code behind, include and dll files onto the root or bin folder, your application could work or possibly run as you would expect.  Please have this done and retest your application. If and when you get a different problem or another error after doing so, please let us know, and we shall be happy to help you troubleshoot any problems that you may have.

 

There is a 'create database option'  where i can create a database..create a dsnname, user name, password and have to specify the database file name. Once i do this i need to place the database file (aspprotectnet2002.mdb) in the /db folder within the root. I also tried this and made the appropriate change in the web.config but it STILL DOES NOT WORK. I AM PULLING MY HAIROUT WHY WONT ANYTHING WORK.

 

ALL THE FILES ON ON THE ROOT OF THE WEB HOST. I PULLED THE FILES OUT OF THE _DATABASE FOLDER AND DUMPED THEM ON THE ROOT. I CHANGED THAT ON THE WEB.CONFIG BUT ITS STILL LOOKING FOR SOME .XML FILE IN THAT _DATABASE FOLDER.

 

I'VE BEEN TRYING EVERYTHING AND IT SEEMS THAT I CANT USE THIS SOFTWARE FOR THE LIFE OF ME

, I swapped a few emails with CJW regarding support for ASPMail.  This application works with this software.  I host my site with a private hosting company named 'Intermedia.net' and this is what I had to do to make this application work.

    1 - Change email settings to 'SASMTPMail' installed
    2 - Find all instances of the following code:
   
                If ASPMail_Installed = true then
                  &nbs p; Set Mailer = Server.CreateObject("SMTPsvg.Mailer")
                Else
                  &nbs p; Set Mailer = Server.CreateObject("SoftArtisans.SMTPMail")
                End If
    Change this code to simply:
                Set Mailer = Server.CreateObject("SMTPsvg.Mailer")

    3 - that was about it.  The files that I needed to change are:
       /users/email_password.asp
       /users/add_new_account.asp
       /gallery_admin/approve_album.asp
       /email_friend.asp

I believe that's all i needed to change.  Any questions I'd be happy to try to help out.  [CJW -- for some reason i needed a restart on the server, it's all good now http://www.iphotosite.com/galleryapp/default.asp.  I'll be putting in a redirect for that location/domain later today.

Kurt Tietjen
,

ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Microsoft.Data.Odbc.OdbcException: ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[OdbcException: ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.]
   Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode) +27
    Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandB ehavior behavior, String method) +838
   Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery() +80
   aspprotectnet.aspprotectlogin.Login_Click(Object sender, EventArgs e) +2284
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
    System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEven tHandler.RaisePostBackEvent(String  eventArgument) +57
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
   System.Web.UI.Page.ProcessRequestMain() +1292


Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300

 

 

I am getting this error message when trying to log in as admin or registering a new user. I am using Windows Server 2003 and it is a DOMAIN CONTROLLER.

I have read that there is NO ASPNET account for a domain controller. In its place is the IIS_WPG account. I have given this account and the IUSR account FULL CONTROL.

STILL GETTING AN ERROR. ANY SUGGESTIONS???

, ok, that does not work but that still is not enough to help me troubleshoot.


I'll probably need to look around in your admin area and check things out in order to figure anything out.

I will also need to see the protection code you put on that page exactly as it appears.

PM (private message) the admin usersname/password to me if that is ok with you and I will check it out

it's really the only way I can help with an issue like this. I have to make sure you didn't do something wrong and then go from there , Yes, that worked... ,

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?

,

any asp code that accesses an access database, writes to text files, or allows for picture uploading will need permissions set on certain directories

every application out there is going to need permissions set at some point

its just a fact.. and if your hosting company does not give you a way to manage permissions or have it done when you ask they do not know what they are doing and they are not supporting your asp hosting needs

see my article for more info on the whole process
http://support.cjwsoft.com/code/moreinfo136-1.htm
the part newar the bottom talks about hosting companies

,

What about browser caching ? It can happen easily especially if you update pictures over one another.

emtpy out the temp files of ie (take a while usually).. close all ie windows and go back..

Otherwise I need detailed info on the problem. What you told me is not enough to troubleshoot. There are so many factors like what image  image rezie component you are using, the size of the pictures before conversion, server resources, what your doing regarding 3 albums.... etc etc

I have imported 100 pics at a time into an album on a fast server with no issues. Thats using any of the image resizing components.

If an album is new what your describing should never happen. Again, it think what your seeing is browser caching playing tricks on you. We have anticaching things in place so thumbnails never do that but not for the large images.

cwilliams38235.5737615741,

Not a problem.  Have a good time at your wedding.

 

thanks!

,

Chris:

The string is being saved and I get a .wav ring sound to confirm.  I have tried editing in "notepad" and then running the "data/show_path_info.asp" file after with the same results.

Ken

 

 

,

Hello,

Yes, that is how it works. Unless you make modifications to the code there is no way to easily do what you are talking about.

If you design the site to be intelligent that scenario should never happen.

For example.. you should only be offering links to pages that the current logged in user has access to. You do this by checking the session variables and with simple if-else logic around your html links.

It requires some work but if you dont give them links to pages they dont have access to what you are talking about will not happen.

Here are some simple examples.

Here is an example using access levels.

<%
If Session("Access_Level") = "1"  Then
' show links to pages that allow access level 1
End If
%>

And one for groups..

<%
If Instr(Session("Groups"),"*6*") or Instr(Session("Groups"),"*7*") Then
' show links to pages that allow groups 6 and 7
End If
%>

cwilliams38354.0786921296, They send an email?

Hope my spam killer didn't zap it...
,

Hi there,

Well, that is why we added the PayPal subscription pack where all of that is taken care of and customers get put under a recurring billing cycle.
The more people you get to pay that way the less you have to do.

We also have routines for the two other supported payment methods so people can look up their account and add time to it whether it is active/expired or not.

Other than that, yes it is something you need to sort out on your own based on how you want to run your system. You have the source code and the sky is the limit on how you want handle all of that.  You send out an email to users about to expire. Whether they come back to the site/look up their account and add more time to it is up to them. I really just do not see any way ASPProtect could handle that whole process automatically.

As for batch changing to users in the database. We give you the source code and we also use an open database structure. You can run any query you want on the database whether with ASP code or directly in your database using the tools that come with it, You can write any code you like to do whatever you like to the database. You can even tie other systems and code into the database via OBDC and manipulate data. The sky is the limit like I said. I also don't really see how batch changes to the database relates to individual users paying again for access or not especially since we include payment  pages were a users can look up their accounts and pay for and add more time to it automatically ? At least not regarding the payment routine we provide support for.

ASPProtect can not handle everything every person would need to do. It is meant as a solid starting point for any project, but there are going to be times when more functionality will need to be added by the customer based on their specific needs.

, do you want my help making the database with your import file ?,

The Read-only attribute i was referring to is at the windows explorer level when looking at the folder properties under the general tab. 

ASPNET and IUSR have full access to the _database folder as you suggested - Yet still I get the permission error noted above.

, Have tried doing that but same error... ,

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.

,

If you are developing using Windows XP Pro and running the NTFS file system setting proper permissions on a folder in your website requires that you 1st disable simple file sharing.

To do so open up "my computer". At the top open up "tools/folder options"

Then the "view" tab.

Then at the bottom uncheck "use simple file sharing"


After that that is done... using "my computer" browse to the folder in your web that you need to set permissions on.

Right click on that folder and then choose the "security" tab.
(If simple file sharing is on that tab wont be there)

Give the "Internet Guest Account" Modify Permissions
This will check all the boxes under modify as well.

You can also give permissions to the everyone account and accomplish the same thing.



BTW:
If you are using ASP.NET you need to give permissions to an account called ASPNET. It wont show up in the user list. You'll need to click "add" and then type in "ASPNET"




cwilliams38203.582337963, Ok, have contacted the web hosts. Thank you for your help so far

Regards

Andy
, Oh snap. Tried the blank database and got the same errors. Fixed THE FILE PATHS to conform to the AspProtect 7 setup, and it worked like a champ. I still need to copy and paste the info, but it's working just fine with the ones I add manually.

Moral of the story: FOLLOW INSTRUCTIONS TO THE LETTER.
,

expiration dates are not used in aspprotect's database when signing someone up using PayPal subscriptions because the PayPal system keeps track of all of that and will automatically send posts to the approtect system if a user needs to be deactivated for not paying or for whatever reason.

As you will notice in that thread about subscriptions the paypal signup data you use for the person determines their membership pricing and details..
http://support.cjwsoft.com/forum/forum_posts.asp?TID=186& ;PN=1

Basically the system takes care of everything.
PayPal takes care of everything.

However you want to look at it.

 

 

cwilliams38446.6609953704, "do you know a way around the BinaryRead problem with ASPProtect?"

Let me rephrase:

Do you know a way in which ASPProtect can be modified to get around the BinaryRead problem?

Thanks,
Michelle
,

I do not have any programming knowledge and have what might be a simple question.

I am having a hard time getting my hosting company to modify the rights on the data folder. They state they support ASP and access databases however this is the response I got when I requested the modify permissions set for the internet guest account:

Were the rights changed on the data folder?  No, we do not manage rights to folders.

My question to you is: Doesn't supporting asp require those permissions be set on the database folder or can asp (not just aspprotect) work without those rights modified?

Thanks

,

I did a google search and it turns out that error very well might have to do with ASP trying to send an email and that process failing.

That tells me your emailing from the application is not working so it is probably not something you edited incorrectly.

see this article...

80040211
http://www.aspfaq.com/show.asp?id=2026

Emailing was working as when I did your installation (I think I did it months ago, didn't I) so it must be some incorrect changes to your email settings in the admin settings screen. Try sending an individual email to a user from the admin users screen and see if it works. My guess is you will get the same error and means your email sending options are no longer correct or valid.

If that is the case I would ask you if you changed them or possibly something changed as far as your email setup goes. Passwords ? EMail Server .. etc etc etc

, download the free version...

check out this tutorial...
http://support.cjwsoft.com/code/moreinfo169-1.htm

If your application can post to the page and provide all the form variables needed to log in it may work out for you..

You'll have to try it out... all the form variables needed are in that login form example.

Basically you'd be posting to a protected (.asp) page..
and providing the following for the most part.. how your app creates it post data is on your end...

<input type="hidden" name="Status" value="Checkem">
<input type="text" name="Username" value="Yourusername">
<input type="Password" name="Password" value="YourPassword">



As an alternate scenario...

Now, by default the "check_user_inc.asp" file is looking for posted form data... for security reasons it is not looking for querystring info..

If you change this bit of code in that file

from

Username = Replace(Request.Form("Username"),"'","''")
Password = Request.Form("Password")

to

Username = Replace(Request("Username"),"'","''")
Password = Request("Password")


It will then grab either form or querystring data...

Meaning you wouldn't necessary have to create a true post to the page with form data. You could just access the page via a querysting like so

http://www.mysite.com/somepage.asp?Status=Checkem&Userna me=Yourusername&Password=Yourpassword

Of course that introduces security risks as the username and password would be passed in plain text over the net


Another option is...
You can also make a copy of the "check_user_inc.asp" page called whatever with those modifications just to use in pages you need your little application to post to... thus reducing the security concerns a a bit as the rest of yoru site could still have its pages protected under the normal scenario.

I hope this answers your question... I havent really ever tried any of this but that is how I think it would work... ,

How can I make so it goes to certain webpages if user enters valid username and password??

I suppose user enters its information on check_user_inc.asp page, and username and password are stored on SQL database.

Thanks

 

, Glad your getting the hang of it.

no difference as far as that goes. It is just different ways to reference the server side include file and it's location on the server cwilliams38457.6019675926,

Gotcha.

Can you set an expiration date on a subscription?

Thanks,

Jess

,

do you have the smtp part of iis installed on your machine

cdonts needs that

then again I am not sure you can even use cdonts on a xp box without making some changes...

cdonts has kinds died out and as of windows 2000 basically got replaces by cdosys

,

Hi Chris,

I tried changing using Notepad in the config_inc.asp

from:

If  Application("SERVER_SOFTWARE") = "" Then
 Application("SERVER_SOFTWARE") = Request.ServerVariables("SERVER_SOFTWARE")
End If

To

Application("SERVER_SOFTWARE") = "iis/6"

and the albums still do not show up under the categories

Rhona (rookie)

 

,

1) Does everything, i.e. every user, every category, every product, etc., get stored in just one single database, or are there multiple databases at work and are linked to one another?  I am asking because there is only one table in the DB, and it is the "Users" table.  So I am presuming that there must be other databases that are linked to the DB.  Is this correct? 

2) Are user-level security permissions utilized in the sample Access DB that is shipped with the software?  I am asking because we cannot seem to remove the "temp" password no matter what we try, and this is the only reason I can think of. 

,

You might just learn something and actually get your project finished before 2010

your over there hacking away on your virus infested WaReZ machine

 

LOL thanks for the good laugh-- i guess its time to do some reading and making my own mods to the program..

btw i never insulted cafrepress.. not sure where you got that from- just advised that what they have is exactly what i want to have done. How much for your service?

, That helped very much.  Thank you.  Hope you enjoyed your dinner.,


Timecard Entry: 3/25/2006 1:37:41 PM

Took in good Tech. Calls, lunch, Return to clayton form the Channel partner meeting (I was the driver) 45miles, Not too busy, worked on cleaning around the office., phones, invoices, Training with Emerald, lunch, teching calls, Prep to go to Renzi Bros. for training., Office General, IMC-Net to fix NS2 and Squarecam, check radlog, check online reports, 1 phone call, client e-mail, answered questions for a potential customer. helped some with email, Carmen Keefer (SIIE), Billing calls, switchboard, callbacks, channel partner breakfast meeting., Self Training ASP & MS Access, laid cable in support of network, Telernet / Watertown Daily Times DSL in Lowville research., busy out cards 4 and 5 on TC01 and card 7 on TC02 for Randy's Syracuse trip tomorrow, Worked on customers computer., emails and minutes, *TaskForce: Competitive Research; Testing / Developing MS Exchange, 60 Copies of TICC Brochure and delivered to Days Inn. Scheduled interview for Stephen Poole. Printed Daily Reports & prepared weekly report for Monday Managers Meeting. Checked Email & Voice Mails. Hole punched 914, 915 & 916 tariffs (740 pages) printed DMS 500 system hardware portfolio (123 pages). , Checked email. Began writing welcome letter for Channel Partners. Updated lists of partners in excel including new additions., Email-re WANS with Seth, A/P analysis, Revamp office network setup, etc., Emails, Tasks, removed link to April newsletter on GiSCO home page and replaced with message of September newsletter coming soon (internal, non-billable),

   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.

Active Server Pages ASP control controls class classes module script Scripts applet 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