Active Server Pages Blog News 1993-09-30

Home | Advertising Info

70 USERS CURRENTLY ONLINE

Site Search Contact Us

Friday, March 14, 2025

Code Snippets
Hints & Tips
Code Wizards
Guestbook
Newsletter
Forums
Links

DISCUSSION ARCHIVES
DISCUSSION ARCHIVES 2
DISCUSSION ARCHIVES 3
BLOG

We didn't realize
the site was so popular.

Other Stuff

Active Server Pages help tutorial how to ASP Help ASP Tutorials ASP Programming ASP Code - ASP Free CJWSoft ASPProtect ASPBanner ASPClassifieds

Blog Entry: 3/25/2006 4:57:26 PM

I used Dreamweaver4 to make my site is there anything I can do to make it work?

I wonder what that ENDSQLMail send failure is all about ?
I dont use anything regarding SQLMAIL in the ASPProtect code.

I think I might need to go in so I can debug a bit. Everything seems to work fine with a SQL installation here so I just don't know at the moment.

If that is ok with you I would need ftp access or something so I can trry a few things and hopefully figure it out. Admin access to the aspprotect admin area as well so I can see what you have set up in there.

PM me with that info if you want me to take a look.

works fine now

Hi,

I have just one quick question, I know this works with Paypal but does this work with Merchant Account?

How difficult it is to make it workable with Merchant account? I appreciate your answer.

Thanks.

(Password Expiration Mod) for ASPProtect Version 7.x

This Advanced Mod requires decent knowledge of Databases and working with ASP. I originally wrote something like this for a customer on a custom project. I then took the time to re-write all the code from scratch so it could easily be plugged in to the current version of ASPProtect as an option. All in all this mod took me over 15 hours of time to develop and will save you a ton of time & money if you were planning on writing something like this on your own. Some parts of this were so difficult to get working that I would never have written this code if I was not paid to do so. (The encrypted array that rotates through the last 12 passwords was quite frustrating to get working)

The price on this is 19.95. I am not incorporating this into the base product because it makes things more complicated and isn't for everyone.

Purchase Page

Security is a big concern and making your users change their password every so often is a good idea. Keeping track of previous passwords they used and making them choose something they haven't used before takes the concept even further.

This Mod will add a password expiration date to the application. When the password expiration date is hit the user must confirm their old password as well as pick a new one before they can log in again.

There is a new password expiration directory where they must choose a new password that has not been used before. The new password must be confirmed during this process. (It remembers 12 old passwords the way it is coded) The old passwords are stored in the database in an encrypted array.

Directions:
Back up your existing ASPProtect installation.

Add two new fields to the "ASPP_Users" table in your database.

For an MSAccess Database

Password_Expiration_Date (Date_Time Field)
PreviousPasswords (Memo Field)

For a MSSQL Database

Password_Expiration_Date (smalldatetime)
PreviousPasswords (nvarchar 160 characters)

once that is done

Copy all the new ".asp" pages into your site.

Edit the "PasswordExpirationURL" variable in the "check_user_inc.asp" file

It needs to be the full URL to to the "change_password/default.asp" file

Now edit the "change_password/processchange.asp" file

There are 3 variables you can edit.

PageSentToAfter = "http://localhost/aspprotectmods/password_admin/default.asp"
PassMinLength = 4
PassMaxLength = 8

The "PageSentToAfter" is where you want them sent to after they change the password. It can be whatever you like.
If it is a protected page they should automatically get logged in with the new password they just changed to which is nice.

The other two values should be obvious.

That's it...

Just remember the password change thing is not used in the admin area...
You could easily add code for that on your own though by looking at the the password expiration code I added to the publics "check_user_inc.asp" file

Also:
You will see a new field to edit on the user edit screen for the Password Expiration of course.

Is it possible to set the user account time limits when they register? I am using email verification and am trying to have their accout expire 32 days after their initial login.

Also I have an issue with the email notification not notifying me when a new user logs in. It does a beautiful job notifying the new user. I do not understand why my server will send to one and not the other, I ahve searched the links but none seem to answer this.

Thank you for your help and insight

Let me put it this way.

My home page (default.asp) is an unprotected page.

When a user that has signed in on another (protected pages) and has the remember me checkbox checked closes the browser cookies should be set for the next time they return.

When the user opens their browser and returns to my home page (default.asp), I'd like to put a message saying:
Welcome back <%Session ("Username")%>

How is this done?

, Awesome -thanks - I'll give it a try ,

Anyone have any experience configuring PhotoGallery to use a backend mySQL database?

The application connects successfully for Read operations, but no amount of troubleshooting can get it to Write records to the tables.

http://www.marc-lisa.com/photos/default.asp

here is a thread that may help you if this is what you were getting at

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

I have purchased ASPProtect to secure a web site that I administor for a soccer league. I am having a hard time getting the code to execute. the instructions are to include this code at the top of the web page under the Language identifier. Like this I think:

<%@ LANGUAGE="VBSCRIPT" %>

<% GROUPACCESS = "4" %>

However, nothing happens. I am not sure if I am missing something.

FYI: the "Check_user_inc.asp" file is in the root directory of the site which is actually two levels down on the d: drive of the server.
The web page code is located below.

Any help is greatly appreciated.

<html>
<head>
<title>TeamManagers</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#006600">
<div id="Layer1" style="position:absolute; left:125px; top:109px; width:682px; height:597px; z-index:1">
<table width="655" border="1" name="teambios" bgcolor="#FFFFFF" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF" height="312">
 <tr bordercolor="#006600">
 <td bgcolor="#006600" width="154" height="33">Division
 1</td>
 <td bgcolor="#006600" width="160" height="33">Division
 2</td>
 <td bgcolor="#006600" width="148" height="33">Division
 3</td>
 </tr>
 <tr>
 <td width="154" height="26"> </td>
 <td width="160" height="26"> </td>
 <td width="148" height="26"> </td>
 </tr>
 <tr>
 <td width="154" height="26"><a href="/TeamManagers/BHawks/BHawks_search.htm">Black
 Hawks</a></td>
 <td width="160" height="26"><a href="/TeamManagers/Gunners/TFC_search.htm">Gunners</a ></td>
 <td width="148" height="26"><a href="/TeamManagers/InterFC/InterFC_search.htm">Inter
 FC </a></td>
 </tr>
 <tr>
 <td width="154" height="26"><img src="/Images/clearpixel.gif" width="1" height="1"><a href="/TeamManagers/DCove/DCove_search.htm">Deep
 Cove Brewers</a></td >
 <td width="160" height="29" valign="top"><a href="/TeamManagers/NSReds/NSReds_search.htm">North
 Shore Reds</a></td>
 <td width="148" height="26"><img src="/Images/clearpixel.gif" width="1" height="1"><a href="/TeamManagers/BFC%20Blackhawks/BFC_search.htm">LV
 BFC Blackhawks</a>< /td>
 </tr>
 <tr>
 <td width="154" valign="top" height="28"><a href="/TeamManagers/FatBoys/FatBoys_search.htm">Fat
 Boys</a></td>
 <td width="160" valign="top" height="28"> <a href="/TeamManagers/NSIndians/NSIndians_search.htm">Squam ish
 Nation United</a></td>
 <td width="148" valign="top" height="28"><a href="/TeamManagers/NSYoungGuns/NSYoungGuns_search.htm">N orth
 Shore Young Guns</a> </td>
 </tr>
 <tr>
 <td width="154" valign="top" height="29"><a href="/TeamManagers/LEI/LEI_search.htm">LEIFC</a>&l t;/font></td>
 <td width="160" valign="top" height="29"><a href="/TeamManagers/UFK/UFK_search.htm">UFK
 United</a></td>
 <td width="148" valign="top" height="29"><a href="/TeamManagers/Saints/Saints_search.htm">Northland
 Saints</a></b&g t;</td>
 </tr>
 <tr>
 <td width="160" height="27" valign="top"><a href="/TeamManagers/Lightning/Lightning_search.htm">Light ning</a></td>
 <td width="160" height="27" valign="top"><a href="/holding/UFK/UFK_search.htm">
 </a><a href="/TeamManagers/Warriors/Warriors_search.htm">Warrior s</a></td>
 <td width="148" height="29" valign="top"><a href="/TeamManagers/SoccerCityFC/SoccerCityFC_search.htm"> ;Soccer
 City FC</a> </td>
 </tr>
 <tr>
 <td width="154" valign="top" height="27"> <a href="/TeamManagers/QCHawks/QCHawks_search.htm">Q.C.
 Hawks</a></td>
 <td width="160" valign="top" height="27"> </td>
 <td width="148" valign="top" height="27"> <a href="/holding/Cougars/Cougars_search.htm">
 </a></td>
 </tr>
 <tr>
 <td width="154" valign="top" height="32"><a href="/TeamManagers/OdlumBrownFC/OdlumBrownFC_search.htm"> ;Odlum
 Brown </a></td>
 <td width="160" valign="top" height="32"> </td>
 <td width="148" valign="top" height="32"> ;</td>
 </tr>
 <tr valign="top">
 <td width="154" height="27"><a href="/TeamManagers/WestwardFC/WestwardFC_search.htm">Wes tward
 Utd F.C.</a></td>
 <td width="160" height="27"> </td>
 <td width="148" height="27"></td>
 </tr>
</table>
<table width="655" border="1" name="teambios" bgcolor="#FFFFFF" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF" height="289" bordercolor="#000000">
 <tr bordercolor="#006600">
 <td bgcolor="#006600" height="29" colspan="2"> Over
 30's Division A</td>
 <td bgcolor="#006600" width="349" height="29" colspan="2"> Over
 30's Division B</td>
 </tr>
 <tr>
 <td height="15" colspan="2"><img src="/Images/clearpixel.gif" width="1" height="1"></td>
 <td width="349" height="15" colspan="2"><img src="/Images/clearpixel.gif" width="1" height="1"></td>
 </tr>
 <tr>
 <td valign="top" colspan="2" height="31"><a href="/TeamManagers/BBear/BBear_search.htm">Villa
 Roma FC</a></td>
 <td width="349" valign="top" colspan="2" height="31"><a href="/TeamManagers/Comrades/Comrades_search.htm">Comrade s</a></td>
 </tr>
 <tr>
 <td valign="top" colspan="2" height="30"><a href="/TeamManagers/JESpurs/JESpurs_search.htm">Maplewood
 Spurs</a></td>
 <td width="349" valign="top" colspan="2" height="31"><a href="/TeamManagers/NS%20Chiefs/NSChiefs_search.htm">NS
 Chiefs </a></td>
 </tr>
 <tr>
 <td height="29" valign="top" colspan="2"><a href="/TeamManagers/NSRangers/NSRangers_search.htm">N.S.
 Rangers</a></td>
 <td width="349" valign="top" colspan="2" height="30"><a href="/TeamManagers/SVikings/SVikings_search.htm">Screami ng
 Vikings </a></td>
 </tr>
 <tr>
 <td height="29" valign="top" colspan="2"><a href="/TeamManagers/RGullStrikers/RGullStrikers_search.htm"& gt;Rusty
 Gull Strikers</a></td>
 <td width="349" height="29" valign="top" colspan="2"><a href="/TeamManagers/Spareboy/Spareboy_search.htm">Sparebo y</a></td>
 </tr>
 <tr>
 <td colspan="2" valign="top" height="32"> <a href="/TeamManagers/Shysters/Shysters_search.htm">Shyster s</a></td>
 <td colspan="2" valign="top" height="32" width="349"> <a href="/TeamManagers/Titans/Titans_search.htm">Titans</ a></td>
 </tr>
 <tr>
 <td valign="top" colspan="2" height="30"><a href="/TeamManagers/Wanderers/Wanderers_search.htm">Wande rers</a></td>
 <td width="349" valign="top" colspan="2" height="30"><a href="/TeamManagers/VeniceFC/VeniceFC_search.htm">Venice
 F.C.</a></td>
 </tr>
 <tr valign="top">
 <td height="30" colspan="2"> </td>
 <td width="349" height="30" colspan="2"> </td>
 </tr>
</table>
<h1>Suspended Player Information</h1>
<table width="650" border="0" height="71">
 <tr>
 <td width="157" height="45"> </td>
 <td width="148" height="45"> </td>
 <td width="171" height="45"> </td>
 <td width="157" height="45"> </td>
 </tr>
 <tr>
 <td width="157" height="30"> </td>
 <td width="148" height="30"> </td>
 <td width="171" height="30"> </td>
 <td width="157" height="30"> </td>
 </tr>
 <tr>
 <td width="157" height="30"> </td>
 <td width="148" height="30"> </td>
 <td width="171" height="30"> </td>
 <td width="157" height="30"> </td>
 </tr>
 <tr>
 <td width="157" height="30"> </td>
 <td width="148" height="30"> </td>
 <td width="171" height="30"> </td>
 <td width="157" height="30"> </td>
 </tr>
 <tr>
 <td width="157" height="30"> </td>
 <td width="148" height="30"> </td>
 <td width="171" height="30"> </td>
 <td width="157" height="30"> </td>
 </tr>
 <tr>
 <td width="157" height="30"> </td>
 <td width="148" height="30"> </td>
 <td width="171" height="30"> </td>
 <td width="157" height="30"> </td>
 </tr>
 <tr>
 <td width="157" height="30"> </td>
 <td width="148" height="30"> </td>
 <td width="171" height="30"> </td>
 <td width="157" height="30"> </td>
 </tr>
 <tr>
 <td width="157" height="30"> </td>
 <td width="148" height="30"> </td>
 <td width="171" height="30"> </td>
 <td width="157" height="30"> </td>
 </tr>
 <tr>
 <td width="157" height="30"> </td>
 <td width="148" height="30"> </td>
 <td width="171" height="30"> </td>
 <td width="157" height="30"> </td>
 </tr>
 <tr>
 <td width="157" height="30"> </td>
 <td width="148" height="30"> </td>
 <td width="171" height="30"> </td>
 <td width="157" height="30"> </td>
 </tr>
 <tr>
 <td width="157" height="30"> </td>
 <td width="148" height="30"> </td>
 <td width="171" height="30"> </td>
 <td width="157" height="30"> </td>
 </tr>
 <tr>
 <td width="157" height="30"> </td>
 <td width="148" height="30"> </td>
 <td width="171" height="30"> </td>
 <td width="157" height="30"> </td>
 </tr>
</table>
 
</div>
<img src="/Images/ateammanag.png" width="235" height="46"><img src="/Images/MILLERS5.gif" width="410" height="53">
<img src="/Images/Millersmenu5.gif" width="90" height="25">

<a href="/index.html"><img src="/Images/buttonhome.gif" width="93" height="20" border="0"></a>
<a href="/newLeagueInfo.html"><img src="/Images/button1.gif" width="93" height="29" border="0"></a>
<a href="/Schedule/SchedulesMain.asp"><img src="/Images/button2.gif" width="93" height="20" border="0"></a>
<a href="/newFields.html"><img src="/Images/button5.gif" width="93" height="29" border="0"></a>
<a href="/newTeamContacts.html"><img src="/Images/button6.gif" width="93" height="29" border="0"></a>
<a href="/newTeamInfo.html"><img src="/Images/button7.gif" width="93" height="29" border="0"></a>
<a href="/TeamRosters/newTeamRoster.html"><img src="/Images/teamrosterbtn.png" width="93" height="29" border="0"></a>
<a href="/newStandings.html"><img src="/Images/button3.gif" width="93" height="20" border="0"></a>
<a href="/Stats/stats_input.asp"><img src="/Images/playerstatbutton.png" width="93" height="29" border="0"></a>
<a href="/newTeammangers.html"><img src="/Images/Managerbutton.png" width="93" height="29" border="0"></a>
<a href="/newAdministrators.html"><img src="/Images/adminbutton.png" width="93" height="29" border="0"></a>
<a href="/newRefs.html"><img src="/Images/refereebutton.png" width="93" height="29" border="0"></a>
<a href="/newLinks.html"><img src="/Images/soccerlinks.gif" width="86" height="25" border="0"></a>
 
 
</body>
</html>

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

, 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, After you click the link in the confirmation e-mail you are directed to the Thank you page. Right above is a sign in link. When I click this I get that funky error message.

I am trying to integrate the scripts with the look of my site, if that is what you mean by changing things around too much. But, I don't think I have done anything out of the ordinary.

Cheers,
Roy
, Aggh.. I put passwords instead of password. Sorry to have bothered you, works fine now. ,

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.

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

Regards

Andy
,

I would kile to see more support for the groups function:

1. on the password_admin/default.asp page have a coulmn listing groups

2. ability to change groups in bulk eg change the expiry date for all group x members

Cheers

The only other thing I can think of if you are not getting any errors.

Is that you may have the path to the server include file correct but ASP server side code is not executing in that part of your web site.

You can do a simple test to tell if it is...

Make a simple ".asp" page in the same folder.

Put only this code in it.

<% Response.Write ("ASP is executing") %>

then run the page via the web browser thru the server..

If the text prints out ASP is running... if you don't see anything it is not

cwilliams38229.5820486111, that is good news... good guess on my part I guess

anyway, try this for your latest issue.

http://support.cjwsoft.com/code/code_info.asp?TID=340&KW =%2D1, If you are developing using Windows 2003 Server and running the NTFS file system setting proper permissions on a folder in your website is done like so.

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

Right click on that folder and then choose the "security" tab.

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

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

Other things to note:

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

In some cases you may want to go into the advanced tab and check both checkboxes shown in order to make sure the permissions you need get set. It really all depends on the situation.

cwilliams38342.7343981481,

IFRAME is just an client side html thing...

has nothing to do with .NET

will work with any page extension or server side technology

As you see from that compatibilty chart I posted a link to.
Nearly every modern browser supports it.

cwilliams38155.4462847222, okay thanks, And here is an even simpler version where the database name is hardcoded and the User_ID is set ahead of time from wherever you are getting it from

'User_ID = CmdListUsers("User_ID") ' getting it from another database query
User_ID = Request("User_ID") ' getting it from the page post

SELECT COUNT(Album_ID) AS Alb_Count FROM Albums WHERE User_ID = " & User_ID & " AND Album_Active = 1" cwilliams38433.0595949074,

After understanding how the count works i checked the IP in the db. They are all set to the same IP (my web server) no matter what ip is doing the viewing. This is probably due to my ISA2004 firewall that is posting the ip address of the web server with each log on. So, can you help me with where the code would be to modify so the db does not get updated? I risk the refresh problem, don't think it is an issue with me.

Thanks,

Connecting user is dbo of database.

User_ID is primary key with auto increment identity.

SQL Script of current table:
CREATE TABLE [dbo].[Security_Users] (
[User_ID] [int] IDENTITY (1, 1) NOT NULL ,
[First_Name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Last_Name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Company_Name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Username] [nvarchar] (75) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Password] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Access_Level] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Notes] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Admin] [bit] NOT NULL ,
[Active] [bit] NOT NULL ,
[Expiration_Date] [smalldatetime] NULL ,
[Email] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Address] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[City] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[State_Province] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Zipcode_Postal_Code] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Phone] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Counter] [int] NULL ,
[Last_Access] [smalldatetime] NULL ,
[Login_Limit] [int] NULL ,
[Custom1] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Custom2] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Custom3] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Custom4] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Custom5] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Custom6] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ValidateEmailCode] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Date_Created] [datetime] NULL ,
[Validated] [bit] NOT NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Security_Users] WITH NOCHECK ADD
CONSTRAINT [PK_Security_Users] PRIMARY KEY CLUSTERED
(
[User_ID]
) ON [PRIMARY]
GO

, download the free version...

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

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

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

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

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

As an alternate scenario...

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

If you change this bit of code in that file

from

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

to

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

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

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

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

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

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

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

Hello,

As I have my site hosted by a web hosting company (1and1.com), I want to make sure the ASP Photo Gallery software runs correctly before I buy. I am not sure about whether or not they support parent paths because I can find nothing in the online faqs. But, I have two other ASP apps (Forum and News from Web Wiz) running on the site, both connecting to Access databases. I remember having problems initially setting these up because I kept trying to use paths like ../db/wwforum.mdb like I would normally do when referencing images or pages in other folders.

Anyway, here are the database connection strings for the two apps. The first is for the Forum, which is at /forum/common.asp connecting to a database in /db/wwForum.mdb. The second is for the News, at /news/common.asp accessing /db/news.mdb.

'Virtual path to database
strDbPathAndName = Server.MapPath("/db/wwForum.mdb")

'Database connection info and driver
strCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/db/news.mdb")

Thanks for your help, hopefully I'll be setting up my new galleries this weekend!

- Jason

, I moved the password check file out of /user and am getting this message:

Microsoft VBScript compilation error '800a0400'

Expected statement

/asplog/check_user_inc.asp, line 404

End If
^

Is this a standard database connection error so I should ask my IIS to make sure permissions are correct?

Thanks..!

its just an example connection string in the datacon_inc.asp file
you have the edit it to make sense for you..

the readme.txt file with the sql directions tells you this if you use that script

------------------------------------------------------
Examples of using DSN-LESS connections.

The "SERVER" and "Data Source" settings are either the Network Name for the SQL Server or the IP Address.
For local servers you can also use an IP of "127.0.0.1"

GalleryConnectionString = "Driver={SQL Server};UID=aspphotogalleryuser;password=temp;DATABASE=aspph otogallery;SERVER=127.0.0.1"

GalleryConnectionString = "Provider=sqloledb;Data Source=127.0.0.1;Initial Catalog=aspphotogallery;User Id=aspphotogalleryuser;Password=temp;"
------------------------------------------------------

cwilliams38325.8980324074,

I have narrowed it down. The ../ for includes will not work with .asp files but will work in .shtml files.

any ideas?

If you want to have a login form on a non protected page that posts
to a protected ".asp" page use code like this.

Change the action of the form to the page you want them to log into.
Make sure to page you send them to is protected by the "check_user_inc.asp" file.

<center>
<table border="0" width="400" height="200" bgcolor="#000000">
 <tr>
 <td bgcolor="#F4F4F4">
 <form method="POST" action="memberarea.asp">
 <input type="hidden" name="Status" value="Checkem">
 ASPProtect Login
 <div align="center">
 <center>
 <table border="0" bgcolor="#C0C0C0">
 <tr>
 <td bgcolor="#EBEBEB">Username</stro ng></td>
 <td><input type="text" name="Username" size="10"></td>
 </tr>
 <tr>
 <td bgcolor="#EBEBEB">Password</stro ng></td>
 <td><input type="Password" name="Password" size="10"></td>
 </tr>
 <tr>
 <td bgcolor="#EBEBEB" colspan="2"><input type="checkbox" name="KEEPMESIGNEDIN" value="True">Keep
 me signed in on this computer unless I log off.</td>
 </tr>
 </table>
 </center>
 </div>
 <div align="center">
 <center>
  <input type="submit" value="Login">
 </center>
 </div>

 </form>
 </td>
 </tr>
</table>
</center>

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

Thanks very much for the quick reply.

That sets my mind at ease

I was just worried if users would see warnings in their firewall software too.

I realize that the admin would have to have to go through some errors...

And since we are throwing things in here... Definately, if you have your own server you need a Hardware Firewall and a Managed one at that. The internet can be pretty dangerous for business if you don't.

Plus, I agree Black Ice although in it's heyday a few years ago was considered great. It is not suitable for todays standards alone even for the normal user (But, it is required by the company I work with for VPN. I think it's stupid too using old technology. I have 2 more firewalls setup besides that just so that I do have some security. And, that's just for my PC)...

Thanks

Yup everything looks ok - but why no error?

This just gets better - now the email a friend link says sent successfully and doesn't send out - what the heck...

What would cause it to 'think' it is doing the task yet still fail?

Chris.

After I had you install ASPProtect I added the ASP protecting code to the top of my home page:

<%@ LANGUAGE="VBSCRIPT" %>

<% CHECKFOR = "1" %>

Then I made my index.html page my login page buy using the script "Login form on a non protected page" on that I changed <form method="POST" action="memberarea.asp"> to <form method="POST" action="home.html">.

When I try to log on to that page I get en error page HTTP Error 405 - The HTTP verb used to access this page is not allowed. Internet Information Services (IIS). I checked with my hosting company GoDaddy.com and they informed me that due to the fact that they do not have ASPProtect instaled on there systems they can not support it. In recent conversations you told me that you have customers that do use godaddy and you products.

Can you please tell me what I can do to get this working?

Thank you for your time and help.

, Hey CJWSoft,
We're helping out some clients of ours in a server transfer and we really need some assistance from you guys. We've got everything transfered and running, except for the ASP.NET banner. Do you have any directions on how to go about moving the install from one server to another? We've sent a couple emails through the site but haven't gotten any responses back.

Please help.

-Tony Valenti

,

I have just started to move my sites to a new dedicated Windows 2003 box. I have parent paths enabled, SSI turned on but I still can't get ../ to work with server side includes. Everything I read online says that I need to turn on parent paths but again, they are already turned on.

The hosting company where the server is located can't tell me anything, they just say that that is the way it is with Windows 2003. I don't buy it!

Can anyone tell me anything on this issue to help enable the ../ for serverside includes?

Well. fontpage publishing is evil. That you have found out.

Do not use it. It usually wont work right when running asp code locally and also at the server because of differences with the paths and virtual directory structure. etc etc etc

You can definetly use frontpage to connect to the web site live and drag and drop files into it/edit them... but the sooner you stop using the publishing feature the better off you will be.

Version 7 uses.. RC4

The upgrade process is described here in detail including a procedure to convert existing clear text passwords to the encrypted versions. (Your passwords will need to be clear text as the system shipped of course for the conversion to do its thing)

http://support.cjwsoft.com/code/info24.htm

It is also covered in the downloadbale docs
http://support.cjwsoft.com/code/moreinfo221-1.htm

Many people have done the upgrade without any issues and Version 7 is getting great feedback.

Should you decide to go with it there is upgrade pricing.
http://www.aspprotect.com/purchase_v7_upgrade_pricing.asp

Timecard Entry: 3/25/2006 4:57:26 PM

worked with Cathy on the deposit details and ran the tapes and got everything ready for Jackie to just take to the bank, Called banks about the PC bundle program, Traveling to Vermont for task foce meetings, Marketing, Cleaned Office space, Channel Mareting brochure,, to hogansburg 100 miles, learning Dynamic Link in GoLive, Lunch, wwnytv.net/72k - Publish latest work to web for review. Notification of updates to Jim Corbin & CB. Start ''Automatic Polling System''. (trade), Post office and filing and finally distributed the mail for today, Admin (emails and organize), LEARN THE ABILITIES OF ATOMZ SEARCH ENGINE TO BE ADDED TO SAMARITAN.. INDEXED SITE AND PROGRAMMED SPECIAL PAGE FOR ATOMZ SERVER RESULTS ONLY BILL 2 HOURS TO SAMARITAN FOR THIS JOB MOST OF IT WAS LEARNING THE ABILITIES OF THE ENGINE AND IMPLEMENTATION TECHNIQUES, lunch, TRAVELED BACK TO WATERTOWN, email, email, Reading CLEC handbook, Training Nortel Access Node, same as above, Commissions, vehicle allowances, tax deposits, funds needed , cancels-quick trip to the post office, presentation, Met with Robby, Cathy, Jodi about MBO's., Picnic, Meetings with Paul, Driving to Burlington., Set up office space and worked on Insurance files, E-mail, Sent out bills and statements-quickbooks, Email/Newsgroups, Kelly Svcs,

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 ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET 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