Blog Entry: 3/25/2006 1:42:04 PM
I get this error, Any ideas?
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
/guestbook/save.asp, line 109
, thanks for posting this... Since "private" is the default setting from what I read and setting it to "public" cured the issue chances are leaving it at "public" is the way to go.
http://msdn.microsoft.com/library/default.asp?url=/library/e n-us/iissdk/html/33f2780a-eee8-4601-84b7-b489e4c756df.asp
http://www.w3schools.com/asp/prop_cachecontrol.asp
ALSO: since you are one the few people that has ever contributed anything helpful to the forums I am going to reward you with a free copy of the password expiration mod. I am sending you a PM with the download info.
,
Are you aware ASP can run on any machine running win95/95,2000,xp pro, 2003. You really should test all asp code locally before running it on live servers but anyway... that is your deal
I am not sure if memory alone will be enough for that server but it could help. I saw a decent amount of free memory when I looked. Its just about an 8-10 year old system on every aspect (processer,OS,Hard drives, memory etc etc) and not only that something is tasking the heck out of the resources left over for asp database access. Something is just wrong. I don't know what it is but I am pretty sure it is not aspprotect. I got rid of my last nt 4 server about 4-5 years ago but the application always ran great on NT and I still have some customers using NT 4. Not many though.
if you email me the import file and the encryption keys you are using I will make a database for you.. just zip it up and send it to chris-cjwsoft.com
replace - with @ , its no different than linking to an image or another page. you have to adjust the path to the include file based on what directory you are in.. or you get an error
This is noted in the admin area on the code generator page which also gives you 2 examples of ways of calling the server side include. (Virtual or File include)
These threads below are also full of info. I found them by doing a quick search and they should help you out as well.
http://support.cjwsoft.com/code/code_info.asp?TID=349&KW =The+include+file
http://support.cjwsoft.com/code/code_info.asp?TID=303&KW =The+include+file
http://support.cjwsoft.com/code/code_info.asp?TID=236&KW =The+include+file , Hello,
Yes, that is how it works. Unless you make modifications to the code there is no way to easily do what you are talking about.
If you design the site to be intelligent that scenario should never happen.
For example.. you should only be offering links to pages that the current logged in user has access to. You do this by checking the session variables and with simple if-else logic around your html links.
It requires some work but if you dont give them links to pages they dont have access to what you are talking about will not happen.
Here are some simple examples.
Here is an example using access levels.
<%
If Session("Access_Level") = "1" Then
' show links to pages that allow access level 1
End If
%>
And one for groups..
<%
If Instr(Session("Groups"),"*6*") or Instr(Session("Groups"),"*7*") Then
' show links to pages that allow groups 6 and 7
End If
%>
cwilliams38354.0786921296, All this being said installing the desktop version of SQL may be a little tricky as it may complain that your SA account needs a strict password.
The solution is to run the SQL Desktop setup.exe with some parameters specifying a password for the SA account.
So you go to the command prompt or make a shortcut to the setup file and run something like this
setup.exe SAPWD="YourPassword"
minus the quotes...
I got that info from this article and it worked fine
http://www.experts-exchange.com/Databases/Q_21036508.html
The other thing to remember is it might take a reboot to actually see the SQL server icon running in the taskbar. You may also need to go into the administrative services and enable the "SQLSERVERAGENT" as well as set its startup type to "automatic"
And a reboot here and there..
Whammo... your in business...
, I am out of the server now and I have to get up early to help friends pour concrete in a huge building in 20-30 degree weather (woo hoo)
So I am going to take a break on this until later tommoro.
In the mean time try connecting to the access database with no password on it as well as the access 97 version that I put in the data folder... and see if it runs any faster...screens like the user screen should load fast... not after 15 seconds of waiting like they seem to be doing right now
If none of that helps which it probably wont I can set up the database for you here including the importing later tommoro when I am done pouring concrete
, 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, I checked the SQL table and had 1 banner with no zone ID. I added it in
directly through the SQL interface and now it seems to be ok., The main users screen... the 1st screen you see when you go to the admin area.. where you email an individual user..
The settings I am referring to being the various emailing settings on the settings screen, The settings you showed me.
As for emailing via a remote server over dsl. It may not be working because the ISP's block the port (25) to stop people from running email servers over their dsl.
Your POP3 works because POP3 uses port 110.
If you want to send emails from your local server on your dsl you should probably install the SMTP service of IIS if you have not and send emails using that with CDOSYS. Either that or get a commerical DSL account with a static IP that allows for running email servers.
, 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.
, actually, passwords can be up to 75 characters long in ASPProtect.
the only requirement when entered from a non admin user is that they are at least 4 characters long.
what does MSAccess have to do with this ? Are you trying to convert and old system or something? I noticed you created and "old password" field in there ? Is there something I do not know about as far as what you are trying to do?
Passwords in version 7 are encrypted so I hope you understand all of that and realize you can not enter or change passwords right from SQL server. Also if you import info you must handle that accordingly and convert the passwords to encrypted format for the new version., If you are using version 6 CDOSYS is not supported. That is one reason why version 7 came out. If you want to rewrite the code to work with CDOSYS in version 6 that is something you need to sort out on your own as I do not support custimization to the code.
, The login page sends the user to redirect.asp (which is as follows)
<%@ LANGUAGE="VBSCRIPT" %>
<!--#INCLUDE FILE="check_user_inc.asp"-->
<%
If InStr(Session("Groups"),"*1*") Then
Response.Redirect("gp01.asp")
End If
%>
<%
If InStr(Session("Groups"),"*2*") Then
Response.Redirect("gp02.asp")
End If
%>
I am not being redirected to gp02.asp if I am a member of group2. Also, we wish users who are part of group 2 and 3 to go to a different page (ie. gp2-3.asp)
Thanks in advance.
, Chris-
That appears to have fixed it!!! Thanks alot for your patience, I will never question your brilliance (or customer service) again! Where do I write you a smashing review?
Thanks!
, 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.
, It is common when testing a site that this happens because of the nature of session variables.
Admins have access to EVERYTHING so it is very important when testing different user accounts that you specifically log out... and then close every single browser window before logging in as a different user. This is to ensure session info from the previous user does not overlap in any areas.
(The session variable for admin access being the main one)
Under normal circumstances a user would not log in with many different accounts on the same computer this this would only be a problem for a developer who is testing.
So make sure you go to the to log-off page and log off.. then close all browser windows.. then test another user.
If all this is not the case then something else is going on and I will need more information. I pretty much know the level checking code for ASPProtect Version 6 is correct as there has been no reason to change any of it in over a year. I would have heard reports of problems with it. , When using the ASPProtect admin panel. My firewall software is going crazy or Blocking it on the Mass E-Mail, Newsletter, and other pages.
Here are some of the messages:
[Unauthorized Access Attempt] This signatures detects an attempt by a web server to deliver a malicious HTML page to a browser client, in an
[Suspicious Activity] This signature detects HTML documents attempting to spoof a link destination in the browser's status bar.
I am using Black Ice...
Will users also get this kind of activity from the pages ??? Or is it only because of using the Admin Interface of the software ???
Thanks
, I guess i am not being clear as to what i am trying to do. As far as the event thing... lets hold off on that for now. It seems Chris has answered my question and i am on my own for that one...
As far as the log in goes: I went to that site you mentioned;www.CafePress.com to see if they had what i was talking about. and they do. Notice on the bottom of the page it says "sign in to your account"
I want that option on my home page where users can sign in to go to their account. It will either take them to a page where they can update their info, or it will take them to a protected page. Pretty much instead of posting a link on the site to say... click here to go to members.aspx and have it return an "access denied" the user can enter their info from the main page and be automatically re-directed to that members.aspx page.
I know how the viewstate works and i also know what that returnURL thing does..pretty self-explanitory.
Hopefully that makes things easier. I just want a user to log in from the homepage and be redirected to either a protected page or their account page...
(as does that cafepress website)
, I have multiple zone banners displayed on a single page using the AspHTTP Component Method.
However, in IE 6.x and NS 7.x each banner has some text displayed before it similar to:
HTTP/1.1 200 OK Server: Microsoft-IIS/5.0 Date: Fri, 17 Sep 2004 07:15:12 GMT MicrosoftOfficeWebServer: 5.0_Pub Connection: Keep-Alive Content-Length: 229 Content-Type: text/html Set-Cookie: ASPSESSIONIDAASSDQBA=HAICCGCANEBEPANCDHLHJJGC; path=/ Cache-control: private
This text does not appear when using Netscape 4.x cwilliams38325.741099537, If you makes you feel any better the photo gallery app runs awesome off an access database. Mostly because all of the picture work is done in the filesystem, not the database. The load on the database is relatively low even with a lot of users., who knows, thanks for your input, I am further than I was when I started talking to you!, CDOSYS is the way to go usually...
My article may shed some light on the different ways to send email using CDOSYS
http://www.powerasp.com/content/new/sending_email_cdosys.asp
As for eliminating the registration its pretty much like what you said.. manually remove the links and what not... etc etc and dont send users to the registration pages..
If you dont want people to be able to edit their info ever... or retrieve lost passwords.. you can delete the users folder completely..
though it's probably better to leave some of that stuff and just disable the registration links and page...
The paypal and 2checkout folders can be wiped out completley either way as you won't be using them at all. , Hi
I downloaded the .chm format installation documentation but when I open it I get the index but can't see any of the pages so am a bit stuck.
, sure (XP PRO), see my article on that
http://www.powerasp.com/content/new/windows_xp_pro_and_permi ssions.asp
, 
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" %>
<!-- Begin ASPProtect Code -->
<!-- Groups with access to this page. ( * Admins * ) -->
<% GROUPACCESS = "4" %>
<!--#INCLUDE FILE="check_user_inc.asp"-->
<!-- End ASPProtect Code -->
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"><b><font face="Arial, Helvetica, sans-serif" color="#FFFFFF">Division
1</font></b></td>
<td bgcolor="#006600" width="160" height="33"><b><font face="Arial, Helvetica, sans-serif" color="#FFFFFF">Division
2</font></b></td>
<td bgcolor="#006600" width="148" height="33"><b><font face="Arial, Helvetica, sans-serif" color="#FFFFFF">Division
3</font></b></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"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/BHawks/BHawks_search.htm">Black
Hawks</a></font></b></td>
<td width="160" height="26"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/Gunners/TFC_search.htm">Gunners</a ></font></b></td>
<td width="148" height="26"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/InterFC/InterFC_search.htm">Inter
FC </a></font></b></td>
</tr>
<tr>
<td width="154" height="26"><font face="Arial, Helvetica, sans-serif"><img src="/Images/clearpixel.gif" width="1" height="1"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/DCove/DCove_search.htm">Deep
Cove Brewers</a></font></b></font></td >
<td width="160" height="29" valign="top"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/NSReds/NSReds_search.htm">North
Shore Reds</a></font></b></td>
<td width="148" height="26"><font face="Arial, Helvetica, sans-serif"><img src="/Images/clearpixel.gif" width="1" height="1"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/BFC%20Blackhawks/BFC_search.htm">LV
BFC Blackhawks</a></font></b></font>< /td>
</tr>
<tr>
<td width="154" valign="top" height="28"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/FatBoys/FatBoys_search.htm">Fat
Boys</a></font></b></td>
<td width="160" valign="top" height="28"> <p><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/NSIndians/NSIndians_search.htm">Squam ish
Nation United</a></font></b></p></td>
<td width="148" valign="top" height="28"><b><font face="Arial, Helvetica, sans-serif"><b><font face="Arial, Helvetica, sans-serif"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/NSYoungGuns/NSYoungGuns_search.htm">N orth
Shore Young Guns</a></font></b></font></b> </font></b></td>
</tr>
<tr>
<td width="154" valign="top" height="29"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/LEI/LEI_search.htm">LEIFC</a>&l t;/font></b></td>
<td width="160" valign="top" height="29"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/UFK/UFK_search.htm">UFK
United</a></font></b></td>
<td width="148" valign="top" height="29"><b><font face="Arial, Helvetica, sans-serif"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/Saints/Saints_search.htm">Northland
Saints</a></font></b></font></b&g t;</td>
</tr>
<tr>
<td width="160" height="27" valign="top"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/Lightning/Lightning_search.htm">Light ning</a></font></b></td>
<td width="160" height="27" valign="top"><b><font face="Arial, Helvetica, sans-serif"><a href="/holding/UFK/UFK_search.htm">
</a><a href="/TeamManagers/Warriors/Warriors_search.htm">Warrior s</a></font></b></td>
<td width="148" height="29" valign="top"><b><font face="Arial, Helvetica, sans-serif"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/SoccerCityFC/SoccerCityFC_search.htm"> ;Soccer
City FC</a></font></b> </font></b></td>
</tr>
<tr>
<td width="154" valign="top" height="27"> <p><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/QCHawks/QCHawks_search.htm">Q.C.
Hawks</a></font></b></p></td>
<td width="160" valign="top" height="27"> </td>
<td width="148" valign="top" height="27"> <p><b><font face="Arial, Helvetica, sans-serif"><a href="/holding/Cougars/Cougars_search.htm">
</a></font></b></p></td>
</tr>
<tr>
<td width="154" valign="top" height="32"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/OdlumBrownFC/OdlumBrownFC_search.htm"> ;Odlum
Brown </a></font></b></td>
<td width="160" valign="top" height="32"> </td>
<td width="148" valign="top" height="32"><b><font face="Arial, Helvetica, sans-serif"><b><font face="Arial, Helvetica, sans-serif"></font></b></font></b> ;</td>
</tr>
<tr valign="top">
<td width="154" height="27"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/WestwardFC/WestwardFC_search.htm">Wes tward
Utd F.C.</a></font></b></td>
<td width="160" height="27"> </td>
<td width="148" height="27"><b><font face="Arial, Helvetica, sans-serif"></font></b></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"> <p><b><font face="Arial, Helvetica, sans-serif" color="#FFFFFF">Over
30's Division A</font></b></p></td>
<td bgcolor="#006600" width="349" height="29" colspan="2"> <p><b><font face="Arial, Helvetica, sans-serif" color="#FFFFFF">Over
30's Division B</font></b></p></td>
</tr>
<tr>
<td height="15" colspan="2"><font face="Arial, Helvetica, sans-serif"><img src="/Images/clearpixel.gif" width="1" height="1"></font></td>
<td width="349" height="15" colspan="2"><font face="Arial, Helvetica, sans-serif"><img src="/Images/clearpixel.gif" width="1" height="1"></font></td>
</tr>
<tr>
<td valign="top" colspan="2" height="31"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/BBear/BBear_search.htm">Villa
Roma FC</a></font></b></td>
<td width="349" valign="top" colspan="2" height="31"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/Comrades/Comrades_search.htm">Comrade s</a></font></b></td>
</tr>
<tr>
<td valign="top" colspan="2" height="30"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/JESpurs/JESpurs_search.htm">Maplewood
Spurs</a></font></b></td>
<td width="349" valign="top" colspan="2" height="31"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/NS%20Chiefs/NSChiefs_search.htm">NS
Chiefs </a></font></b></td>
</tr>
<tr>
<td height="29" valign="top" colspan="2"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/NSRangers/NSRangers_search.htm">N.S.
Rangers</a></font></b></td>
<td width="349" valign="top" colspan="2" height="30"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/SVikings/SVikings_search.htm">Screami ng
Vikings </a></font></b></td>
</tr>
<tr>
<td height="29" valign="top" colspan="2"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/RGullStrikers/RGullStrikers_search.htm"& gt;Rusty
Gull Strikers</a></font></b></td>
<td width="349" height="29" valign="top" colspan="2"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/Spareboy/Spareboy_search.htm">Sparebo y</a></font></b></td>
</tr>
<tr>
<td colspan="2" valign="top" height="32"> <p><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/Shysters/Shysters_search.htm">Shyster s</a></font></b></p></td>
<td colspan="2" valign="top" height="32" width="349"> <p><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/Titans/Titans_search.htm">Titans</ a></font></b></p></td>
</tr>
<tr>
<td valign="top" colspan="2" height="30"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/Wanderers/Wanderers_search.htm">Wande rers</a></font></b></td>
<td width="349" valign="top" colspan="2" height="30"><b><font face="Arial, Helvetica, sans-serif"><a href="/TeamManagers/VeniceFC/VeniceFC_search.htm">Venice
F.C.</a></font></b></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>
<p> </p>
</div>
<p><img src="/Images/ateammanag.png" width="235" height="46"><img src="/Images/MILLERS5.gif" width="410" height="53"></p>
<p><img src="/Images/Millersmenu5.gif" width="90" height="25">
<p>
<p><a href="/index.html"><img src="/Images/buttonhome.gif" width="93" height="20" border="0"></a></p>
<p><a href="/newLeagueInfo.html"><img src="/Images/button1.gif" width="93" height="29" border="0"></a></p>
<p><a href="/Schedule/SchedulesMain.asp"><img src="/Images/button2.gif" width="93" height="20" border="0"></a></p>
<p><a href="/newFields.html"><img src="/Images/button5.gif" width="93" height="29" border="0"></a></p>
<p><a href="/newTeamContacts.html"><img src="/Images/button6.gif" width="93" height="29" border="0"></a></p>
<p><a href="/newTeamInfo.html"><img src="/Images/button7.gif" width="93" height="29" border="0"></a></p>
<p><a href="/TeamRosters/newTeamRoster.html"><img src="/Images/teamrosterbtn.png" width="93" height="29" border="0"></a></p>
<p><a href="/newStandings.html"><img src="/Images/button3.gif" width="93" height="20" border="0"></a></p>
<p><a href="/Stats/stats_input.asp"><img src="/Images/playerstatbutton.png" width="93" height="29" border="0"></a></p>
<p><a href="/newTeammangers.html"><img src="/Images/Managerbutton.png" width="93" height="29" border="0"></a></p>
<p><a href="/newAdministrators.html"><img src="/Images/adminbutton.png" width="93" height="29" border="0"></a></p>
<p><a href="/newRefs.html"><img src="/Images/refereebutton.png" width="93" height="29" border="0"></a></p>
<p><a href="/newLinks.html"><img src="/Images/soccerlinks.gif" width="86" height="25" border="0"></a></p>
<p> </p>
<p> </p>
</body>
</html>
, If you code support for it yes, the application comes with no paypal code or support built in.
If you think it will help you, you are welcome to a copy of the classic asp version which supports paypal subscriptions. Perhaps looking at the code would help you.
, Verison 8 is superior in every way and the code is much more optimized so yes I think it would handle it better. It is still a lot of banners on one page though which means a lot of hits to the database if you call them all individually with zone calling code. SQL server would make sense more than MSACCESS.
Now, the only reason I said make one zone for all those banners on the home page is because a banner has to be associated with a zone. It would make sense to put them all in one because if you just tracked the clicks like I mentioned you really wouldnt be using the zone except for maybe when you go to view stats. , I think you may be using old code where that was an issue... I am going to PM you the latest version..
to be safe upgrade all the ASP files except the dataconn_inc.asp files and your config_inc.asp files
"be real careful not to lose your current encryption keys in the "config_inc.asp" file or you will be in real trouble
You can use your existing database
, edited due to inappropriate content
, After a user edit his information (name, email, etc), the session variables are not updated. In the user_area.asp
page, I "Response.Write" all the session variables, and they are still
showing the old information. I tried refreshing the page but to no
avail. The only way to update the display is to log off and login again.
please help.
, That's because when the page rebuilds, it uses the default number of
users per page setting. You'd have to modify that default setting to
have it do things differently. I used to have mine set to 500
users, until I got past 300... then it wasn't fun to show all users on
the page anymore. I now like 10 per page and searching for
specific users as needed.
But that's me. If you hack a COPY of your default.asp file (with the
original backed up as above), you can get the value set to one you
prefer.
If you want me to find the value, post and I'll look for it later on.
If you want to find it yourself, happy hunting! Just be sure to have a
backup in case you do the wrongest thing possible in your haxxoring.
, I do not what is going on at this time. It is not a known issue.
If is is not working it would seem to be a problem with the application variables on the server possibly and your web.
Perhaps try installing it on a local machine and see if it works for testing sake.
Also.. if your stuck with the black skin you could always just edit the information in the that skins folder to get the app looking the way you want.
That and the header and footer files that comes with the app are what control the look of the system.
cwilliams38294.5880208333, Terribly sorry, but we are not software-technical. So can you please tell us exactly which folder the database would be in.
Thanks in advance.
, The links to view that info are on the main users screen of the admin area.
Down below...
They wont show up unless you have that stuff enabled in the settings screen as well.
, YES.. you need to edit your SWF file to link to the aspbanner system...
example.. the link may look something like this
http://banserver.powerasp.com/aspbanner/banner_redirect.asp? Banner_ID=60
of course you need to put in the right information for your site and whatever banner ID it is in your system
Like it says above.. if you save the new banner at least once and then come back to edit that link will be generated for you at the bottom of the edit page.
then when your flash banner is clicked on it will go track the click and then send them to the "link_url" specified for that banner when you edited it.
(you need to enter the final destination url there if you want that to work)
, Chris,
I've given the IUSR account modify access for the aspprotect folder.
In the ODBC manager module on the webserver I've taken out the aspprotect access driver option.
The dataconn_inc.asp line reads as
ConnectionString = "DBQ=D:\missourirealtor.org\members\aspprotect\data\database \ASPProtect_access2002.mdb;Driver={Microsoft Access Driver (*.mdb)};UID=Admin;Password=temp"
Now this should make it DNS-less correct? with the permissions set properly?
I've also taken out the password on the access database.
The original database of users I had was an access database from a different program called spooky login. I exported them into a tab delimited file and changed the column headings to match those in aspprotect exactly. Actually access would not let me import them in the databases without them being exact.
I imported that information directly using access's import options. I tried the import/export manager in aspprotect but kept timing out as well.
, Nope,
No changes to any scripts - just a response.write added to Email_Password.asp to print out the SQL.
Sure - here's the address.
www.omegaphibeta.net/aspprotect/users/Email_Password.asp
-Toni
P.S. E-mail address to look for is serena_5@hotmail.com
, I wouldn't bother doing that. If pic uplading doesn't work it is most likely permissions to the directory pictures are uploaded to. If they are not set correctly it will not work. That dir needs the same permissions the database folder needs. ,
IMPORTANT UPDATE - READ THIS
http://support.cjwsoft.com/forum/forum_posts.asp?TID=205& ;PN=1
The IPN Subscription Pack which is built in to ASPProtect 7 contains all the pre-built scripts you need to implement PayPal IPN Subscriptions with ASPProtect. IPN stands for (Instant Payment Notification). It allows you to set up scripts on your server so whenever a PayPal payment is processed the PayPal server sends info to your server regarding the transaction and vice versa. This is a fully automated process and allows you to charge users for access by the month or however long you like.
The Subscription feature of PayPal handles recurring billing automatically. The PayPal server will communicate with the ASPProtect system and keep everything up to date with users and their subscriptions.
This Support Pack basically gives you an additional signup and registration directory "paypal_sub_signup" and it should not interfere with any changes or customizations you have made to your ASPProtect setup. New users can register in this directory and sign up for a subscription at the same time. Existing users whether active or expired can be sent to this directory where they can lookup their account and start a subscription. You can also assign various Access and Group Levels during signup and you can set up various prices for various amounts of time as well. This is a real-time setup for the most part. As soon as a user pays via PayPal your system is updated and they will have access.
To use this all you need to do in ASPProtect 7 is enter your PayPal account name into the settings screen. It will be an email address. You'll need a business or premier account with PayPal and you will need log into your PayPal account and turn on IPN in you profile. They make you enter a default IPN URL. We do not use that so if you already have something there leave it there. If you dont have something there you can type in any the full url to any page on your server. It's probably best to send it to an empty ".asp" page or something.
Changing Payment Options
In the "paypal1.asp" file there are some sample payment options set up.
They look like this and you can have as many as you like.
<!-- Begin Payment Option Code -->
<form action="https://www.paypal.com/cgi-bin/webscr" method="post" target="_blank">
<% Label = "Membership (1 Month) $9.99 Recurring" %>
<!-- Begin Form Fields You Can Edit.. See PayPal Subscription Manual For Details -->
<input type="hidden" name="no_shipping" value="1">
<input type="hidden" name="no_note" value="1">
<input type="hidden" name="a3" value="9.99">
<input type="hidden" name="p3" value="1">
<input type="hidden" name="t3" value="M">
<input type="hidden" name="src" value="1">
<input type="hidden" name="sra" value="1">
<!-- Field Below must have 2 commas First two values are optional (access level,groups,user ID)-->
<input type="hidden" name="custom" value=",,<% =User_ID %>">
<!-- End Form Fields You Can Edit.. See PayPal Subscription Manual For Details -->
<!--#INCLUDE FILE="form_data_inc.asp"-->
<input type="image" src="https://www.paypal.com/images/x-click-but20.gif" border="0" name="submit" alt="Make payments with PayPal - it's fast, free and secure!">
</form>
<hr>
<!-- End Payment Option Code -->
To really understand what these form values mean it is best to look through the PayPal Subscriptions Manual which is a PDF file you can get from the PayPal Site.
This link was valid the last I checked...
Subscriptions and Recurring Payments Manual
It also may be helpful to use their wizard to create some subscription buttons with different settings and then look at the code generated.
Bascially these are the important ones..
|
a3 - amount to billed each recurrence
t3 - time period (D=days, W=weeks, M=months, Y=years)
p3 - number of time periods between each recurrence |
The custom field is something we are using to send info from ASPProtect to PayPal.
it allows you to set the access_level or groups access (groups support require the ASPProtect Option Pack)
<input type="hidden" name="custom" value=",,<% =User_ID %>">
or this example where we are setting the access_level to (2) and also giving the user access to groups (3 and 4)
<input type="hidden" name="custom" value="2,*3*4*,<% =User_ID %>">
Here is how it works.
The value setting (red) is essentially and array that can be made up 3 elements separated by comma's
access_level,groups,User_ID
If you do not want to set the access_level or groups access.. then you don't even need to edit the setting.
Values must be separated by a comma even if there is no value and there can be no spaces. If you didn't want to set an access level or groups there would still be 2 commas at the beginning. etc etc
Basically there must always be 2 commas but you only have to set last values which is the User_ID from the ASPProtect system.
The 1st value is the access level you want to user assigned to.
The 2nd option is the groups you want the user assigned to. (requires option pack)
The 3rd option is the User_ID which the system takes care of. Do not edit this option. Leave it as <% =User_ID %>
cwilliams38421.7141782407,
Timecard Entry: 3/25/2006 1:42:05 PM
Manning NOC. Resetting open modems. Watching network. Setting up domains., researching paper cutters, Animal Charities- info for web site- register domain name. set up frontpage
Answer email-info for web site
go over ifno with tom
, Did some independant reading before Steve came in, time card- set up calendar for the week, Citec Con., Review CREG documents, Review long distance proposals, commute to wat'n, Wrote down questions on DSL, passport training, Switchboard, billing calls, dial up issues, radlog, , Sick on Friday, Truck in shop., Answered tech related calls. Checked online issues, rad log, and ask a question emails. Emailed and called expiring users., develop artwork and gather supplies for Ken Mills, email/newsgroups, Memorial Day, NYSAR Meeting in Albany, Marketing, teched phone calls, TICC development of letterheads and logos, creating graphic for Carol to use in QuickBooks, sent images to Howard for review..., Jeff Wood - White Mountain Internet., faxed Jeff all the (bcandid) webuser info and did the upstairs inventory, Fixing 8300, helping Ed run some wires learning about the Total Controls from Ed., Travel to WDT, finished server, Worked on High Speed access stuff- spoke to seth about getting contracts, and what leads are currently out- provided pricing for domain name and onther services to superior computers for their Metro paper customer, Updating the live timecard system with new changes and testing timeout feature,
