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

vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program CJWSoft ASPProtect ASPBanner ASPClassifieds



Blog Entry: 3/25/2006 1:45:45 PM

Well, hold everything.

Looks like I did it right. The latest user showed up in the correct group.

I guess the ASP pages had to refresh at the server or something...

It's still a great product, BTW. Almost five years for my enjoyable ride with ASPProtect!
,

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

Hans

,



I did try to redit the banner and the old link was there, not the new one.  In addition I tried to ad a new banner to an account but it too was not saved.

 

Since I can see the banners from the aspbanner solution, does that not tell me that the solution is properly connected to the database?  The only thing is the solution only appears to be able to read the data and not write or delete it.

The settings for the directory are read write execute and delete so I am not sure what I need to do to get it working again

 

, As I'd said in my previous response, I found those databases and they didn't work. All three databases in asptest do work.,

Sorry, you cannot, that is how it works and that is how it has to work for reasons I am not going to try to explain as it is pretty technical. (it works the same way even when not using paypal and using email authentication... nearly every registration system out there does it that way under an email authentication scenario or a PayPal IPN thing.)

Basically, if you are concerned about it you need to periodically manually check for accounts that were never activated and delete them. Maybe when I get some time some day I will make a little interface to help find those and clean them up at once.

 

 

,

yes, usernames and passwords are both case sensitive. It increases security.

,

Chris,

When I set up a test user name it does accept name and passwords and the passwords are encrypted, no problem there.

All I want to do is to restrict access to the protected pages to the members only. Only those users will be accepted and allowed to view.

I have entered all of thier names, address, phone number, email and company in the database, which is still named ASPProtect_access2002.mdb and in the fpdb directory of wwwroot. To get it there I uploaded via FTP.  I hope I expained the situation well enough.

,

Thought this would be easy.  A few more pointers should get the database connection to work:

 

1) How do you decide whether it is a DSN (system datasource) or not? Does just putting the file in the ODBC make it so? 

 

2)We have other files in there for other server applications, does that mean we’re stuck using DSN’s or is the file independent of that control dialog?

 

3) Assuming we get rid of using DSN for this database (or not), does the code go referenced in your article http://www.powerasp.com/content/hintstips/permissions.asp apply here or should it just work?

 

What else are we missing?

,

Have SQL 2000 backend...
We just moved from Windows 2000 to Windows 2003, used import data routine in SQL to move data.

Logged into admin area. When adding new user, no record is created. However, editing record works just fine.

Any ideas would be appreciated.

,

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

 

Thank you for your prompt response.

Our current project requires alot of customization.

 

Yes, the error is probably a data problem and not due to your code, because we needed to make modifications to the database.  But that's why debugging would be helpful.

 

Basically our intent to modify the asp protect code stems from the fact that our client doesn’t want certain fields to be recorded or to appear: address, city, state, zip etc…

 

We are happy to be able to modify the HTML, but we also want to modify some other default behavior, such as which page opens when the "cancel" button is hit in the editaccountinfo.aspx page.

 

 

,

Things have now changed I found out godaddy has persitis aspUPload and aspjpeg as value added products, I have the aspjpeg working but have been unable to upload when using aspUPload, everything works fine with the vbscript method so I think my permissions are correct. Whenever you get a chance, any help would be appreciated.

Thanks

Mark

,

Nov 2005

,
Excellent
 
Thanks, the DESC addition did the trick!
 
- Jason
,

Please be aware folks..

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

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

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

cwilliams38313.499837963, ok, so from your PM Iknow you are using SQL server with IIS5.
You say you created the SQL database using the provided scripts and  that is good.

What is going on may just be a weird odbc issue that sometimes happens on IIS5 when using SQL server and I have an idea on how to remedy it.

Edit the "config_inc.asp" with notepad.

Change

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


To

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

And lets see if that helps the situation.

it will change some SQL String query values in the application from "-1" to "1"

either should always work but under certain scenariois only one or the other works,

  Much thanks, the duplicate incl's I spaced on and should have caught.  The hidden form variable was a key issue.  Thanks for the syntax and the help.  Now I get this page together. j  As a note - I got faster results by dropping my timeout to 3 minutes temporarily while progging and cleared browser cache between tests.  Thanks again.

,

Yeah, its a win2k server.

Im up and running now (my guess is ASP wasnt installed, but he did not say), but am not having luck with any of the email.  I contacted my host to see what is available and have yet to hear back.  Do you generally recommend people to run CDOSYS?

Ive been reading through the docs, and the users and protection seems to be pretty straightforward.   Nice!

The only other real question I have (and cant find in the docs) is how to remove the self registration option all togehter.  My client wants to add its users manually, and not give the option for them to sign up themselves.  Do I just find any remove any code that references it?

, Totally 100% depends on what you are doing.. you certainly can't be renaming any fields unless you plan on editing a lot of code that references them. Adding new fields is nothing to worry about.

Also, you really should post a question like this under the forum section for the application you are referring to as well as specify exactly what changes you are talking about. For example I don't even know what application you are referring to.

I sell about 8 applications., Well, I had no more trouble after I read the instructions.

The PayPal integration is really neat stuff! WOW!  And the email users function got up and running in a snap... this is an awesome package!

The coolest thing with the user registration is that the account username and password are selected by the user. That is very very nice. Much less typing for me to do.
, I like to change my database from access to SQL.
I run the aspbanner.sql in the database and
then I checked the new database tables with the screenshots
from your support info.
Then I make a ODBC Connection and it looks very good,
I logged in and create a zone, but I was not able to
store it.
I got the following message:

Microsoft OLE DB Provider for ODBC Drivers- Fehler '80040e07'
[Microsoft][ODBC SQL Server Driver][SQL Server] Bei der Konvertierung eines char-Datentyps in einen datetime-Datentyp liegt der datetime-Wert ausserhalb des gütigen Bereichs.
/adserve/aspbanner/appinfo_inc.asp, line121


Please can anyone help me, that aspbanner also run on my SQL Server ?

Best regards Josef Raschko
, 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.,

I would look on the pictures folder on the server and see what is there for pictures. Also, when you see a broken X on the site right click and see where it is trying to get the picture from and what the pictures name should be.

I would also be sure to clear out your temporary internet files in IE. clost and restart all browsers..

maybe show me the site ? so I can see this happening ?

cwilliams38348.9748726852,

humm, yea thats a data connection error..
really not related to the asp code in the application for the most part.

that is low level


If using MSACCESS

I would make sure permissions are set correctly on the database folder (not just the database file itself)

I would make sure your using at least a 2000 version of the database. 2003-2003 format being better.. 

I would make sure the server has up to date mdac/odbc drivers.. (that is really the server admins responsibility)


As for permissions there are articles in our forums about exactly how they need to be set. Improper permissions can cause a ton of random errors like that.

cwilliams38414.6528240741, Not sure how to response.write the session variable,

Hello,

I do not really understand what you mean?
There are no country and city lists in ASPClassifieds.

cwilliams38391.0301388889, Then you should have current enough code.

If you PM me the encryption key you are using and the plain text password for this user I can see if I can reproduce the error and come up with a fix.

I believe you found one of the rare examples where the encryption creates a strange character that messes up things. Sometimes those characters are not even visable.

Changing the password should solve the problem in the meantime., sorry for the confusion, but I am not that good with the tech explantions yet.
what it boils down to is I have an Access Database containing over 100 members names.  I want only those people to be able to get into the secure pages.
Thanks.  Harvey
,

5 Computers in an office, random hardware and operating systems.  Some wireless some wired - all the same ISP connection.

Some users do not see the PLACE A NEW AD hyperlink.  How can this be hidden?  There is no conditional statement yet some see it and others don't.

To make this problem even more confusing if I take an image and put the place_new_ad.asp hyperlink on that image the users don't even see that image any longer.

How can this be resolved?

,

all I can say is try other things...  like

mail.yoursite.com

or

smtp.yoursite.com

etc etc etc

replacing yoursite with the name of your domain of course


the settings for sending email via ASP are no different then the settings you would use in outlook or something... except sometimes on the server level localhost works as the email server because they set it up to allow that

and of course those 3rd party emailing components need to actually be installed on the server

,

recent activity infomation is temporary and mantains itself per application start up.. when the web application restarts for whatever reason the info is reset

a reboot, an iisreset on the server, application pool restarts, etc etc
this is done because if that info was saved in the database your database would get huge real quick

logfiles however do not do that and are permanent

,

Weird things happening, when I upload using the vb method the image fails and error is that the image was empty.

Utilizing ASPUpload and after clicking upload file I get a blank screen, no preview, no nothing (it loads with the proper header/footer) but a completely blank body.

Any hints?

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

in Control_pic.asp is there way to wrap the description field so that it doesn't go outside the table.

 

Thanks

,

OK, I figured out the problem.  Not running ASP becasue the pages are not saved as ASP but rather HTM... OK so I am smart like a tractor but strong like an ox.

cwilliams38229.9128819444,

that wont work the way you did it because groups are not stored like like.

groups are stored "*1*"
or "*1*,*9,*"

so if you test for them you must do so using the InStr function of vbscript

example:

If InStr(Session("Groups"),"*1*") Then
    ' do whatever
End If

also.. as for the session variable
it should be    Session("Groups")

And in Version 6.... (its all ready to go in version 7) that session variable must be saved in the check_user_inc.asp file near where all the others are saved. If it is not there by default "I dont remember if it is or not" you have to add it like so near where all the others are saved

Session("Groups") = CmdCheckUser("Groups")

If you are wondering if it is being saved correctly you can always response.write out the Session("Groups") to see if it holds a value

, well, I think John just told you what the deal is. He knows more about ASP.NET than anyone else I know.

If you are going to run a non-standard setup then you are going to have big problems like you are having. ,

When a new user adds themselves to the db thru the registration page, no user id is assigned in the User_id field.  I can't access the page on-line due to an user_id related error on the page.  I must use access itself and add the user id.  After that, everything works as expected.

What have I done?

,

[QUOTE=cwilliams]
something weird is going on
[/QUOTE]

Yeah that's my impression too. I've done a lot of searching before posting this problem, but haven't solved it. Maybe it has to do with the sql-server/hotel?

Though I have compared carefully what goes on (and it should all be good) it could still be the problem? I have now made it work on a local msde sql server too..

,

Regarding installation in a subfolder

Though this should be common sense and ASP.NET 101 "so to speak" One thing not mentioned in the docs..


If you do not install ASPProtect.NET in the true root of a web there a key in the web config you must adjust.

it looks like this

<forms name=".aspprotect~net" loginUrl="/aspprotectlogin.aspx" protection="All" timeout="60" path="/" />

The way it comes it is valid for a root installation..

lets say you installed the application in folder called.
"aspprotectnet"

the key would change to this


<forms name=".aspprotect~net" loginUrl="/aspprotectnet/aspprotectlogin.aspx" protection="All" timeout="60" path="/" />

cwilliams38454.3830439815,


Timecard Entry: 3/25/2006 1:45:45 PM

billing, training Joanne, sign ups, Worked further on the logos and color schemes for Softstuff. Set up TICC flyers to print and satrted them.Also sent Tara the three up coupons as PDF file. , Answered my personal emails and did some reading about some ASP code and tips. , Transfer Laptop Files to Desk top, Lunch, get emails caught up and voice mails called a couple of ppl, Web billing -stuffed for the mail, Working with customers. Working with servers. Working on DSL., Checking balance sheet, web billing, started monday reports, baldwinsvillechamber.com - converted database phone & fax numbers to properly formated phone numbers (added area code and punctuation correction) and re-published to server. (trade), LUNCH, Telephone conference with George Deptula and Paul Barton, fixed melody brabant's computer, ti.com website redesign / graphics, Had a meeting with Ron and Jim about some issues. , lunch, switchbaord, starts, stops, etc., creating PDF files for Andrea to print..., tanned, enter deposit, take to bank, pull pd. invoices, cc. deposit, travel from Watertown to Raleigh NC, catchup on work, Switchboard, billing calls, emails, newsletter, Started doing last week's billing., in-house pizza fest, 75 miles to Syracuse, fetching for the masses(towels), lunch,

   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 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 www.aspclassifieds.com, www.powerasp.com,www.cjwsoft.com,www.aspphotogallery.com,www.codewanker.com,www.aspprotect.com,www.aspbanner.com