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

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 4:42:17 PM

I am trying to find out where I can enter the ttle for the application.

There is a variableor field called App_Name into which it would be good to insert a generic name. Can this be edited?

I have searched high and low but cannot find anything to do with it.

,

I'll send you something..

,



I have a user who is trying to login. However, I am getting a error that I can't seem to find.
Username: executive.barcheski
Password: executive@amcpc.com

Encrypted Password: ?=`م

Error on check_user_inc.asp line 114

If (Request.Cookies("PASSWORDSYSTEMCOOKIE")("KEEPMESIGNEDIN") = "True") And (Request.Cookies("PASSWORDSYSTEMCOOKIE")("COOKIE_USERNAME") <> "") And KeepSignedInOption And Status <> "Checkem" Then
CheckUserSQL = "SELECT " & tbl_label_users & ".* FROM " & tbl_label_users & " WHERE (Username = '" & RC4(Request.Cookies("PASSWORDSYSTEMCOOKIE")("COOKIE_USERNAME "), CookieEncryptionKey) & "') And (Password = '" & Replace(RC4(RC4(Request.Cookies("PASSWORDSYSTEMCOOKIE")("COO KIE_PASSWORD"), CookieEncryptionKey), PasswordEncryptionKey),"'","''") & "')"
Else
CheckUserSQL = "SELECT " & tbl_label_users & ".* FROM " & tbl_label_users & " WHERE (Username = '" & Username & "') AND (Password = '" & Replace(RC4(Password, PasswordEncryptionKey),"'","''") & "')"
End If

CmdCheckUser.Open CheckUserSQL, ConnPasswords

error received: unclosed quote after '?=

Any ideas

Jason Johnson

,

SQL Server Datareader Datawriter Permissions..

here is a screenshot that shows how to set datareader and datawriter permissions on a database using "SQL Enterprise Manager"

In this example we are making sure the aspbanneruser has those permissions on the aspbanner database in the SQL Server

cwilliams38390.5986921296, huh?  I think I just covered that as that is the way it must be done.,

I've encountered another problem.  When i edit the link for existing banners and save it, the banner reverts to the old link instead of the new one.

The directory where the the database is located to rwed so the permissions is not a problem.

 

Any advice?

 

Thanks

 

, oh, its timing out during the import ??

I didnt know that. I thought you said it was timing out after when you tried to log in.

That changes everything...

Let me start again cause I think I know the problem., You are NEVER supposed to move any files, especially that one. Of course that is going to break a lot of things.

Please put it back the way it was.

You change the path of the include file when you call it, never the location of the include file., Chris,

I'm setting up the subscription locally so I can't test it out until I put the site live.  I have a question in how the paypal subscription works.

1. What is telling paypal to return the info to the ipn.asp page for processing?  Is that something I have to set up in my paypal account?

2. I'd like to use Paypal's auto return.  I assume the return page would be  ipn.asp?  Would I just need to add a redirect  to the login page at the end of the appropriate txn_type if/then statement?

Thanks,
Michelle

P.S. I did finish the integration of the webwizforum with ASPProtect.  Thanks for the great headstart on that!  Will be putting everything live in a couple weeks.


,

There was nothing wrong with the server configuration. It turned out that the problem was that I disabled the email notification of new user registrations that I continually receive. That appears to disable the authorization email to new users as well.

One other issue. It appears that AOL email addressee's are not getting the authorization email. Does AOL have any blocks to CDONT generated emails?

 

 

 

,

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

users/user_area.asp

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

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

cwilliams38456.1069212963,

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,

and the permissions, how exactly were they set ?
I find a lot of customers think they are setting permissions correctly when they really are not. That's why I wrote that long article on the subject.

As you probably know a data connection is a very low level thing. It is the foundation of any ASP application that communicates with a database. Unfortunatly it sometimes takes a while to get the hang of setting them up without issue.

Everything must be perfect.. the ODBC drivers must be up to date, folder permission are critical, sometimes you must use a new version of the access database.. etc etc etc  The errors and things that happen when all these things are not perfect and not helpful as you have found out.

I would suggest you download and get ASPTest from CJWSoft running before you go any further. It is designed to be as simple as possible and helps get a hang of the database setup process.

,

The only major usability issue I've found to date is multi-zone banners. Cloning is helpful to a point, but then if you have a change to that banner, you have to make the change 6 times or what have you. I think, even at the expense of speed, multi-zone capability for a single banner would be excellent addition. Of course, that supposes I haven't just missed it and it's already there.

cwilliams38453.6665509259, Hello,

While there is no option in the admin area / asp code we give you here is what I can tell you.

You have the source code and we also use an open database structure. (MSAccess or MSSQL) So that means you can really run any query you want on the database whether with ASP code or directly in your database.  You can even tie other systems and code into the database via OBDC and manipulate data. The sky is the limit.

In MSSQL you can run queries in SQL enterprise manager or query analyzer. Using Access you can run queries in query view.

It's really not that hard if you do some research on SQL Statements and how to use them. You can do some very powerful queries and save yourself a lot of time. ,

Hello cwilliams, and thank you for the fast reply.

Well, i have tryed with the ASPImage enabled and disabled, with the same results. I have used gifs and jpgs in the tests.
I have made some different test. Some with uploading the picture over an excisting picture and some as the first picture. Same results.
Everytime, its the 2nd thumbnail that wont show itself, but the large picture will show, if you press the thumbnail.

I have tryed to look in the code (view_ad.asp), but as far as i can see, everything seems just fine ?!

I know, it wasnt much help i could give you, but i think i have tryed all the possibilities.

Best regards, Erling

 


 

,

if it is your own XP machine there is no reason you should edit that config file manually.

simply set permissions on the data folder and all the folders in it and the application will write to the config files on its own... if you are having problems chances are you are not setting permissions correctly.. please read all of this
http://support.cjwsoft.com/code/moreinfo56-1.htm

if is not an XP machine (your post was confusing and I am not sure) then this is an article for 2003 server
http://support.cjwsoft.com/code/moreinfo136-1.htm

Most importantly whats the real error ? error 500 does not help figure out anything
http://support.cjwsoft.com/code/moreinfo11-1.htm

lastly make sure you go into iis and make that web its own application

,

ok.. There are various spots that call the end_date variable.  That is why I am asking.  Then incorporating it into the forms that have been developed, made me wonder.

 

,

Ohhh...

I was thinking it worked like this; A user goes to that page and logs in.. and from there they can then browse the site and do what they want..

So in order for it to work i need to edit a page say... members.aspx (i assume it needs to be an asp.net page) and in the header put that protect code and when a user accesses it, it will prompt them for their un and pw and then if correct will allow them to view the page... and likewise if they are still logged in will be able to use the page?

If that is how to works as i mentioned above thats great...

I understand the redirect principle...but say i have a log in box on the main page... you know like most pages have a user log in on the left hand side... i wanted to do that. But i cant obviously protect the main home page or else normal users will not be able to view it without logging in or registering

,

This isn't going to help you much but here is the deal.

The 2checkout support in ASPProtect actually is not supposed to work with 2checkout subscriptions and therefore does not need to use an item number.

It is intended to be used for single payments only with 2checkout as explained in this thread.
http://support.cjwsoft.com/code/moreinfo212-1.htm

Single payments with 2checkout use their shopping cart which allows for dynamic payments without needing an item number.

I agree with you that 2checkout's interface is confusing. It's actually about the worst system I have ever seen. I could not make a 2Checkout subscription system because their system is just too limited and I couldn't make it work the way it really needed to.

, ok, it works fine here with that password encryption key and password you sent me. I also looked in the database and I got the same encrypted password password which definetly has a weird hidden line break in it. (for example if you copy and paste it only the 1st part shows up like when you pasted it above.. as it is really the same length as the that guys email address)

Maybe you do not have the newest code. (I added some code to check for those weird line breaks and take care of them) I am going to PM you the latest version. Please download it and just take the "check_user_inc.asp" file out and copy it into your existing install.

Then try logging in as that person again.

If that works you should also grab the new version of "password_admin/check_admin_inc.asp" as well,

someone has to do something other than me.. i've given up

if i give u the username/pw can you set this up on the network solutions host and ask them to set whatever permissions are needed?

cant do it anymore....

, its that server, it's way underpowered when it comes to running dynamic code and databases.. and that other app is probably stealing all the leftover odbc resources..... did you try doing the import on another machine running ASP? Thats the way to go.. I am afraid I won't be much help at the moment.. I am battling with a crashed system and a lot of lost data, Best setup I recomend is just setting up a rig and making a workgroup. No real reason for a production machine to have any access to internal security when you think about it.

classic asp should be pretty easy to move, just set up new webs and dump the scripts in there. If you have 2 machines its always easier to look at the one while your building the other. Basically copy the setup and tada... the only thing you might need to remeber is components (if your using any) and thats usually not a very big deal either.

Point sort of being at some point your going to have to change that thing around and while its no fun you have to imagine now is a better time to bite the bullet and get it set up the right way. Your alternative is to mess around for hours and hours praying that you change domain wide security to the point that running NET apps on that domain controller works. Personally I wouldnt sleep well knowing I had just messed around so bad with the OS that I had no clue what bugs and security holes I might have accidently opened in the process. I wont even get into the possible things that might stop working on the rest of the domain if you fiddle with accounts like "Network Service"

Oh and if thats not enough reason to make you think about it, consider how hard it will be to try and rember what you did at 2AM 6 months from now if that machine takes a dive or some critical update undoes what you changed.

I feel for you though, trust me we have all been down that road once or twice. Get some sleep and in the AM the task at hand wont seem nearly as bad. You live and you learn, and you will definatly be WAY better off making things right sooner than later

,
I am sure its permissions as well, but I don't have that much access to the hosted server...lol.
 
I will use access for now, since it works fine, and try to talk with the hosting people later.
 
Thanks!
,

It's seems to work fine after renaming the file, rebuilding the application, and editing the web.config file to point to login.aspx. It looks like I can use your fine product and thanks again for the help. It was unusually easy. Merry Christmas

,

I'm using ASPimage and have the maximum width set to 320 in the settings.  Also using SAFileUP ver. 4.0.

Files upload okay, and the script displays a confirmation that the image was resized to 320, but the actual image uploaded is displaying full size rather than reduced to 320.

Also, the thumbnails are not displayed in the Picture Manager. Would indicated ASPImage is not working or the script is not communicating with it.

Suggestions?

lancem38326.9070486111,

I'll give it a shot loading it on the laptop and publishing it, if it doesn't work I'll let you know and you can take a look at it tomorrow afternoon.  Thanks for all the help tonight...

Good luck pouring that concrete!

,

Sorry about earlier post in wrong area-

I have followed instructions to set up access levels (adding the

<% CHECKFOR = "4" %>    for user level 4 for instance.) The database is connecting properly and the basic check for login is taking place, but it seems that all users have access to all levels no matter what is on the database; i.e I set up a test page with "checkfor=4" and all users have access to it, even those with lower leve access.

Any ideas?

Thanks

,

Is it possible to change the currency for accepting payments?  I will like to change from US to Canadian.


Thanks in advance
Roy

,

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, Well, you cant have a login box on the home page when using ASPProtect.NET.. there is no way to make that work. I tried all day to come up with something and it is not going to happen. I suggest you make a login button and link it directly to the protected page you want them to start on. The redirect or link them whereever from there. Either that or write your own forms based authentication solution that works exactly the way you want it to or edit the code accordingly since you have the source.  It is not a feature we advertise for the product regardless. It works the way it works. ,

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

,

Chris: You are right about a little extra coding to make it work. I am still learning .ASP coding, so I did a little web searching and used IF THEN statments to confirm a member logged in with a valid Access Code. If valid, the protected page executes, with the Member's Name and Access Level on a single line at the top of that page. Looks sharp! If not logged in, or a non member (who found the page via Google), I used a Redirect to send s/he to a login page with optional links as you suggested (http://www.vspa.com/aspprotect/vspa-password-failed.asp) . I couldn't get it to work when using Group Access, but I am sure that is just because I am a novice at .ASP (I will post that example when I figure it out). Meanwhile, here's the code I used that works:

<%@ LANGUAGE="VBSCRIPT" %>
<!--#INCLUDE FILE="dataconn_inc.asp"-->
<!--#INCLUDE FILE="check_user_inc.asp"-->
<!--#INCLUDE FILE="config_inc.asp"-->
<% =Session("First_Name") %>&nbsp;<% =Session("Last_Name") %>:
<%
If Session("Access_Level") = "6"  Then
    Response.Write "VSPA Active Member Access Level 6"
 End If
If Session("Access_Level") = "7" Then
    Response.Write "VSPA Life Member Access Level 7"
 End If
If Session("Access_Level") = "8" Then
    Response.Write "VSPA Officer/Staff Access Level 8"
 End If
If Session("Access_Level") < "6" Then
    Response.Write "Access Level 1-6 NOT AUTHORIZED RESTRICTED AREA ACCESS"
    Response.Redirect("vspa-password-failed.asp")
End If
%><!-- http://www.vspa.com/aspprotect/vspa-password-enter.asp -->
<!-- *** End ASPProtect Code *** -->
<html>
<head>

 

, Attached is a SQL script to create the ASPProtect Database with the Option Pack Changes already applied. This lets you create the database in one step and you wont have to make the option pack changes as they are already there.

This only applies to people using MSSQL and doing a new installation.

This scripts are run via SQL Enterprise Manager.

You make a new database then run this script on it in query manager.

2004-06-14_180056_aspprotect_w_option_pack.zip cwilliams38152.7522569444, not sure, I havent used 2005 yet

seems like the process should be fairly similar.. you'll have to figure it out

I am going to order a copy of it., When I go to set up a new user, my user name and password are already in the window. And I am un-sure why. I start a new browser, and again that my same user name and password is in that window., I would like to change this file name to the typical Login.aspx, how to do this? I have a VS 2003 but need instrutions if that's the route to go.,

I did all that you sugessted and all failed, you  said "I did a sign up.. your verify URL is not saved/set in the application variables. is this somthing I can change manually?  below are the steps I performed......

1 - made sure the web is it's own application in IIS

2 - Reset IIS in command promt

3 - Restarted the server, the only thing is I have not waited perhaps long enough for it to kick in. but it should have with the restart.

I am running windows 2003 on the front end with wondows 2003 and Exchange 2003 on the back end, is there anything else that may be causing this issure?

Thank you!

Matt...

,

It's MS Access, Version 7 (the Full one).

Anyway, I had inadvertently changed the user_id field type to "number".  When I changed it back to "autonumber", everything went back to normal.

 

Thanks you very much for your quick reply and sorry to have bothered you.

,


Timecard Entry: 3/25/2006 4:42:17 PM

WWW.BSPP.COM REDESIGN OF SITE AND NAVIGATION CUSTOM BACKGROUND AND JAVASCRIPT MENU, Team Meeting., Pficked up mail and opened. Posted accounts, credit card authorizations, coupon referral, and customer inquiries., Resetting open modems on 686-4911., met with hacketts to discuss next step of their site, Marketing, E-Mail ... cant go a day without i guess., gto, Posted accounts and did a detail of checks and cash for deposit. Ans phone and coupon referrals and cc authoizations. Customer inquiries, phone messages and rsvp, Talked to Amy/Tom about DeferietPaper.com site and the last items that need to be taken care of., worked with Bill on new PC Bundle site for Steve, Doc Maresca's Frame fixup, Make list of traffic reports, Comp Day, using 1 marble., had a cople billing questions. helped a few users who couldn't surf, Marketing, petty cash/check, Stopping by watertown office and bringing out money, paperwork and 2 boxes of t-shirts, Migrate SimmonsCompany to iMail, Working with servers. Working with customers. Supporting customers., Back to Watertown, Read & Respond to Email / Update Time Sheets, Network Services conferencing. 5588 Issue & Ogdensburg ISDN issue., Showing Crispen how VB6.0 status/progress bars work, my file utilities package, how to make a window ''always on top'', etc., training john/phone time, Working on getting cnymn.com running live...adding info to the database and initial usersnames and access levels for them to get into it., to Watertown, answered phones, filed customer paperwork, filed dsl paperwork, submitted gisco supply order to clayton for review, HB - entered bills, paid bills, followed up with Shaughn, balanced checkbook, printed financial statements, GL & journal, e-mailed reports to Tim, filed.,

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