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

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



Blog Entry: 3/25/2006 4:56:22 PM

This is a great article from my old powerasp.com site.
Connections And Server Database Permissions

 

cwilliams38084.7458217593,

ahhh ok.. I was going to wait till morning to answer this one..

glad ya figured it out

 

,



if that account isnt there thats normal because if it doesn't have any permissions for that folder so it wouldnt be listed

you simply dig into the menus a liitle deaper and find it then add it.

cwilliams38417.6984606481,

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.

, on that particular page check the session variables manually (not using the include)

that way you are keeping the login access checking to an absolute minimum, elminating any form processing from the login procedure, and keeping the upload script happy

like so

<%
If Not InStr(Session("Groups"),"*1*") Then
    ' do whatever
End If
%>

you could response.write something followed by a response.end

or you might even want to response.redirect them to some other page that using the "check_user_inc.asp" where they can log in

And if you are going to be using a free asp upload script use this one as it is probably the best pure code upload solution available as far as performance goes.

http://www.freeaspupload.net
,

Sorry, not really.. not without a lot of changes to the code.
the recent activity info recycles.. it is not meant to be day by day

My suggestion there would be to look at both the log files and the user activty screens...

,

Dear Christofer

I already have send you the details you asked me for. Please let me know if you have received

,

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.

  • ,

    That is by design, removing and deleting are two different things as far as the classifieds system goes.

    A regular user can only remove an ad from the category index. (which makes the ad inactive)

    An admin however can truly delete an ad from the system.

    , still.. its got to be somthing along those lines.. I have seen times when even dbo didnt have full rights to a particular database so permissions should always be manually checked..

    The import data routine is most likely the source of the trouble

    For troubleshooting sake I would create a fresh installation from scratch using the sql script we provide and a new SQL user. Then see if that works. If it does then try to import your data into that.

    There are no other things I can think of doing. Sometimes you just have to start with a clean slate. ,

    Chris,

    I understand.  I set it to a lower number that will hopefully be a good balance for the user.  I am simply AMAZED at what your software does and I thank you for all you have done.

    Jess

    , site looks fine in ie and also firefox from a windows machine..

    I dont have a mac and I have not heard of that browser before

    Sounds like an issue with the way that browser handles and puts together html/flash in relation to the layout of your site which is fairly complex

    less likely - could also be related to computer processor/resources as that is a decent sized flash file and could bog down certain machines on the client level.. internet connection as well ?

    those are my guesses.. I dont see anything wrong from windows xp web browsing from a fast machine and on broadband.. looks pretty nice actually , look in the "check_user_inc.asp" file

    try editing this part by hard coding the body info you want to use

     Response.Write("<BODY" & Application("BodyTagInfo") & ">")


    I would also suggest reviewing the generated source code in the web browser and examining the html to figure out exactly where the body tag info you dont want is coming from
    , The way the application works is one separate installation and database is required for each (IIS Application).... not only is it a licensing thing but it is also the nature of (forms based authentication) because every application in IIS has it's own set of application and session variables and they can not be shared with other various IIS applications.

    That being said if you plan to run a separate install for each web/IIS application buying new licenses is fine

    If you want to run one installation and database and share that with other web.IIS applications it is not technically possible.

    Each web/IIS application requires a seperate install of ASPProtect.NET,

    I apologize if I've missed this, but I would love to see the ability to auto-e-mail the advertiser at some randomly set interval before the banner expires. Ideally, I would also be cc'd on this e-mail so I can stay in touch. If the advertiser wants to renew, I can receive payment and change the expiration date without their banner ever falling out of service.

    Since e-mail is already built into the program, would it be difficult to add a routine that checks for expiring banners at some daily interval, and contacts the advertiser?

    To get really fancy, the e-mail could include the ability for me to add a button for paypal, allowing the advertiser to easily click and send off another payment.

    Best,

    Wayne

    , Even if I try to upload the test file that was included with the system I still get the same error.

    My host is using Windows 2003 Server.

    Will send you a private email to see if the issues can be sorted out.

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

    , 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 , We have no add-ons for anything but accepting payments through paypal and 2checkout... if you want to accept payments through some other setup you have make a payment directory addon and write code to do it based on the system you are using..

    We provide the ASP source code so that is doable for someone that is good with ASP. If not then it won't be doable.
    ,

    ok, that probably means the physical path you have set for the logfile directory (in the admin settings area) is not correc t

    the error pretty much means just what it says

     

     

    ,

    Flash files cannot track clicks unless you edit the original flash file to link to the aspbanner system redirect URL.. feeding it the correct ID of the banner.

    When that link is clicked on it will then track the click and redirect the user to the “link url” specified for that banner. 

    The system actually generates the necessary ASPBanner URL for you. That link is shown on the banner edit screen.(you must save the banner at least once and come back to that screen to see the link though) 

    Really the best way to show it is with an example as seen below.



    Basically the flash banner file "powerasp.swf" highlighted in green needs to be edited to link to the banner redirect url which is highlighted in red.... the banner redirect url will then track the click and ultimately send the user to the Link_URL highligthed in blue.

    All banners systems work this way when it comes to flash files.
    It’s the nature of flash and the web browser, 

    The flash source code must be edited to link to the redirect url in the ASPBanner system. There is no possible way any banner system can track a flash click unless the flash file links to the banner system 1st.... because that click is handled by Flash and the web browser. 

    In some cases if you do have the original source file for the flash banner then you are out of luck as far as tracking clicks goes.



    On a side note... if you create flash banners the way this article says you can actually feed a .swf flash file a link for it to click to. Instead of it being hardcoded.

    http://www.macromedia.com/resources/richmedia/tracking/desig ners_guide/index.html

    This is really the way everyone should design their flash banners from now on because the url it links to can be easily changed at any time without editing the flash file source code. 

    cwilliams38085.095150463,

    you basically have to edit the html in the links in the various pages and remove them... some are in includes files

    use a text editor and be causious / back things up before you remove links so you can revert back

    , You may be interested in this. I just put it together real quick like.

    http://support.cjwsoft.com/code/code_info.asp?TID=454&PN =1&TPN=1 ,

    Running in parallel for testing is actually a smart way to do it, but the truth is you don't use anything from version 6 except the upgraded database (we have a tutorial on how to upgrade the database)

    Version 7 was a drastic change /rewrite to all of the asp files that come with the application. So you will be starting out with fresh version 7 ".asp" files and folders... You will also find that once you get version 7 running that editing certain things like the look of the users area and the login screens is much easier to do.

    That being said any of your own ".asp" pages that you protect use the same protection code they always did, so there will be no drastic changes needed there when you do finalize the upgrade.



    If using MSACCESS as the database I suggest installing the application somewhere in your web and using a fresh ASPProtect 7 database. Once you are familiar with the setup and everything is working fine. Attempt the database conversion and when your done stick your converted database in there and see if everything is ok.

    Also, if you already purchased the application download the latest version before doing the install. It's the same download URL. If you don't have it email me and I can hook you up. I have added some new features and fixed a couple minor things since it's release.

    So far the feedback on version 7 has been awesome..

    cwilliams38414.0133680556,

    Everything is running fine.. I can read ads... reply to them. but when I click sign in or register.. I get a server error.

     

    Any suggestions

     

    Thank You

    , The webpage header for CJWSoft  states "Web Development for Win NT/2000 servers" - a little dated cause it works just fine on 2003 too, right? :),

    If a picture does not show after uploading it is one of the following things.

    The upload method chosen is not supported on the server
    or
    The physical path specified to the pictures folder is not correct.
    or
    The URL to the Pictures folder is not correct.
    or
    Permissions to the pictures folder have not been set properly


    Here is more information on how permissions are set.

    http://support.cjwsoft.com/code/moreinfo136-1.htm
    http://support.cjwsoft.com/code/moreinfo56-1.htm

    Without more information and the settings you have entered and chosen that is all I can offer for now.

    ,

    Christopher

    Many Thanks

    Seems like its working just got to test it bit to see, though it wasnt going to work as I had one too many End If's after the last part of the code you done for me. But even I eventually sussed it, nothing to do with your bit just another mistake on my part

    Great to get support like this especially on a Saturday

    regards

    John

    ,

    The company that hosts our business web site has been impossible to deal with in assisting me in getting asp protect to work. Getting the rights set correctly took 6 days and then getting parent paths enabled has been impossible. There last response was simply this:

    The includes were changed so that if your server does not support "parent paths"
    ' and the "../" that you could easily change a few files like this and make the
    ' includes virtual includes instead of file includes. We didnt make them virtual
    ' includes by default because depending on where in your site you put the application
    ' the virtual include path would be different. They are also much different on a local
    ' development server than they would be on your real server
    '
    ' Here are some examples of what you might change these includes to
    '
    ' If you put the aspprotect folder in the root of your domain at your server
    ' example: www.mydomain.com/aspprotect
    ' then you would probably use
    '
    ' #INCLUDE VIRTUAL="/aspprotect/dataconn_inc.asp"
    ' #INCLUDE VIRTUAL="/aspprotect/config_inc.asp"
    ' #INCLUDE VIRTUAL="/aspprotect/scripts/emailing_subs_inc.asp"
    '
    ' Or if you didnt use the aspprotect folder and just put the contents of it in the root
    ' of your domain
    ' then you would probably use
    '
    ' #INCLUDE VIRTUAL="/dataconn_inc.asp"
    ' #INCLUDE VIRTUAL="/config_inc.asp"
    ' #INCLUDE VIRTUAL="/scripts/emailing_subs_inc.asp"
    '
    ' It really all depends on what works for your situation
    ' If you want more information on server side includes read this article at PowerASP
    '
    ' http://www.powerasp.com/content/code-snippets/includes.asp

    I am assuming that they will not enable parent paths and I need to modify some code. I do not know asp. WHere do I modify the code for a server that will not enable parent paths?

    Thanks,

    D

    ,

    Hi - I am a recent user of your software. I administer it for the owner. I probably missed something in your forums somewhere - but I'd like to know how to stop the software from sending an "accept registration" e-mail (after they fill out the registration page) from going out so fast - usually within minutes.  I'd like to know how to defer the message for 24 hours, more or less, so that our company can go over the registration details and decide whether to allow the person registering to actually have access to our protected website pages.  The program is working very well and we are excited about it.  So far, no problems (knock on wood!).

    Thanks so much for your help!

    ,

    Yup, it probably means the virtual directory is not configured as an Application in IIS.

    You did put this in a plain folder in your web, correcct ?
    Not a subweb

    Regarding the application settings for the virtual directory.. if it is your server you set that stuff up in the IIS console.

    If hosted somewhere it is there responsibility to have that set up correctly for you and you need to contact them and ask them what the deal is.

    cwilliams38455.9035300926,

    you have to check the session variables for groups a little differently.. info on that is here

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

    ,

    This is great documentaion for windows script 5.6
    in windows chm file format for jscript and vbscript.

    We use server side vbscript in all our our ASP 3.0 applications so this info can be a lot of help.

    2005-02-18_150921_vbscript_docs.zip


     

    cwilliams38401.6321990741, You are right.
    I have SQL server.
    From August to today I have used a very simple login system and now I come back to you for better.
    I can insert, edit, delete  users but it happens what I mentioned in my first message.
    ,

    It's MS Access, Version 7 (the Full one).

    Anyway, I had inadvertently changed the user_id field type to "number".  When I changed it back to "autonumber", everything went back to normal.

     

    Thanks you very much for your quick reply and sorry to have bothered you.

    ,

    It is refered to as the internet guest account but that isn't the actual username. The username is different for every machine. It usually starts off with "IUSR_" and then your machine name. "Internet Guest Account" is always the account's full name as labeled by IIS when it is installed.

    Regardless,

    If an account isn't listed you have to add it.

    Click (add-advanced-find now) and it will list off all the user accounts on the machine

    You can also click (add-advanced) and simply type in the account name or part of it.

    Some more tips:

    If on a local machine you always just give the "everyone" account full control which is pretty much going to make anything work.

    You can also go to computer management in your server's administrative tools and view all of the accounts  and groups there under "Local Users and Groups".

    cwilliams38417.7186689815,

    Not really sure how to do this.... i think you know what i am looking to do.. is there anyway you can show me or create that solution for me? It would prob. take you minutes as its been taking me hours

    ,

    Different Versions of the Access Database

    Below is a zip file with many alternate versions of the Access Database provided to help with installation and general usage.

    2005-02-20_155310_ASPProtect_Database_Versions.zip

    ASPProtect.mdb is saved as an Access97 database (password "temp")
    ASPProtect_access2000.mdb is saved as and Access 2000 database (password "temp")
    ASPProtect_access2000.mdb is saved as and Access 2002-2003 database (password "temp")
    ASPProtect_access2002_no_password.mdb is saved as and Access 2002-2003 database with no password set on it

    Try to use the newest version as server odbc drivers sometimes have to use the newest version for everything to work correctly. No password version is provided because sometimes there are issues connecting to a database with a password set on it.

    Default username for access databases is of course "admin" but you really dont use that except in the data connection information.

    cwilliams38403.6840277778,

    also.. every once in a while I get some nervous person concerned about security... and the pros and cons of having parent paths enabled.

    etc etc etc

     

    so let me add this bit of info..

    I don’t know what your hosting company will say because it is an iffy topic and those that understand it have a hard time explaining it to someone who doesn't. Also usually the hosting company doesn't have a clue except they heard it was a security risk.

    Here is the low down from someone that really understands it...
    (well, at least I think I do)

    The only real security risks are from YOU and possibly other people hosting on the same server if they have parent paths enabled that is.

    Meaning your site visitors can't possibly do anything with it unless of course you let them upload and run their own asp files to the server.

    Anyway.. if YOU run malicious asp scripts you could potentially attack other sites on the server and look at things you shouldn't. As could other sites on the same server do to you I suppose.

    So, unless you plan on doing that or some other site admin on the server does it to you its not really a concern. Just an advantage in coding abilities.

    If you attack someone elses site on the server or lurk where you shouldnt then you are probably violating your hosting agreement.

    99% of the time everyone gets all nervous over nothing.. half the people nervous about this have sites nobody would ever want to hack anyway.

    Many people with a really important/busy sites are going to have a dedicated server somewhere so the setting is not relevant..

    The hosting companies of course have to warn you.

    This setting was enabled by default for years on IIS4-IIS5. I never once heard one single real story about anyone attacking anything because of this setting. That doesn't mean it doesn't happen but I am just telling you what I know.

    This is all my opinion so take it for what it is...

    If you are a Hosting Company your better off turning it on at the customers request, giving them a warning about it, and in turn having happy customers.

    The big hosting companies like Alentus and MaximumASP do it...

    There are far worse things than this to let people do after all.

    Beleive it or not I have actually been in servers where they gave the anonymous webserver acount modify permissions EVERYWHERE yet they disabled parent paths ????

    cwilliams38391.6024189815, Chris,

    Ok new puzzle. I have now managed to gonfigure it to get the admin screen and update members. All excellent news. Seems to work a treat.

    But have used the code you give in your getting started guide to add at the very top of an aspx page to be protected. The path is configured correctly I am sure. the aspx file is in the root, the protect program is in a folder now configured as an application (hence the steps forward to get to the admin screens) on the root, so address should be foldrname//protectpage.ascx.

    Proble when I load that aspx page is as above. The exact same config error,oww!

    I am sure its a setting on my server now, but I dont know what to ask for, Any ideas...

    So close now!

    Andy
    ,


    Timecard Entry: 3/25/2006 4:56:22 PM

    work on finishing up cleaning etc room , calls, rad, pop, and e-mail. Nothing complicated in terms of calls., Steady morning. , Bus Record, Web siteinfo,search engine registration and frontpage acess, Printing invoices for Al Devoid , incident report, cancellation of invoices, taking sign ups, quality checked sign ups, answering phone, callbacks from voicemail and checked emails. , Meeting about Objectives, to the bank, worked on plans for Adk telecom summitt with jim- returned to clayton- , Meet with Howard (re: Phone company), WWW.BRESEECARS.COM DATA ENTRY-- ADDED CAR REPAIR CONTENT TO BODY SHOP SECTION OF SITE, Golfwithyourbuddies.Com - Completed public and administrative areas for managing and displaying location map listings., phones, invoices, sign ups, Hidden Harbor - Modifications to ad in Vacation Guide, EMAIL AND VM, Entered todays bills, Migrate domains to iMail, Meeting w/ Nortel, cc deposit, RadLog, Answered phones, talked to Jim for a little bit., CREG stock transfer tax, Vermont web billing /mailed, meeting with Michael Cronin re:CubPro.com, Rotary meeting- reviewed wireless and dsl with Rotarians, Reports at home, then travel then hooked computer up to the network at Clayton for more reports, Chrispin showing me ''data junction'' databsae conversion utilities., SoftMLS white papers background info., TICC building grand opening,

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

    Active Server Pages asp search engine active server page asp application components tutorial CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspclassifieds.com, www.powerasp.com,www.cjwsoft.com,www.aspphotogallery.com,www.codewanker.com,www.aspprotect.com,www.aspbanner.com