This questions is a little one sided, I used to have the connection to the database on the site until I learned about the global.asa and since then all my sites have used it. I don't know the benefits of this file vs any other methods so I have to ask. But first let me explain.
I have a site, one of the many using the global.asa, it works 2 Microsoft access databases that run pretty much simultaneously on the site. Today, my host sends me an email telling me that they are open constantly and it's causing them problems on their shared server. So I modified the asa to close the database after every session and the host I had done so. They replied shortly after saying that a session could be open for 20 minutes before closing and they did not see this amend as helping the problem. So I'm looking for an alternate method.
The site itself is a collection database with over 1,200 user accounts, I have absolutely no idea how many of these user accounts are actually in use, but that is how many registered users there are in the database. Most of the regular users probably visit every day or two and I know that the admin (of about 8) visits daily to update the records unless there is nothing to add.
I've been given 7 days to solve this problem or they will close this particular site down. So in this case, is global.asa a good idea? If not, what method could I use to minimise the database being opened?
I have one application folder containing all ASP code files. I want host multiple sites pointing to same code. Can I do this ? If YES then how I can assign diffrent global.asa to each application...
Most of my ASP programming experience is on NT4.We recently upgraded (replaced) our NT4 webserver with Win2k3 Web Edition.I am looking for a good book that I can go through that will show me the new and different ways IIS6 does things. I found out that some things still work from my old web site, but they no longer work on the new site.
I've been doing ASP by hand-coding in either Homesite or Interdev for years. I have been using Dreamwever for static sites that I make on the side. I recently was asked to make a form which will store info in an Access database, and thought it would be a good chance to learn how to use Dreamweaver MX's ASP capabilities.
Haven't tried it yet, but reading up on it, it seems that it forces you to use Session variables. I'm not a big fan of session variables, and want to avoid them. Anyone here use DW MX for ASP?
I am an intermediate ASP programmer looking to start learning .NET and am looking for a good book to start learning from. Anyone have any recommendations on a good book to get me started?
Can anyone find fault with this code? I wrote in in hopes of preventing users from "breaking" SQL queries and getting places they shouldn't by using SQL Injections.
Ive been making asp sites for about 2 years, but my first "real" site is going to be going live soon. Im currently seeking out a reliable hosting company based in england to host this website. Has anybody got any ideas of a good host? Ive been searching around for some time, but have not come across any that looks good enough. Im not after a dedicated server, shared hosting will do.
I looking for a tutorial on charts/graphs which would take information from the DB table. I have a column about 31000 records and numbered field of 001-0022. I hav another field which contains texts.
What I'm looking for is to show graphically on a scale of 001-022 as in the first field how many time does the search criteria appear.
For example: I search a keyword "hello"
and the graph would show 001: 30 times, 002: 4 times...022: 1 time, but as a chart.
I think it would be nice to add a percentage calculation too.
I have written a few functions that are used on several pages throughout my site and am wondering what a good exection time might be (generally). The inital page a user is faced with after logging in pulls data from several different tables and displays 40 rows all together.
The execution time for this particular page is the slowest at approx. 950 ms to 1400 ms. This seems awfully slow. This is probably because I am executing 10 different stored procedures instead of one (I thought it would be too big of a challenge to write a single select statement and parse through all the data). What sort of execution times are acceptable to most of you? What do you usually shoot for?
I am trying to send out a mass email newsletter. I have 600+ subscribers in our SQL Server Database. Well, is ASPMail (Server Object's product) good for this? If so I have some concerns about the error handling and assuring people don't continue to recieve the same email. Does anyone have expierence with this? If so, what is your advice?
Since my efforts to get my current script working are not working out. Does anyone know of a good ASP form handling script that can work with my HTML form.
Does anyone know of a good yet simple shopping cart written in ASP? It doesn't have to be free I am willing to pay up to $200. I am just looking for a simple front end and an admin area to add products easily.
I'm looking for a good web-based calendar that I can host on my website. Some features I'm looking for are the ability to schedule birthdays, anniversaries, etc.
with email notification of when the event is nearing. Picture uploads are something else I'm looking for. Easy to read and easy to maintain is also a plus.
I'm trying to get some recommendations on credit card authorisation suppliers such as paypal, worldpay or 2checkout.
Seems like a bit of a mine field so wondering if anyone has any view, positive or negative on these (or other) suppliers.
I notice paypal is free but chargers about 3% or the goods sold which isn't bad for a small startup. I think Worldpay is about 2% but charges a monthly fee.
Is it easy to get this up and running on a site? do you connect to theirs to do the payment or just fire secured data to them to process? is one a better deal, safer and easier to implement than another?
I am greeting I would like to consult the better solution(with security consideration) to the access is for MSSQL(2005) from ASP(Classic) in the system of the intranet.
a) SQL mixed mode and depositing user name and passwords for MSSQL of the server in "connection string" (with open text)
b) Windows Authentication and to send rights to SQL of the server for IUSR_computername c) ?
Intranet(server ASP and MSSQL) in the company available from the any computer, workers data (name and pass) they are being kept in MSSQL tables. Problem is because Server MSSQL(Intranet) he will be replacing himself into data with two MSSQL servers and with one PostgreSQL through Windows Authentication.
Does anyone know of an ASP-based search engine that uses a crawler/spider? Preferably, I'd like one that uses markup tags so that I can, for example, exclude blocks of text from being indexed, such as the header or navigation borders.
I am trying to put a condition in my Global.asa file based on the server name.the reason, I want to set a global string as a application variable based on the server I am on. I also need to set a coonection string based on the value of the server. I need to use this connection string to retrieve values from an sp in application on start that sets a load of global variables so I can't really do this anywhere else.
I have a site which until this morning, was on a remote server. The structure was that the "site" was actually a folder on the server, as I am designer and use this arrangement to develop sites. Under the root directory, I had modified the global asa file to include session variables. Ok, so I download the site (folder) to my hard drive, and put it in the folder of "MY Documents" called MyWebs. I then opened VB Studio and created a new solution, which is pointing to the before mentioned directory in My Documents. When I pull the site up in IE, the session variables were not being called, and I realized I had not copied over the asa file. So I did so, placing a copy of it in the hard drive's c inetpub wwwroot directory, and also directly in the my docs mywebs directory,and the site's directory as well. It seems it is still not being called.Can anyone tell me what I am doing wrong?
I have IIS 5.0 installed on for a test server. the global.asa file runs perfectly.
when tryng the same application on win server 2003 IIS 6.0 the global.asa does not fire. i have set the application as a virtual site and given rights for iwam and iusr. What else could be the problem. Code:
How does IIS 6.0 treat the global.asa file? I had the following problem;
1. uploaded a new site to the win3k server
2. had incorrect db connection string in Session_OnStart in global.asa and website caused errors.
3. Changed the global.asa file to include the correct details. Saved the file. Still got the same errors.
I could not resolve this unless restarting the WWW Service on this server. In IIS 5.0 the global.asa file would reload after resaving it (as the timestamp is updated).
I even waited the next day before restarting the service because I though Session_OnStart expires after my session ends...but the error was still there in the morning.
Hopefully someone will make sense of it for me. Here is the code (I inherited) in the global.asa
Sub Application_OnStart Application("DB.ConnectionString")= "" Application("MaxLoginAttempts") = 5 Set Application("Con") = Server.CreateObject("ADODB.Connection") Session("Test") = Now() End Sub
I created a dll to track our users and I want to call it in the Global.asa. How do I do this? I've seen the <OBJECT> tag to create an object, but I'm not sure how to use it correctly.
i'm a little bit confused with using application_onstart.. as u can see in the following code... my DB connection and SQL statements is currently included in my application_onstart event.. but, unfortunately, i wasn't able to reference Application("sUser") in my asp when i tried to run my website Code:
We have over 100 asp pages that reference a table (distribution_components). We added a new column and primary key to that table, so now we have to modify the where clause to include that column (we have to make the new column = to a session variable in the page)
The table appears 531 times in our code. Is there some util or method that allows us to change it globally, other than going to each occurrance, and adding the new column to the where clause.
