Home | Advertising Info164 USERS CURRENTLY ONLINE   
   Site Search Contact Us Tuesday, July 08, 2008  

Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components CJWSoft ASPProtect ASPBanner ASPClassifieds

Blog News Main Page

NEWS FROM 2006-03-25



Blog Entry: 3/25/2006 2:22:15 PM

All fixed... I changed the remote server from localhost.omegaphibeta.net or whatever it said there to localhost

I sent a test email to myself and got it no problem

the error you were getting was email component related ,

I have ASPProtect up and running and I was able to log in with little to now problem after following all of the directions. 

I imported my data base of users (approx 5300) into the access db, and now it times out just letting me log in.

I've got full access to the web server to make any changes on that end that I need.

any ideas?

 

,



Microsoft has a free version of SQL server 2000 than you can run on a development machine.


http://www.microsoft.com/downloads/details.aspx?FamilyID=413 744d1-a0bc-479f-bafa-e4b278eb9147&DisplayLang=en

This is really the same thing as the MSDN version of SQL server that comes with Visual Studio

It is limited in two ways.

  • No single database can exceed 2 gigabytes in size. However, each Desktop Engine server instance can contain many databases, each of which can be up to 2 gigabytes in size. Each computer can host up to sixteen instances of Desktop Engine.

  • Performance will rapidly decline when more than five simultaneous users use the database engine at the same time. With five users or less Desktop Engine will operate with full SQL Server speed.

    After you install this your going to need a way to connect to your sql server as well as a way to run queires on it.

    I suggest either install the client tools off any SQL 2000 Installation Disc (giving you enterprise manager and query manager)

    or use the FREE SQL Server Web Data Administrator which will do amost everything you  will need to do. It is really very slick
    http://support.cjwsoft.com/forum/forum_posts.asp?TID=127& ; ; ;PN=1

    Then you have a pretty sweet setup for testing and developing locally using SQL server.

    If you are wondering why someone with a real SQL Server 2000 cd wouldn't just install the real SQL server locally it is because the server part will usually not install on XP Pro or non server versions of windows for licensing reasons. (at least every SQL 2000 CD I have is like that regardless of whether it is standard or enterprise) But the client side tools on the cd are invaluable so I just install the Desktop Version of SQL along with the client side tools and everything works great.

  • ,

    Not sure because of the nature of the javascript method

     

    for starters tighten up the html around the banner call

     

    change

     

    <tr>
    <td width="460" height="60" align="center" valign="middle" class="imagead">
    <!------- ASPBanner Ad code ------------->
    <script language="JavaScript">
    var code = '';
    var now = new Date();
    var nIndex = now.getTime();
    document.write('<s' + 'cript src=" http://www.nababaseball.com/aspbannernet/aspbanner/injectban ner.aspx?BannerZone=1&nocache=' + nIndex + '">');
    document.write('</' + 's' + 'cript>');
    </script>
    <script language="JavaScript">document.write(jscode);</script >

    </td>

     

    to

     

    <tr>
    <td width="460" height="60" align="center" valign="middle" class="imagead">
    <script language="JavaScript">
    var code = '';
    var now = new Date();
    var nIndex = now.getTime();
    document.write('<s' + 'cript src=" http://www.nababaseball.com/aspbannernet/aspbanner/injectban ner.aspx?BannerZone=1&nocache=' + nIndex + '">');
    document.write('</' + 's' + 'cript>');
    </script>
    <script language="JavaScript">document.write(jscode);</script >
    </td>

     

     

    If that doesn't help I would suggest using the ASP 3.0 version of ASPBanner. It can serve banners to a any type of page extension and it runs just as well as the .NET version. There is a new iframe method for calling banners that you can try instead of the javascript. The iframe method is explained in the ASPBanner Unlimited section of the forum.

    cwilliams38150.6443634259,

    you not seeing the real error

    http://support.cjwsoft.com/forum/forum_posts.asp?TID=11& PN=1

    ,

    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.

    ,

    SQL Server Datareader Datawriter Permissions..

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

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

    cwilliams38390.5986921296,

    I am getting closer.

     

    This error actually does not have anything to do with the forgotten password feature or your database.

     

    It has to do with the settings you chose for emailing.

    it relates to aspmail and it not liking the remotehost you used, or something like that.... etc etc

    ,

    I have imported like 50,000 users into an access database when testing... it took like 4-5 minutes but worked..

    course it really all depends on the setup how many you can get away with

    something must still be wrong

    have you tried just importing 1 or 2 users for troubleshooting sake ?

    I would also recommend that after any timeout you reboot the server or at the very least do an "iisreset" to get things back to normal

    ,

    lets get back to using the forum and not the pm's  please only use the PM's for sensative information. its too hard for me to keep track of all of this as well as help everything else when I got an inbox full of pm's

    Ok, so you say no paypal subscription info is being put in the database at all.

    I know we have a bunch of people using the paypal subscription code with no issues so I know it works but obviously you got something wrong.

    It could be a few things.

    Did you enable IPN in the paypal system and put in a postback url like my directions say ?

    Are you sure you are not getting paypal single payments and paypal subscriptions mixed up ?

    Are the paypal links you made for paypal subscriptions in the correct format like are directions state ? That is critical and another example of something important that you have not shown me.

    Did you populate all settings correctly for our paypal subscription code ?
    This includes a correct and valid postback url because if that is not right paypal cant communicate with the aspprotect system and no info will get posted back from them at all.

    You say your upgrade went well but if you did all all field names perfectly there could be issues with that.

    There is just way too much for me to figure out under free support with the info you keep providing me.

    I dont think we are going to get anywhere unless I go into your system and spend a considerable amount of time checking everything out. That is not something I do under normal support so if you are interested it is going to involve a fee paid via paypal. It's probably going to take me a while to check everything out and I need you to be 100% sure IPM is enabled in your PayPal account. If you are not sure how to turn it on search their help system as they have plenty of documentation on the process.

    ,

    check permissions for the user you are connecting to the SQL database.
    http://support.cjwsoft.com/code/moreinfo122-1.htm

    That user may not have permission to make new data

    Also,  check all field and table settings manually by comparing them to the SQL creation script we provide. You may very well be missing auto increment and primary keys which would make adding new data not work.

    It is most likely one of those two things.

    , OK, so I misread the instructions. Wouldn't have been the first time that happened...  but I just had an account get created, guy then paid, and... no activation. I had to go in the next day and do that by hand. What should I do to look for troubleshooting on the issue? I've got all the default directories set up and all the files where they should be. What next? ,

    Hi,

    I am just wondering if anyone else has had this problem. Even though the guestbook is empty, it takes just about 20 to 30 seconds for the guestbook/default.asp lto oad. Is this normal has anyone else has had this problem.

    Thanks

    , its in this thread.. you use the InStr function
    http://support.cjwsoft.com/code/code_info.asp?TID=17&KW= instr

    Please use a little bit more descriptive subject the next time you post. "question" does not tell much to someone looking through threads.. and I like to keep things clean and organized in the forums

    I edited it for you this time..

    thx ,

    Using "Email Authentication" as a registration option you cannot do that. There is no possible way I know of to have a delay on the authentication email like that. Also that method is not intended to involve any sort of manual registration like what you are doing.

    Because you want to review people manually you need to change to registration process to "manual" and then send the email out manually from the users screen after making a user active.

    ,

    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

     

     

    , yes, any page you want protected needs to be edited..

    You can probably have a login box on a non protected page. Just copy the generated source html form code for the login box of a protected page. Then put it on your non-protected page, but change the action to the page you want them to log in to.

    In other words go to a protected page. See the login box, view the html browser source and use that to make your login form on the main page.

    I have not tried it with .NET but I am pretty sure you can do it since it pretty much works the same as the classic asp version of ASPProtect.

    try it.. see if it works.. If I have time tommoro I will test it out., 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 , Yes, that worked... , yes, like it says it is expirimental

    turn it off.. the banner system will run just as fast for the most part

    or leave it on and an occasional user will see a permission denied error where a banner will be,

    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 just added this line to the paypal1.asp page

    <input type="hidden" name="currency_code" value="CAD">

    and it worked.  Clearly other values can be entered for other currencies.  Everything was listed in this manual https://www.paypal.com/en_US/pdf/subscriptions.pdf.


    Cheers
    Roy


     
    ,

     

    grrrrrr

    As far as the users thing... my fault that was setup wrong in the settings of the admin login page.

    but still dont have a solution for what im trying to do

    ,

    [QUOTE=cwilliams]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. [/QUOTE]

    First off, I haven't imported anything from MS Access.. The only reason I mentioned it is cuz I thought initially it worked with Access and not SQL server.

    I am not converting nor entering any data manually into the db, nor have I changed anything in the way the registration is made (don't know where the "Old password" has come from? thought it was a function you made?)

    ,

    Understood.... can you point me to a place where there are other methods of calling banners?  Do you mean not use Flash?  I am new to this and will need some pushing over the cliff!

     

    Thanks

    Dave

    , Just installed sofware everything works fine except I see no way to upload any photos.  There is no reference or link to allow an upload on any of the asp pages (I have surfed them all).  I am sure it is something simple, but I am not aware.  I am using SQL2000.,

    hello,

    There is no built in option. You would have to add code to do that.
    Its not difficult but custimization like that is not something I support.

    , ok, now were getting somewhere

    I didn't know you imported from another system,

    chances are you are missing field information that an ASPProtect user requires.

    Start off from scratch with a new aspprotect database... create a new user and look at the info that gets entered by default for every field in the database

    make sure when you import a user that you mimic it all

    dont import directly using access because the passwords will not get converted to encrypted versions of themselves correctly.. and the whole process will be usesless as no passwords will be correct

    Use the import feature built into ASPProtect.. because it is smart enough to take the clear text passwords and encrypt them accordingly

    if you want to know a correctly formatted import file needs to look like make one and check it out

    do one user at a time and make sure you can log in to an example protected page till you get it right...

    once you get that working do them all

    Thats really the best advice I can give you. ,

    Yeah, its a win2k server.

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

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

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

    , like I mentioned are you by chance running something like Norton Antivirus Script Blocking ?? That can cause timeouts and all sorts of problems with ASP as can other software like it. ,

    <%@ LANGUAGE="VBSCRIPT" %>
    <!--#INCLUDE FILE="check_user_inc.asp"-->
     
    <%
        Response.Write(Session("Groups"))
    %>

    , I have ASPPhotoGallery installed. Everything has been working great for some time. Suddenly, for no apparent reason, I am not getting the "Hits" incremented when a user opens an album. It works when an administrator is logged on. Does not for any anonymous users. Everything else seems to work fine. Again, this used to work. Any ideas. ,

    If you bought ASPBanner Unlimited Version 7.3 Before August/10/2004 this file needs to be updated.

    It fixes a bug where the JavaScript method is not properlly closing an html Image tag. It can cause other hyperlinks on your web page to link to the same place the banner links to. This does not always happen but this fix is the way the code should be so it is best to update it.

    Copy this file into your ASPBanner folder over the existing file of the same name.

    2004-08-10_125304_injectbanner.zip

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

    I had both ASP Listings & Classified on the same website.  The categories seem to be getting mixed up. I removed ASP Classified but classfieds categories is still appearing in the student of ASP Listing.

    How do I fix this?

    Thanks

    , I believe that solved the problem as I have not heard from this person since I sent him the code.,

    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,

    Well, thats not normal.
    (it should work just like our online demo does)

    Do you have everything turned on in the settings ?

    Uploading needs to be enabled and you also have to pick a valid upload method.

    ,

    Hello,

     I need some help with the following code. Please look at the area in red. I need to be able to set someting up to where the variable eval1 (a yes/no field in my database) is set to false after the associated link is pressed.

    Thank you

    ="vbscript" %>
    <!--#INCLUDE virtual="/irp/check_user_inc.asp"-->
    <html>

    <head>
    <title>Administrator Evaluations</title>
    <style>
    <!--
     div.MsoNormal
     {mso-style-parent:"";
     margin-bottom:.0001pt;
     font-size:12.0pt;
     font-family:"Times New Roman";
     margin-left:0in; margin-right:0in; margin-top:0in}
    -->
    </style>
    </head>

    <body background="../images/1.gif" bgcolor="#C0B59A" vlink="#FF0000" alink="#FF0000" link="#0000FF">

    <p><map name="FPMap1">
    <area href="http://www.utb.edu/" shape="rect" coords="627, 66, 670, 81"></map>
    <span lang="en-us">&nbsp;&nbsp;&nbsp;&nbsp;& ; ; ; ;nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;& ; ; ; ;nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;& ; ; ; ;nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;& ; ; ; ;nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;& ; ; ; ;nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;& ; ; ; ;nbsp;
    </span>
    <img border="0" src="https://blue.utb.edu/irp/Inst-Research&Plan.jpg" usemap="#FPMap1" width="675" height="82"><br>
    &nbsp;</p>
    <h2 align="center"><span lang="en-us">Administrator Evaluations</span></h2>
    <p align="center">&nbsp;</p>
    <p align="left"><span lang="en-us">&nbsp;<b>Welcome,&nbsp; </b>  </span> <b> <% Response.Write(Session("FIRST_NAME")) %>
    </b>
    </p>
    <p align="left"><b><span lang="en-us">On this page, you will see a list of names
    that represent the persons that you will be evaluating this year.
    Please click on a name to select that persons evaluation form. Once you have completed
    and submitted that persons evaluation, you will be returned back to this page to
    continue with the next person on your list. Once you have completed all your
    evaluations, you can log off the system using the link below.</span></b></p>
    <p align="left"><b><span lang="en-us">Please note: Only <u>1</u> submission per
    person will be accepted, any additional submissions will not be accepted.</span></b></p>
    <p align="left"><span lang="en-us"><b>If you have any questions please feel free
    to contact us at the number below.</b></span></p>
    <hr color="#FF9933" width="80%" size="3">
    <p align="center"><span lang="en-us"><b>Please click on a name below to begin
    the evaluation process.</b></span></p>
    <div align="center">
    <table>
             
           <%If Session("Link1_Name") <> "" Then %>
        <table border="1" width="28%" id="table1" bordercolor="#000080">
      <tr><td bgcolor="#FFFFCC" style="float: left">&nbsp;  <b><span lang="en-us">&nbsp;<a href="https://<% Response.Write(Session("Link1"))%>" onclick="<%=Session("eval1")="true"%>;return true" </href>  <font color="#000000"><span style="text-decoration: none"><%Response.Write(Session("Link1_Name"))%>< /span></font></a></span> </td>
      </tr>
      <%End If%>  
           
       
      <%If Session("Link2_Name") <> "" Then %>
      <table border="1" width="28%" id="table1" bordercolor="#000080">
      <tr>
      <td bgcolor="#FFFFCC" style="float: left">&nbsp;  <b><span lang="en-us">&nbsp;<a href="https://<% Response.Write(Session("Link2"))%>" </href><font color="#000000"><span style="text-decoration: none"><%Response.Write(Session("Link2_Name"))%>< /span></font></a></span></td>
      </tr>
      <%End If%>
     
      
      
      <%If Session("Link3_Name") <> "" Then %>
            <table border="1" width="28%" id="table1" bordercolor="#000080">
      <tr>
       <td bgcolor="#FFFFCC" style="float: left">&nbsp;  <b><span lang="en-us">&nbsp;<a href="https://<% Response.Write(Session("Link3"))%>" </href><font color="#000000"><span style="text-decoration: none"><%Response.Write(Session("Link3_Name"))%>< /span></font></a></span></td>
      </tr>
      <%End If%>
      
     
    POST EDITED / SOME CODE REMOVED TO KEEP IT SHORTER .. 
    This went to Link3_Name
        
        
     
    </table>
    <p>&nbsp;</p>
    <p><span lang="en-us"><b>If you have completed all your evaluations and wish to
    log out please click <a href="log_off.asp">here.</a></b></span> </p>
    <p>&nbsp;</div>
    <div class="MsoNormal" align="center" style="text-align:center">
     <hr size="3" width="80%" noshade color="#ff9933" align="center"></div>
    <p align="center" style="text-align:center"><b>Institutional Research and Planning
    <br>
    Tandy 270<br>
    80 Fort Brown<br>
    Brownsville, TX 78520</b></p>
    <p align="center" style="text-align:center"><b>Phone: 956-544-8816&nbsp;&nbsp;&nbsp;&nbsp;&nbs p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    Fax: 956-983-7652<br>
    E-Mail:
    <a style="color: blue; text-decoration: underline; text-underline: single" href="mailto:iresearch@utb.edu?subject=Administrators%20Evaluation">
    iresearch@utb.edu</a></b></p>

     

    ,

    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

    ,


    Timecard Entry: 3/25/2006 2:22:15 PM

    INTERNET MARKETING RESEARCH, check voice mail-email- go over info with jsaon for meetig with defereit, Working on the schema code that I started yesterday. It is coming along pretty well though I still have to figure out some more stuff about it. I also have to go over field structure with dave and organize all of that crap. There are like 2000 fields and we have to organize them all in a n intelligent way that makes sense., working on contact management module for use in Autoresponder system for SoftMLS, E-mail, To Watertown - 70 miles, emails other, including mainatince and responding to ppl ... called shangli about her call firday finding out when she has power to start she wants someone there working with her, teched calls and 4911 was giving RNA, Daylight Savings Time, Helped a customer that brought in a laptop to get it working with his AOL connection. , Took tech calls, e-mailed an AUAQ, monitored RAD, DUI, and AUAQ, checked Voice mail. Left early because I wasn't feeling good., On phone w/Nicky at Remington. They are having a problem w/pricing options in storefront. Problem was they are inserting commas into price fields., Training at Jamestown, Trouble MS Access issues for Matt, emails and callbacks on soon to expire accounts. Some billing issues. Cancels, signups., Weekly Report - Set Up, Not very busy... worked on a customer computer... took calls... usuall disconnectiuon and busy calls., DEFERRIET PAPER WEBSITE DEVELOPMENT MADE ADJUSTMENTS AND CORRECTIONS(NON-BILLABLE), prep for meeting, Timecard system clean-up, meet with Ben Brannan, mostly just a couple long calls, and couple others, lunch, phone calls with darrell, Posted accounts and did a detail of checks and cash for a bank deposit. Customer inquiries, credit card authorization. coupon referrals, and ans. phone. Worked on problem children., had a couple ziplink customers that were upset. helped a few users that were getting disconnected, timecards to date; filing, Entered payroll and MBO in QB, fix ns2.imcnet.net, needed to be reset , Working Lunch Tara,

       Active Server Pages Rule The World
    Contact Us  
    All artwork, design & content contained in this site are Copyright © 1998 - 2008 PowerASP.com and Christopher J. Williams
    Banner ads ,other site logos, etc are copyright of their respective companies.
    STATS Unless otherwise noted - All Rights Reserved.

    Active Server Pages what is asp programming how to sample asp example code scripts software asp forum mail sessions applications global.asa CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspclassifieds.com, www.powerasp.com,www.cjwsoft.com,www.aspphotogallery.com,www.codewanker.com,www.aspprotect.com,www.aspbanner.com