Home | Advertising Info110 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:27:41 PM

[QUOTE=cwilliams]
something weird is going on
[/QUOTE]

Yeah that's my impression too. I've done a lot of searching before posting this problem, but haven't solved it. Maybe it has to do with the sql-server/hotel?

Though I have compared carefully what goes on (and it should all be good) it could still be the problem? I have now made it work on a local msde sql server too..

,

I have been having some display issues with the .NET version of ASPBanner.  I set the size of the image, and I set the size of the banner and there is still white space above and below the image.  I am not using a text link below the banner, so I have it set to blank.

Here is a link to my page. 

http://www.nababaseball.com

Two of the three banners in the rotation on the main page have non-white backgrounds so it's easy to see the issue I'm talking about.

Is there a way to tighten up the formatting so that the image fits onto the page in the size specified?

JDooley

,



Hallo,

What do I have to do for inserting around 6,000 new users?

I have all my user in an access file. I don't know the password of access database files. The same problem with the "aspprotect upgrade pack".

Sorry for my English

vaghelis38300.2319097222,

Hi,

I did some layout customizing on the register page on my site. ( http://www.lonestaricon.com/aspprotect/paypal_sub_signup/reg ister.asp)

Now when I tried to register, it seems like it goes to the next page, but it is blank.
( http://www.lonestaricon.com/aspprotect/paypal_sub_signup/add _new_account.asp)

If I log in under administration, it shows that I have registered. I can't seem to figure out what part of the code is wrong, so that the new account page will not load.

I'd would greatly appreciate any help with this.

Thanks,

Allison

, Lastly, I put there information here to help, but please don't ask me any questions about it.

I am not microsoft SQL server support. If this doesn't work for you simply start troubleshooting and doing google searches like I do. , I have no idea.. perhaps PM me info on how to log into your site and reproduce the issue., Personally, I think that is something you should work into your existing site code or something you should handle on your own.

It's basic site maintenance issues.. and something every webmaster must deal with on an individual basis. If you are going to upload a new version of some large file of course you should go disable wherever people are dloading it from and then wait/re upload/turn things back on.. etc etc

It is not going to be a feature of ASPProtect and I don't see why it should be. If you want to have some sort of global site is temporaily down thing you should have a common server side include on all your pages right after the password protection include file. In that include file you could easily stop site access with a response.end and also show a message.

Or you should disable a file download page manually on a file to file basis.

Really, big busy sites that have their sh*t together use versions of files for a reason. Every new upload is a slightly new version revision and has a slightly different file name They do this partially to eliminate the problem your talking about and also because that is the way it should be done. Nothing gets uploaded over itself ever. Even if there is a mistake in a file they upload a new revision and document it in the revision/changes file. And of course they dont show users a link to a new file revisions until it is uploaded.
,

((TITLE EDITED BY ADMIN))


it would be nice if there was an option for login abuse, where a login account would be flagged if it logged in from x number of different IPs over a period of time. I know many have dynamic IPs, but there's got to be a balance between legitimate logins and logins that are 'shared' for the sake of saving money (I sell subscriptions), in the end costing me.

Maybe searching the first two number groups in the IP (example, 209.168.*.*), and if finding more than an admin specified number of logins per week from IPs with different first two groups, the record would be flagged or locked...

 

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

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

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

Response.CacheControl = "Public"

right after this line in the code

Response.ContentType = "application/octet-stream"

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

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

Tom

,

Just wanted to let you know that after modifying the remote host string in the email pages and getting the correct connection from my server, everything is running fine.

I hope you enjoyed your vacation.

thank you
adam

,

it's ok

one step at a time and at each step testing things.. then when you mess something up you can figure it out a lot easier

cwilliams38456.1106018519,

works fine now

,

Umm, if your using MSACCESS your using MSACCESS

SQL server has nothing to do with it.

,

Sorry, I forgot about that when I got hung up on the install problem.

 I'll tackle your explanation now to see if I can get it working. Since I already bought the software I'll keep my fingers crossed.

Thanks

, ok, so from your PM Iknow you are using SQL server with IIS5.
You say you created the SQL database using the provided scripts and  that is good.

What is going on may just be a weird odbc issue that sometimes happens on IIS5 when using SQL server and I have an idea on how to remedy it.

Edit the "config_inc.asp" with notepad.

Change

If  Application("SERVER_SOFTWARE") = "" Then
 Application("SERVER_SOFTWARE") = Request.ServerVariables("SERVER_SOFTWARE")
End If


To

Application("SERVER_SOFTWARE") = "iis/6"

And lets see if that helps the situation.

it will change some SQL String query values in the application from "-1" to "1"

either should always work but under certain scenariois only one or the other works, 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? ,

Which page should a user see next after completing a Paypal transaction?  Where do I set that?

Nick

 

, also, just to show you what happens when a user creates a subscription this is the code. you can see in red where the subscrition is is set and also where the exp date is set to null

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

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

,

Christopher,

Thanks for the reply. I think I've found my problem, but can't test until later in the evening as it is on a live site.

Darrell

,

Post a request in the "custom code work" forum.
Perhaps another customer will want to do the work or help you out with some code.

I am just too busy to do any custom work for quite a while.

 

,

ConnectionString = "DBQ=C:\TradersReportsCom\aspprotect\data\database\ASPProtec t_access2002.mdb;Driver={Microsoft Access Driver (*.mdb)};UID=Admin;Password=temp"

I have already set the folder permissions as indicated in the documentation.

,

I uploaded the files designed for an aspprotect folder at the root of my site (mysite.com/aspprotect) and went to mysite.com/password_admin/get_me_in.asp and receive this error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

/aspprotect/scripts/populate_config_variables_inc.asp, line 11

I am assuming my host has still not set rights properly and that is why I receive this error. Am I correct?

 I will definitely recommend hosting company you suggested for our businees site.

,

Hi,

I don't fully understand what you are explaining ... the part about showing a user but not working???? but if you PM me the details I will glady go into your live webserver and see if I can get it working.

,

I noticed that is grabbing the wrong URL for some reason. Even when i mouse over the URL its somehow getting the users sub directory. How.. i dont know... when i erase that users in the url it works perfectly.

I am looking at the code in the .vb file and i dont see anything that could be causing it to do that... but then again i am no programmer LOL

Its obviously kicking in that users subdirectory somehow... what are your thoughts?

,

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'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.

,

 

I am successfully using ASP protect on our site. I have one question:

The file Check_user_inc.asp looks a bit bland as I can't seem to use the sites Dreamweaver template. If I apply a template to this page, it is duplicated on other pages with this template.

How can I apply a template to this page?

Thanks

Clark

 

 

, Just checked XML Parsing with your file. Got a clean bill of health on that: It's working.

Got the right code for the location of the ipn.asp in my paypal1.asp, from http:// all the way to .asp.

I think since everything is set up properly from the looks of things, I'll wait and see. If I get another one who flubs things, then I'll start the testing of the account. But if it goes through just fine, then maybe the Internet just hiccoughed on the first guy... thanks again!


, Awesome -thanks - I'll give it a try  , I have found the alternate databases and they do not work either. I then went back and changed the database path in the asptest page to connect to the 2000 and 2002 test databases and it connected successfully to both of those databases, just as it had successfully connected to the asptest.mdb., sounds like trouble with the SQL database.

Did you create it using the SQL scripts we provide as that is extremely important ? ,

But can you guess as to why the following might be happening:

1) The password is still "temp", and we verified that by checking dataconn_inc.asp ; 2) People are able to place new ads, etc. ; 3) We then download the DB.  Sometimes we are able to open up the DB just downloaded with the password "temp", but only see the USERS table.  At other times, we cannot open the same DB with any password, and get a "password not valid" message even when using the password "temp".

So what can the problem be?

,
 
Don't want to install the application ?
Having trouble doing it ?
Don't think you can ?







No problem, have us install it for you.


PLEASE READ ALL OF THIS

Installation service is generally available Mon - Fri during the hours of 10 am - 7 pm EST.
We may very well be around to do installs at other times but we do not guarantee that.


To do an install we generally need FrontPage Explorer or FTP access to your site.
We also need a way to set permissions on any necessary directories, etc etc.

To do a SQL Server install we need to access your SQL server via Enterprise Manager.

Some installs may require access to other things not mentioned.

The server must be a properly set up NT/2000/2003 server running IIS 4-6 for ASP 3.0 applications.
(with support for ASP scripts and database connectivity.) Parent Paths must be enabled on the server.

Please Note:
These ASP scripts do not run under Chillisoft ASP. That means they do not run under Unix, Linux, Apache, etc etc.
We do not install our applications on free ASP Hosting solutions. Why, because they are more trouble than they are worth. Free hosts like that are usually zero help if we need something changed. There is a reason they are free.

We install the software in it's base configuration. We make sure it is running correctly. If you break the installation you will have to pay to have it fixed. We do not integrate it with your existing site or edit any of your existing web content. That is up to you. Installation fees are non refundable as is the digital source code we sell. When you purchase anything from us you agree to this.

We do not do installs for IPNFulfill and Color Sequence Protection as they are simple scripts and do not even use a database.. We also do not install the IPN Support Pack as it is just a folder you copy into your web and some configuration files that you must decide how to configure based on your needs and your PayPal account info.


Installation Service Pricing
Any CJWSoft ASP 3.0 application
(Access Database Installation)
25.00
Any CJWSoft ASP 3.0 application
(SQL Database Installation)
40.00

Contact us if you have any questions.
cwilliams38165.5615277778,

I'm using the groups protect feature on my pages. None of them seem to close the session after clicking 'logoff'. I can tell because if I hit the back button and return to the group-protected page, hit 'refresh', the page refreshes, I'm not asked to log in again.

On the other hand, when I open a page that's protected by an access level and click 'logoff' (uses same logoff asp file to logoff), it seems to work fine - if I go back a page and refresh, it asks me to log in.

Just wondering - is anybody else having problems like this? Maybe I screwed something up in the few adjustments I made a while back. Any idea what it might be?

,

Nov 2005

,

i've got a client who has handed me a 151 character banner URL, and i see that the database is designed to take 150 characters. i took the obvious step of just increasing the size of that text field in the database, but i still get this error when i try to enter the URL in the proper form field:

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

/banners/aspbanner/save_banner.asp, line 200

now, line 200 is just this:

If Banner_Link_URL = "" THEN
 CmdEditBanner.Fields("Banner_Link_URL") = NULL
Else
 CmdEditBanner.Fields("Banner_Link_URL") = Banner_Link_URL
End If

which tells me that something is blocking the assignment of that long value to that field, even though i believed i had extended the length of that field in the source database.

where else might i look?

 

,

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)

,

Just got back 10 minutes ago..
Missed plane yesterday because of traffic and the flight today was 3 hours plus 4 hours of driving

The fact that you are using Server 2003 is not relevant. I am very familiar with it and all my sites run on it.

The ASPNET account will be there by default once the .NET framework is installed. It won’t just show up in the list, you have to search for it like my article mentions.

http://www.powerasp.com/content/new/windows_2003_server_and_ permissions.asp

That error really means exactly what it says. You have to give that account permissions correctly. ,

Hello,

My guess your having trouble setting up a system dsn because the database has a password set on it. Your hosting company most likely sets up DSNs without using the advanced tab which is where the authentication information goes. Or they have some sort of web interface for the customers to use that doesn’t allow setting up that information.System DSN’s are actually difficult to set up correctly when the database has a password on it. There is of course a password on the database for security reasons so if someone ever downloads it somehow they will not get your information.

System DSN’s are not the way to go regardless as you will see mentioned at our support site.

http://support.cjwsoft.com/forum/forum_posts.asp?TID=9&P N=1

 

You really should try setting up a DSN-less connection. It is the best way to go. They are easier to set up, perform better, and are less load on the server. Any host that wants it customers to use system dsn’s is not on the ball as far as server performance and server resource conservation goes. They are really asking for trouble down the road.

All you need to do to make dsn-less connection is the following.

Get permissions set for the folder the database is in (by your host)… then figure out the physical path on the server to the database by using server.mappath or you simply ask your host for the info.

An article I wrote on using server.mappath

http://www.powerasp.com/content/hintstips/physical-path.asp

Then your connection string will look something like this.. (of course you edit the path to match what server.mappath tells you. And you make sure the database name is correct)

ListingsConnectionString = "DBQ=C:\Inetpub\wwwroot\asplistings\_database\asplistings_ac cess2000.mdb;Driver={Microsoft Access Driver (*.mdb)};UID=Admin;Password=temp"

Another option would be to simply remove the password from the database using MSACCESS.. then try to connect to it using a System DSN without the password. If your host is storing the databases outside of your web in the root of the server then removing the password on the database is not that bad of a thing to do as there is no way anyone will be able to dload it from your site. Of course there is a still a performace loss when using a system dsn with an Access Database

cwilliams38145.8540509259,


Timecard Entry: 3/25/2006 4:27:41 PM

emails, TIITC DB Admin, Still busy, helped steel potter from craig systems get the climaxpkg.com setup for etrn email, emails about noc, Mgr Mtg, flower library with Randy, VELCRO STORE, Spoke to john bashem at north country this week- settled on ads for this week- Spoke to Anson graphics about the lastest orders- spoke to jason about the discks for that- mailed in the order form with PO, Spoke to ed re: Teals express- set up appt for us next week, set up appts with seacomm for the 26th , meeting with pat riely to talk about nysar state site , worked at home, steady morning. , Checking and responding to e-mail and voice mail. Trying to get a hold of Bruce Barlow at Channel 7. , Emails, customers, tech room., Check and reply to e-mail, apex army, koytte computers to verify meeting- answer mail, Floater Holiday, callbcacks from voicemail, checked emails, answering phone, taking signups, cancellation of invoices. , production meeting with Peg, Tom and Dave, PO's done for Carol. message for Dr. Dean's on AUSA meeting/presentation. s/w Tom Mitchell on bond form - to email. visio to jpeg for darrell. messages, filing. , CG tables, E-mail, Additional work with Kim Cilley with new sign-ups, Picked up mail and opened. Psosted accounts, ans. phone, credit card authorizations, and coupon referrals., Going over CSG Manual, errand, tv 7 new layout, phinneys modem, gisco dsl flier for chambers, watertown city school district, gisco vt, biz cards, yellow page ads, worked on a storefront for Dynoport using SoftVendor software, did a setup. had a question about a web page, kinda busy,

   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