Home | Advertising Info55 USERS CURRENTLY ONLINE   
PowerASP
   Site Search Contact Us Saturday, May 21, 2022  

Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components CJWSoft ASPProtect ASPBanner ASPClassifieds



Blog Entry: 3/25/2006 2:50:41 PM

Well I still haven't gotten it to work yet completely.  I tried to import the users again and it imported some, but timed out again.  Trying to log in takes forever...ready to jump back on this one?,

Chris,

Yesterday when I would access the get_me_in page with the password key, I was then taken to the default login page.  It did not give me the option to create a user. 

Today, when I entered the password key into the get_me_in page, I was taken right to the create user page.  So, yes the problem has been resolved.  I have no idea why though.

 

,



That would not happen unless you added a target to the login form or you're code had a base target set.

Like so..

<base target="_blank">

I would really need more detailed information. It's nothing the system does the way it ships under normal circumstances. For example you shouldn't see that behavior in any of the example protected ".asp" pages

that is unless you have something odd going on with your browser settings or you made changes to the login form or code around it causing it. (or you are using frames and dont have some of the targets and what not set correctly)

My guess is that it has to be something you added or did, but I really need to know more to offer more than that.

 

cwilliams38419.7687152778, 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
,

I have been using ASPBanner for a while and am very pleased with it. Congratulations on a good product.

Only one feature is missing that would really help me and this is being able to display banners dependent on some condition (/aspbanner/aspbanner_inc.asp?BannerZone=6&condition=xxx ).

I think this would be a good idea as it would allow users to present adverts based on different criteria; for example; specific country/region related ads, ads based on time of day, ads based on user preferences, etc.

To achieve this I was thinking of adding a field to the database so that I can enter a set of comma delimited conditions for which the banner can be displayed.

I have looked through some of the asp code with the intention of seeing how easy it would be to implement the functionality. Not knowing the code however, I think that modifying it myself would be risky as I may inadvertently change things, which would have a negative effect.

Would adding this type of functionality in ASPBanner be of interest to you. If not, can you let me have your opinion as to whether this would be relatively simple change for me to do myself or would it be too risky and I should give up the idea. Any guidance or feedback would be appreciated.

 

,

5300 users honetly wouldn't even phase the database or the code... even with MSAccess...you got other problems and I can say that with 150% certainty

my guess is permissions on the database folder are not quite right or the odbc drivers have issues.. something along those lines..

access databases act up when full modify permissions are not given to the folder they are in.... they can also act up if the odbc drivers are very new and you are not using a newer version of the access database such as 2002 version as opposed to a 97 or 2000 version

using a system dsn as opposed to a dsn-less connection can also cause BIG issues. always use a DSN-LESS connection

you can also have big problems if just the database file is given permissions instead of the whole directory it is in

also, the script timeout has nothing to do with it.. if that is happening something is wrong with the data connection like I said... no amount of changing timeouts is going to cure it...

how permissions are correctly set
http://www.powerasp.com/content/new/windows_2003_server_and_ permissions.asp

why system dsn's with access databases are bad news
http://support.cjwsoft.com/code/moreinfo9-1.htm

I know it worked at 1st but it can still be related to all of this because when permissions are not perfect databases will work ok for a while and then act up. it all has to do with the temporay lock files that access creates and deletes on a regualr basis

,

I will actually explain how to set access_levels and/or groups...

in "users/add_new_account.asp"

carefully edit with a text editor
find this part
 
CmdAddUser.Fields("Access_Level") = "4"
 
that is where the acess level gets set...
you can change the level or remove that line all together if you dont want one set
 
now for groups you would add this line in the same area
 
CmdAddUser.Fields("Groups") = "*3*"
 
or
 
CmdAddUser.Fields("Groups") = "*1*,*2*,*3*"

Groups access for a user is stored in one field in the database like you see above. If you are confused what you should be saving in that field I suggest simply setting a user to whatever groups you want via the admin area and then looking in the database to see what got saved in that field. It's pretty simple really how they are stored.

*1*,*5*,*9*

that user would be a member of groups 1,5, and 9
,

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...

cwilliams38303.6065740741,

Hi,

I am just wondering if anyone else has had this problem. Even though the guestbook is empty, it takes just about 20 to 30 seconds for the guestbook/default.asp lto oad. Is this normal has anyone else has had this problem.

Thanks

, Sorry, I can not provide a date..  I am last person that is organized enough to give any sort of release date on anything.

Could be next week, could be 2 years from now. I made two add-ons this week and they came out of no where. I had no plans to make them. etc etc.. they just happened.

If I told you 2 months from now I know it would not be done and you would be disappopinted so I am not saying anything. I will say if it turns out to be anything complex it will not be a free mod or it will be a feature of a new version.,

Not really.  The way I thought activity would work is that I would always see the last 50 users.  Not sure what controls that and why I wasn't seeing it, but it sounds like it is an IIS thing and since my site is not all that busy, it will not show the users if some process has reset the numbers.  Not a big deal.

As for the log files, I think it is related to my other question regarding the export directory.  I have the ISP looking into things at thier end to see if they are doing anything that could cause the directories to disappear.

Thanks,

Dave

,

ok... lets forget about all this redirecting business for a minute

when I go to "GP01.asp" directly via your web site I get a big nasty error that says this

Microsoft VBScript compilation error '800a0411'

Name redefined

/protect/config_inc.asp, line 15

Dim  Address_Required,CDONTS_Installed,City_Required,Registration _Type,VerifyURL,Log_Off_Page
----^ 








then when I look at what you did in that file I see why



you have this code which is totally wrong because you cannot include the password protection file twice
<%@ LANGUAGE="VBSCRIPT" %>
<!--#INCLUDE FILE="check_user_inc.asp"-->
<% GROUPACCESS = "*1*" %>
<!--#INCLUDE FILE="check_user_inc.asp"-->



 
it should be
<%@ LANGUAGE="VBSCRIPT" %>

<% GROUPACCESS = "*1*" %>
<!--#INCLUDE FILE="check_user_inc.asp"-->
and that is probably the root of this entire problem.. the redirection was working...
but you were sending them to invalid pages with errors

all those pages are wrong...
if you dont see the real error above see this
http://support.cjwsoft.com/code/moreinfo11-1.htm


if you look over the aspprotect 7 installation instructions that is the very 1st thing I tell people to do


hopefully this is the info you need to continue and get some work done
, Seems as though changing the mail settings to "remote email server" did the trick.
, As I'd said in my previous response, I found those databases and they didn't work. All three databases in asptest do work., ok, glad it is working,

(Capcha Security Image Mod)

This mod will add a Capcha Security Image to the registration signup form.



Instructions:

Download the latest version of the ASP Security Image Generator from this site. http://www.tipstricks.org/

Unzip that download and copy "aspcaptcha.asp" and "aspcaptcha_distort.asp" into the aspprotect "users" folder.

Now edit "users/register.asp" with a text editor and add the code shown below in blue. The code to add goes near the bottom of the form right above the submit button. Just add the blue code. The code around it is shown to help you find the area of code where it gets placed.


    <tr>
      <td valign="top" align="right"><font face="Arial" size="2"><strong>
  Newsletter</strong></font></td> ; ; ; ; ; ; ;
      <td valign="top">
  <input type="checkbox" name="Newsletter" value="True" checked>
  <font face="Arial" size="1">Do you want to be subscribed to the
  newsletter ?</font></td>
    </tr>

    <tr>
      <td valign="top" align="right"></td>
      <td valign="top">&nbsp;<img src="aspcaptcha.asp" alt="" width="86" height="21" />
   <font face="Arial" size="2" color="#000000">Type the characters shown in image for verification.</font><br>
   <input name="strCAPTCHA" type="text" id="strCAPTCHA" maxlength="8" /></td>
    </tr>

    <tr>
      <td colspan="2" bgcolor="#FFFFFF">
        <p align="center"><input type="submit" value="Register"></p>
      </td>
    </tr>


ok, now edit "users/add_new_account.asp" with a text editor and add the code shown below in blue. Just add the blue code. The code around it is shown to help you find the area of code where it gets placed.

If User_Custom6_Used = True Then
 If User_Custom6_Required = True Then
  If  Custom6 = "" Then
   ErrorMessage = ErrorMessage & Server.URLEncode("You need to enter a " & User_Custom6_Name &".\n\n")
  End IF
 End If
End If
 
 strCAPTCHA = Trim(Request.Form("strCAPTCHA"))
 if strCAPTCHA = Trim(Session("CAPTCHA_" & Session.SessionID)) then
 else
  ErrorMessage = ErrorMessage & Server.URLEncode("You did not type in the verification info correctly.\n\n")
 End If 

 
If ErrorMessage <> "" Then
 Response.Redirect "register.asp?" & Request.Form & "&ErrorMessage=" & ErrorMessage
 Response.End
End If

Your done. You just added a Capcha Security Image to your signup form. If you would like a more distorted image that is more difficult for an automated program to figure out change the image tag to call the "aspcaptcha_distort.asp" page instead. It will look more like this.

, there is no straight answer to a question like that..

I think my code is very easy to figure out and work with...

What your asking all depends on your skills and also what sort of payment processing system/merchant account you go with and what sort of ASP example code they provide you,

Ya, you must have tried to upgrade from a really really old version like you said which wouldnt really work out because those instructions are specifically for upgrading a version 6 database to version 7.

That line error you had was looking for the User_ID field and I bet the version you had was so old that you didnt have a field named that as a few years ago the field "ID" got renamed to "User_ID"

As for all the cool stuff... yup there is a lot of cool stuff in this version... glad ya like it so far

cwilliams38418.8164930556,

it is by design actually and something that can be improved
(I just never thought of it when I 1st designed the system and it is actually planned to be added in Version 8)

The trick would be to reset those session variables anytime someone edits and saves their information... not very hard at all

you would do it on the save code page for when a user edits themself.
you want to grab the info posted from the form and  reset each session variable at the same time everything is re-saved to the database

example

Session("Company_Name") = Request("Company_Name")



 

 

,

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

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

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

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

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

a remote sql server should not an issue.

thats really all I can think of right now

,

Hi all,

I have the photo gallery set up at www.kashabowieoutposts.com/gallery

It's great - love to work with it.

But I've never been able to get those with just User permissions to be able to upload... Only an administrator is successful in uploading.  This was no problem in the past, but now this client would like to give their guests a means to share their pictures on their site - so now I have to figure out the bug...

... this is the error I keep getting...

Your upload did not succeed, most likely because your browser does not support Upload via this mechanism.

Your browser must support a standard called RFC 1867. Please check with your browser vendor for support of this standard.

 

------- anyone else experienced this?

Many thanks all!!

Doug

,

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

Thanks.

, no, and none of the ASP based systems I know of can do anything like that.

A zone can only produce 1 banner at a time.

What your are talking about I have mostly only seen done using very complex javascript code available freely on the web if you search. ,

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

 

thanks!

,

I finally spoke with someone who knew what I was asking for and they set the rights and all is fine.

Thanks for your help. Wish all business' had customer support like here

,

It appears there is an auto logout after inactivity for a period of time.  How does one change the default time allowed for inactivity?

 

thx

,

no, there is not not.

If you wanted to to that you would have to add some code to check their album count in the database and not allow them to make a new album if they were at the limit.

cwilliams38433.0233680556,

Microsoft has a free version of SQL server 2000 than you can run on a development machine.


http://www.microsoft.com/downloads/details.aspx?FamilyID=413 744d1-a0bc-479f-bafa-e4b278eb9147&DisplayLang=en

This is really the same thing as the MSDN version of SQL server that comes with Visual Studio

It is limited in two ways.

  • No single database can exceed 2 gigabytes in size. However, each Desktop Engine server instance can contain many databases, each of which can be up to 2 gigabytes in size. Each computer can host up to sixteen instances of Desktop Engine.

  • Performance will rapidly decline when more than five simultaneous users use the database engine at the same time. With five users or less Desktop Engine will operate with full SQL Server speed.

    After you install this your going to need a way to connect to your sql server as well as a way to run queires on it.

    I suggest either install the client tools off any SQL 2000 Installation Disc (giving you enterprise manager and query manager)

    or use the FREE SQL Server Web Data Administrator which will do amost everything you  will need to do. It is really very slick
    http://support.cjwsoft.com/forum/forum_posts.asp?TID=127& ; ; ;PN=1

    Then you have a pretty sweet setup for testing and developing locally using SQL server.

    If you are wondering why someone with a real SQL Server 2000 cd wouldn't just install the real SQL server locally it is because the server part will usually not install on XP Pro or non server versions of windows for licensing reasons. (at least every SQL 2000 CD I have is like that regardless of whether it is standard or enterprise) But the client side tools on the cd are invaluable so I just install the Desktop Version of SQL along with the client side tools and everything works great.

  • ,

    Protecting ASP Pages

    To protect a page without using the Access_Level or Groups feature simply add this code to the top of that page.

    Put this under the <%@ LANGUAGE="VBSCRIPT" %>

    <!--#INCLUDE FILE="check_user_inc.asp"-->

    This is an example of a File Server Side Include. You could also use a Virtual Server Side Include.

    The following URL explains what Server Side Includes are.
    http://www.powerasp.com/content/code-snippets/includes.asp

    Now when someone runs that page they will prompted to login. They will not be allowed access to that page until they successfully logged in.

    An example of doing this is provided in the "default.asp" file included in the root of the Password System.
    Look at the source code with a text editor to see the working code. It is quite simple.


     Protecting ASP Pages Using Access Levels

    To protect a page using the Access Level feature simply add this code to the top of that page.
    You simply specify the Access Level before the include file is called. In this example we are protecting the page with Access Level 4.

    Put this under the <%@ LANGUAGE="VBSCRIPT" %>

    <% CHECKFOR = "4" %>
    <!--#INCLUDE FILE="check_user_inc.asp"-->

    This is an example of a File Server Side Include. You could also use a Virtual Server Side Include.

    The following URL explains what Server Side Includes are.
    http://www.powerasp.com/content/code-snippets/includes.asp

    Now when someone runs that page they will prompted to login. They will not be allowed access to that page until they successfully logged in as a Level 4 user.

    Examples of managing Access Levels are provided in the "multiple_access_levels" folder included in the root of the Password System.
    Look at the source code of the ASP pages in that folder with a text editor to see the working code. Again, It is quite simple to follow.


    Protecting ASP Pages Using Groups

    Please see the code generators in the admin are for the code to do that.

    cwilliams38403.6864351852,

    I'll give it a shot within the next day or so. I'm busy with a few other things right now.  You're right about just saving a copy before I start. It can't really hurt anything.

    Thanks Chris. I'll let you know how it turns out.

    -john

     

    ,

    I think I've found the problem..

    The password "abcdefgh" works

    The password "abcdefghi" does not

    (username "ace45")

    Passwords can obviously only contain up to and including 8 characters... By some coincidence I only used short passwords with MS Access.

     

    ,

    Some of our users complained that their users id and passwords are sent in the clear. So we decided to invest in an SSL certificate from Verisign. It has been tested fine with all forms and pages in ASPProtect version 6. The only remaining page which I am not sure how to protect is the home page. Let's say my home page is http://www.MyDomain.com/index.asp. When the user goes to this link he/she will be presented with the check_user_inc.asp page so he/she can enter their ID and PW. So how to make the login information send from this page thru HTTPS?

    ,

    Chris -

    Sorry, I am looking at your code on view_item.asp and I have noticed that you are calling 3 variable; start_date, end_date, and image_url that do not exist in the databases that you provided.  Do I have the updated package for ASPVendor?

     

    ,

    Glad it is working.. for anyone reading this the customer bascially did this
    http://support.cjwsoft.com/forum/forum_posts.asp?TID=36& PN=1

    That being said asp photo gallery actually has a few more places that send email that you going to need to modify as well. Off hand the reply to album, admin massemail, admin send email,and postcard features come to mind possibly as 3 of them.

    using a multiple file search and replace utility like ReplaceEm would be the easy way to do all of this in one step and find all the instances

    http://www.orbit.org/replace/

     

     

    cwilliams38420.4424537037, If you makes you feel any better the photo gallery app runs awesome off an access database. Mostly because all of the picture work is done in the filesystem, not the database. The load on the database is relatively low even with a lot of users., They really have do not have anything  to do with each other as far as code and numbering goes, but I really do not fully understand your question or where you are going with this.  (the part about the user setup ?)

    Groups are more powerful than access levels and are meant to replace them. Access Levels are only there for backward compatibilty with older versions. ,

    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.

    , I checked the SQL table and had 1 banner with no zone ID. I added it in
    directly through the SQL interface and now it seems to be ok.,

    Some users have reported an error during the registration process.
    Here is what I believe is happening.

    When you register you get sent a validation email that has a link in it that looks something like this.

    http://support.cjwsoft.com/forum//activate.asp?ID=testAD3AD2 97BC

    That link can only be clicked on once which will activate your account.

    If you somehow run that link more than once you will get a message telling you there was an error.


    I think some people are double clicking on the link they get sent and running it more than once.... or clicking on it again after registration is complete. It probably happens very fast so they never see the success screen.

    Either way, if you can login to the forum nothing is wrong and you are already activated.

    cwilliams38089.6248842593,

    I'll try to help when I get back tues night,, see the contact page for info on where I am .
    http://www.cjwsoft.com/contact/default.asp?Subject=CJWSoft+G eneral+Inquiry

    ,


    Timecard Entry: 3/25/2006 2:50:41 PM

    Did a callback for a customer that sent an email, Reset FrontPage perms for pizzagalli site, Coupon Holiday coupon # 42-5, worked on internal Work Request system (internal billable, programming), Answered phones, called users back and did general TS duties., meet with rob diedrich a c21 broker who is a main player also with the herkimer/mohawk board, vacation- last day of freedom!!!!!!!!!!!!1, Howard - Planning, Bell Atlantic - Provisioning UNE, preparing TICC materials fro printers, talking on phone to printers..., Help Ogdensburg School with set-up of existing customers, Review Operating Agreement, met with matt to discuss changes, teched calls, RadLog, to watertown, phone call with ed about problem with frame router, timecards, 23 Miles to Watn., helped a couple people with their mail. a few people having problems putting in their passwords, Clayton - Watertown, misc, VALERIE SUTTON ALBANY VOTE, email,check on system, prep work for day, Took a long call. Only got 1 call in between that call and they left a voicemail. Started getting hammered at 9am. Green light went on and off a good 6 times during a signup. Checking it right after this. Ended up getting a couple other calls after that., calls at last!, Phone conv. w/ Chris Williams RE CCBR & ODMLS customizaions - making sure none of the requested changes conflict with other parts of the system., Emails and call to Drew, Using coupon for MON and TUES, added July river report to tibait.com, Jeff Cooper re: suimall.com, WOrked on work orders and copy for ads in the times and Northcountyr this week,

       Active Server Pages Rule The World
    Contact Us  
    All artwork, design & content contained in this site are Copyright 1998 - 2022 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 what is asp programming how to sample asp example code scripts software asp forum mail sessions applications global.asa 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