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

Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET CJWSoft ASPProtect ASPBanner ASPClassifieds



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

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. , not anything built into the app... it would be done with client side javascript if you wanted to look into it...  my client side javascript skills are ziltch,



Hi Chris,

The hosting company has been doing some work apparently regarding the database connection issue. Still something is funky

When I type in www.vickerylightning.com/aspgallery/default.asp I get the custom 404 error page and I noticed that it is trying to open the following:

http://www.vickerylightning.com/skins/default/settings.asp

Is that what it is supposed to do?

Thanks!
Rhona, the rookie

 

 

, aspprotect does not use a global.asa file

I would start by looking there and seeing what is going on ... with line 33

I dont see how it could be related to aspprotect in any way

Global.asa files fire on their own and what they do depends on what code is put in them,

Yes, thats cool.. post it here for sure.

Also, the way you allowed for your search engine is clever and probably was the easiest way to go.

You could do the same thing with the IP. Much easieri than the way I was thinking of doing it.

 

, Well at least now the import/export link shows up now! lol,

Its still not there as labeled 'internet guest'.  There's a 'guest' and a host of others.  Is there a way to identify it as the proper guest account to use with ASPProtect?

Also, looking through support documentation, I see other possibilities it could be (http://www.powerasp.com/content/hintstips/permissions.asp).  Is there a way of telling which the problem is and whether we use a dsn connection or not?

The error we are getting is

 Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x1340 Thread 0x17a4 DBC 0x162becc Jet'.

/aspprotect/scripts/populate_config_variables_inc.asp, line 11

,

While attempting the database connection test, I receive the following error:

Server Error in '/' Application.

Security Exception

Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file.

Exception Details: System.Security.SecurityException: Security error.

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:

[SecurityException: Security error.]
   aspprotectnet.DBConnectTest.Page_Load(Object sender, EventArgs e) +0
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +35
   System.Web.UI.Page.ProcessRequestMain() +2112
   System.Web.UI.Page.ProcessRequest() +218
   System.Web.UI.Page.ProcessRequest(HttpContext context) +18
    System.Web.CallHandlerExecutionStep.System.Web.HttpApplicati on+IExecutionStep.Execute() +179
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +87


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

My guess is that this is an issue with the fact that I'm in a shared hosting environment that is restricted by CAS.  Before I move to a dedicated server, I'd like to verify that this is the issue.  I'd appreciate your input.

My host is 1and1 Internet.  You may find this FAQ helpful: http://faq.1and1.com/scripting_languages_supported/_net/16.h tml.

 

, I have run into the same problem with streaming pdfs to the browser using the stream_download.asp example, but only when selecting the option to open the file directly into the browser (after it's streamed back) as opposed to saving it and then opening it (which works fine in Firefox and IE).  Then I ran across this Microsoft support article

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q2 97822

It got me thinking that maybe a header needs to be included in stream_download.asp that tells the browser to specifically cache the file. Adding this suddenly got everything working

Response.CacheControl = "Public"

right after this line in the code

Response.ContentType = "application/octet-stream"

My asp is limited, but this seems to work at least for pdf documents.  Can someone confirm this?  The other question I have is if this is a solution, should the CacheControl be set to public or private.  Not sure on what the implications are.

Firefox by the way seems to open or save and open the file without this, so you are right that the implementation between the browsers is certainly different.

Tom

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

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

,

Thanks very much for the tip. I'm a beginner with all this stuff so forgive me for the inate stupidity!

By the way, I think the system is great and I am very pleased my purchase.

cwilliams38317.5552662037,

... in addition it is a virtual include not a file.  I just tried to use file instead of virtual and then the ../ includes worked on the asp pages.

This is strange because they used to work like that on the 2000 server I had these sites running on.

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

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, also, just to show you what happens when a user creates a subscription this is the code. you can see in red where the subscrition is is set and also where the exp date is set to null

 If txn_type = "subscr_signup" Then
  
  Set ConnPasswords = Server.CreateObject("ADODB.Connection") 
  Set CmdEditUser = Server.CreateObject("ADODB.Recordset")
  ConnPasswords.Open ConnectionString
  SQL = "SELECT " & tbl_label_users & ".* FROM " & tbl_label_users & " WHERE (User_ID = " & User_ID & ")"
  CmdEditUser.Open SQL, ConnPasswords, 1, 3
  
  CmdEditUser.Fields("Active") = "1"
  CmdEditUser.Fields("Validated") = "1"
  CmdEditUser.Fields("PayPal_Subscriber_ID") = subscr_id
  CmdEditUser.Fields("Notes") = "Successful PayPal Subscription Signup on " & Date
  CmdEditUser.Fields("Expiration_Date") = Null
  
  If Access_Level <> "" Then
   CmdEditUser.Fields("Access_Level") = Access_Level
  End If
  
  If Groups <> "" Then
   CmdEditUser.Fields("Groups") = Trim(Groups)
  End If
  
  CmdEditUser.Update
  CmdEditUser.Close
  Set CmdEditUser = Nothing
  ConnPasswords.Close
  Set ConnPasswords = Nothing
  
 End If
,

Sounds to me like you got some bad databases or something. Or your trying to open a database with too old of a version of msaccess.. not sure

Everything is stored in one database. And yes there is more than just the users table.

Also,  removing the "temp" password should be a piece of cake.

Email me for a new copy of the download file ? Use the contact from on the cjwsoft site. Please tell me your order details as well so I know who you are.

 

,

The parent paths things really should not be an issue.

This is an article from the troubleshooting section of the documentation that takes care of it all very easily.

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


As for a good host that knows ASP and does not mess around when you ask for something. I always recommened www.alentus.com

 

,
Yeah, its working great witht he Access database. Now I just need to get it all set up. I like how the config file is set up with all the comments, it really helped allieviate the 40k thumbnails, .
 
One quick question though, and I haven't looked through all the code yet... Is there a quick way to have pic_window.asp open full screen by default? I just want to minimize having to either scroll through, or maximize, the screen
 
Thanks!!!
 
- Jason
,

ok, I moved this thread..

The code in the ASP application handles all encryption and un-encrpytion of passwords in the database. I uses the vbscript RC4 function and the password encryption key specific to your installation to do this.

The whole idea is that if someone gets your database and opens it up that they will not get the passwords (utilitiies to crack access databases are common and work well so they can easily get by the main password)

That being said when you open the database manually your not supposed to see clear text passwords. Your also not supposed to have an easy way to make them clear text. It's a security thing. 

Though I am not officially supporting it I will tell you what I think would be the easisest way to make an export file with clear text passwords in it.

Use the export fire creator in the admin area of aspprotect.
Mosdify "export.asp"

change

Password = CmdDataExport("Password")

to

Password = RC4(CmdDataExport("Password"), PasswordEncryptionKey)

Then make an export file and see if that worked.
you can then import the export file into and access database or do whatever you like with it.

,

There is no way I'm going to spend hundreds of dollars for a thumbnail creation program. Mine is a family web site and all out of my pocket.

Is there any free products that work with Gallery that will create the thumbnails? If not can I create them on my own and link them to the pics? There are tons of Perl based freebies out there.

 

Steve

,

Has any one used the aspmail function to send emails from within your site? If so what did you use as the AspMail_Host string in the connections database?

thank you

,

I am using VS 2005, when i go to new project in visual basic folder asp.net web application is not there..

Can i add it somehow?

,

Hi

I've tried almost anything here... I'm using an online SQL SERVER database with ASPProtect 7, and I can't login after my initial creation of the admin account.

It works fine with Access... I believe I have checked all the fields created by the sql statement (which was run with no errors),

What could be the problem here? could it be a problem that I run my local IIS against the online sql server?

sincerely,

Morten

,

OK, I just spent like an hour in your site.. I almost gave up

1st off... I don't know what FTP Program/Settings or what OS you are using but all the ASP Protect Files had been reformatted in a odd way which was causing some issues and the database also had problems. Your somehow introducing all sorts of UNIX line breaks to all the files and the database was actually missing some crucial parts of itself and was corrupted. So I had to update everything which means a new database. I have never seen anything like it but I fixed it all. Its something you are doing but I do not know what. Maybe your unzipping method again ?


So to get back into the admin area...

admin
test

Now, the reason  the albums were not showing is because you are using the ole connection string which causes problems like that. However because you host has like the worst setup ever with that network path crap for the site that was the only connection string that would work for some reason.

I highly suggest a new host with a proper setup for running ASP. www.alentus.com
Your hosting companies setup is horrid as far as I am concerned.
Access Databases are not meant to be connected to via a network path.
http://www.aspfaq.com/show.asp?id=2168

Anyway, I rewrote some of the code because of the ole connection and got the albums showing up for you.. who knows what other problems that OLE connection may bring up in the future.. for now things I tested seem ok.

As for your broken image in the your header/footer...  You cant link to images and links using virtual pathing in those includes because the files are called from different directories and will work in some and not others

so when your in the root you see the image, when in a different folder you see a broken image

In other words.

link to

http://www.vickerylightning.com/gallery/vickery_template5_r2 _c1.jpg

not just

vickery_template5_r2_c1.jpg

The same goes for hyperlinks.. use the full url paths


Whatever you do...Back up the gallery folder with my changes before you go doing anything.

,

thanks.. it was not taken as a complaint.
I just wanted to explain

When you said you tried using the web version of sql manager. Did you use the microsoft one I link to here "just curious"

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

 

,

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

and upgrade instructions here in the forums

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

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

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

,

This has not been officially released yet, but it is ready.
Here is the overview...
http://www.aspprotect.com/demo3/paypal_signup2/overview.asp

And the Code for the IPN Subscription Pack is 30.00.
http://www.aspprotect.com/ipn_subscription_support_pack.asp

A few people are using it and say it works very well.

Like the IPN Single Purchase System it is a separate directory you copy into the web site. One change must be made to your database so it’s pretty easy to get working. 

Though I am not guaranteeing this you should be able to accept Single IPN payments and IPN Subscriptions at the same time without the two bothering each other. I haven’t tested it but one customer is doing it and said it is working fine. It just involves manually specifying the IPN URL for one of the systems so it overrides the default IPN URL on your paypal settings. (As each system needs its own IPN URL) Its easy to do… just a form field you would add to the subscription form. I already looked it up. See below. 

Specifying Your Notification URL

If you only need to receive your IPNs at a single URL, you can enter that URL in the Preferences section of your Profile. If you would like to receive payment notifications for different payments at different URLs (i.e. if you need to separate payments made to different websites you run), you can manually pass the IPN URL with each payment by including it in that payment’s HTML code. Use the notify_url field to pass this information. The notify_url for a specific payment will be saved, and any subsequent updates to that payment (e.g. cleared eCheck) will be sent to that notify_url. When you pass a notify_url in your HTML code, it will override any preferences you set in your Profile. 

Anyway.. the Code for the IPN Subscription Pack is 30.00.
http://www.aspprotect.com/ipn_subscription_support_pack.asp

 

cwilliams38342.8775578704, ok,

i will probably end up doing this myself, but dropping all the log data in a sql table would be nice as it offers much more flexibility on how an admin can keep track and use the data. Browsing through each log file is very inconvenient. I can search for text in the files (server-side, others with a shared server would probably have to separately download all log files first), but with the current method I don't have the following important options:

  • cannot sort by any criteria
  • quickly see a list of all login attempts by a specific user (i need to search each log file individually for this info)

if you had an option during setup perhaps (or elsewhere) in a future version that allowed an admin to specify the preferred logging method (separate files or a table in sql) i'm sure many admins would find it very useful to have a database alternative of keeping track of users becuase it would offer the two benefits listed above, plus more.

,

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

,

(Password_Email_Confirmation_Mod) for ASPProtect Version 7.x

This will change the basic registration pages so that the email address and password entered must be confirmed when signing up. This eliminates the auto generated password during signup.

Some may prefer it working this way.

Directions:
Back up your existing ASPProtect installation.

Copy the two new files into your "users" folder

"register.asp"
"add_new_account.asp"

2005-12-01_182201_Password_Email_Confirmation_Mod.zip

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

Regards

Andy
,

you dont want to use the virtual smtp virtual server method... you want to use a real remote email server with valid MX records..

ultimately though after all that is going is it is out of the hands of the asp code and it becomes issues other then the code sending the email... regarding to whether or not emails get blocked by certain organizations

For example:
I have many aol users sign up for various systems I have running without issue. I use CDOSYS with my own server mail.cjwsoft.com which has proper MX records set up.

I would also try to determine the difference between blocking and spam/junk email filtering. It is impoirtant to truly know what is going on.
Sometimes adding more information to the body of the emails going out will eliminate the junk mail filters from gettings the emails.

Then you have the various open relay lists that places like AOL use. If your email server or IP sending the email is on those lists for spamming you do not stand a chance. That is all out of the hands of the ASP code.

,

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,

All of the fields with the expected paths show the correct file structure, so now I've put them in them in the boxes

,

Thanks, I really appreciate you working on this. The software works GREAT and the support you give can't be beat. I will definately tell other that are looking for software for their sites to check your first.

 

one more question.

To use the bulk upload feature of aspuload, do I just need to add another upload section to the same upload page, that will allow more than one file to be selected then tell it to put the files in as Photo 1, 2, 3 etc.? I am a rookie at ASP but I think this is possible and with a little research I should be able to get it going.

Just want to make sure I am on the right track.

Thanks

, You can not edit that code with dreamweaver. It will re-arrange the asp and kill it.
If you want to change the look of the login html you have to edit the html by hand in a text editor.

Or create what you want on a blank page using your editor of choice and carefully use parts of that in the ASPProtect code.

In version 7 the login screen is one asp page by itself and is much easier to edit with just about any editor. In version 6 you have to know your html and be careful.

Either way I am not sure templates are a good idea for something like that. That sort of thing tends to cause problems with dynamic code that executes under different directory levels. You want to stick to regular html techniques. ,

The file check_user_inc.asp as the lines: (which include Session("groups")

 Here we set some valus about the user into session variables
   Session("PasswordAccess") = "Yes"
   Session("Access_Level") = CmdCheckUser("Access_Level")
   Session("Admin") = CmdCheckUser("Admin")
   Session("Active") = CmdCheckUser("Active")
   Session("Expiration_Date") = Expiration_Date
   Session("User_ID") = CmdCheckUser("User_ID")
   Session("Groups") = CmdCheckUser("Groups")
   Session("Redirection_URL") = CmdCheckUser("Redirection_URL")
   Session("Password") = RC4(CmdCheckUser("Password"), PasswordEncryptionKey)
   Session("Username") = CmdCheckUser("Username")

,

Is there a way to protect other virtual sites on the server that are not under the default web site considering people may have different websites running off one server?  I get the following error:

Parser Error Message: Cannot use a leading .. to exit above the top directory.

Source Error:

Line 1:  <%@ Register TagPrefix="aspprotect" TagName="checkaccess" Src="../../protectpage.ascx" %> 
Line 2:  <aspprotect:checkaccess level="4" groups="null" runat="server"></aspprotect:checkaccess>
Line 3:  

Thanks!

 

 

,


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

Driving to Ogdensburg. 30 miles, comp time....son graduation from kindergarten, getting settled into watertown, Back home, fix emonitor so that it doesnt freak out., sma2, Started printing finished files, Traffic Reports, Called back people from my voice-mail : Knowltons re: printing, Sackets Harbor brewing company re: IShare, Bernier & Carr re: tranlating their Bell bill., Called users back, did a few signups, and took calls. , NEXTCOM.COM DEVELOP HOMEPAGE GRAPHICS, meeting at air brake, Meet with Tim Badour, Carol Thomas, Paul Barton, BARTER-study requirements/W3C development for Burlington P&R development spec, Setting up new domains, maintaining other domains., stuffed and sealed, Improving UPS Calculator component for storefronts because we found out that when UPS server is down we needed more error handling code., ti.com rest. review db & upload component. (worked at home), shasta, ST. LAWRENCE COUNTY FINISHING UP DETAILS ON SITE, Working with Amy and Randy to figure out who gets mail addressed to softmls@gogisco.net, GiSCO - Knowltons, installed windows 2000 on a tech machine., sub at Jreck's, *TaskForce, TIIC Chamber Access, researching pdf to forms, for web sales contracts, memorandum of engagement, and contracts... homepage redesign - banner advertising..., IP Management database development, Fixing Lafargeville Central School database to work with second quarter grades only. Contacting Jacki to let her know its ready., SoftMLS.. Still redoing the code for the realtor.com export system... also trying to get it running in Visual Basic so I can make an ".exe" that I can then schedule to run on the server every day.... sent the export files for all 3 boards to realtor.com to check out... havent heard back from them yet as to whether they are ok or not... I am also still waiting for the ipix guy to get back to me.... I am going to Have Kelly try to contact them as well since I am getting nowhere,

   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 search engine active server page asp application components tutorial 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