Storing Complete Dbase Conn In Application Object
I am currently working on a small asp application. Now I would like to store the complete database connection in the application object. Note I want to store the connection NOT the connectionstring. For that purpose I wrote a small asp include which connects to the dbase and stores the connection object to the application object. However when I use this include in my pages then it doesnt work. What I am doing wrong? Here is the code:
View Replies
ADVERTISEMENT
We have our web site setup on two seperate servers. They are connected together through a BIG/IP server. I'm not sure how many of you are familiar with BIG/IP (load balancing) but I'll give you a quick explanation:
When a user goes to our site, they hit our BIG/IP server first. This server looks at our two web servers and determines which one has more resources to spare. The BIG/IP then redirects the user to that server, where they are on the rest of the time they are on our site.
So we have two web servers with duplicate web sites running. My problem is I need to run one application object between both servers. Is this possible, or is there a work-around?
View Replies
View Related
I am developing ASP application with complicated login system. There is several group of menu options. Each have form 5 to 15 sub-options.
User can work with any combination of options and sub-options and can see only these menu options which are allowed for him. "Rights rules" are store in SQL Tables and are getting after logon.
Now a questions:
1. what is the best way to store this menu structure (Session object is not allowed because it uses Cookies) ?
2. What is the best way to handle the "rights rules" ?
View Replies
View Related
Below you can find quick links to information about the Application Object. I would write a post like my CDONTS one, but I just don't have time, but when I do, I'll see if I can get one done.
An intro to the Application object, this its in JScript but its easy to change
Using the Application Object to Improve Performance
HOW TO: Declare an Array at Application Level Scope in Active Server Pages (Q165293)
A Real-World Example of Caching Data in the Application Object
W3 Schools Application Reference
HOW TO: Use the Application Object to Store ASP State
View Replies
View Related
I am trying to get to the application object from a seperate class in my ASP
application and I dont want to pass the object in as the class is inherited
to lots of other classes. So i can have something like the following:
Imports System.Web.UI.WebControls.DataGrid
Namespace Classes.Inheritable
Public MustInherit Class EntityCollection
Implements IDisposable
Private mobjDataConnection As Classes.Databases.DBConnection
Public Sub New(ByVal strSQL As String)
mobjDataConnection = Application("DataConnection")
End sub
View Replies
View Related
The following code exists in a Global.asa file:
----------------------------------------------
<%
Set Application("Thing")=Server.CreateObject("THINGDOER.THINGY")
%>
----------------------------------------------
Will the above code snippet:
create a non-object Application variable named "Thing" & place it in
the Contents collection of the Application object?
-----OR------
create an Application object named "Thing" & place it in the
StaticObjects collection of the Application object?
View Replies
View Related
There seems to be plenty of discussion about caching in the Application Object, however, I cant find any info on what realistic limitations there are and how they are measured.
What are the factors that will limit performance / storage of many individual or single large bits of data with application scope? eg database driven list boxes (that dont require up to the minute data) 10 * 100 options? 100 * 100 options? kb's? megs of info? How much can I cache?
View Replies
View Related
I'm having trouble with the workflow described bellow:
1. Asp page 1 on server A contains an iframe.
2. Asp page 1 submits a form targeted to the iframe, to Asp page 2 on
server B.
3. Asp page 2 runs in the iframe and at some point might decide to submit a
form targeted to the _top frame, to page 3 on Server B.
4. Page 3 loads in the top frame. Code:
View Replies
View Related
Rather than opening and closing a new connection to the database on every page, I have placed that connection into an Application variable. This has worked fine so far.
My issue is that I have a logoff page where it closes that connection.But this means that users who are on the application will not be able to access that connection.The obvious answer is that I don't close the database connection.But my problem is, I would like to eventually close that database connection.
How can I determine if an application variable (not session variable) exists?How can I determine that there are not any users on the application?
View Replies
View Related
My asp application allows a number of users to log into it. Each user has a different type of access level (General User, Manager or Administrator). I want the administrator to be able to see how many other users are logged into the application at a particular time. How can I do this? Would the use of an application object work for this?
View Replies
View Related
Im trying to detect multiple logins...
Im using a application object in my global.asa, for some reason it doesnt seem to work. here is my code
<script language="vbscript" runat="server">
Sub Session_OnStart
Session("LoggedIn")=0
End Sub
sub Application_OnStart()
Application("Logged")=1
End sub
</script>
In my pages if i print the Application("Logged") value, it does not show....
View Replies
View Related
We have pretty simple ASP (not ASP.Net) application, which has been running fine on IIS4 and IIS5. It has now been moved to a sever running in the DMZ and managed by a 3rd party. The server is Win2003 and IIS 6.0.
Within the Globe.asa file, have an Application_OnStart SubRoutine (Visual
Basic) and it bombs out on the first line:
Application("cnSecurity_ConnectionString") = "connectionProperties"
With the error:
Server object error 'ASP 0177 : 800401f3'
Server.CreateObject failed
Globe.asa, line 25
View Replies
View Related
I'm looking for a way to allow only one user to access my web form at a time. so that if there is a user using my web page / html form.. then the next user is directed to another page. So only one user is allowed access at any given time .I was hoping there is a way to do this with Application variables.
View Replies
View Related
I'm using application variables for a web based sales tracking application. I use the variables for stuff like connection string, database name, etc. I store the values in a asp file that is included in a login page. The assignments are in a procedure that I then call on the login page. This is done everytime a user connects to
the login page.
what's happening to the variables? Are they being overwritten everytime a user accesses the page? I'm not checking for the existence of the variables. I just call the routine everytime the page is accessed. I know the values are shared for all users but, I was wondering if I should check for the existence of variables? Will it free up resources? Should I be using locks?
View Replies
View Related
I have stolen code from another thread in this forum that I am attempting to modify. The original code uses a Microsoft Access database file but I can't create one cos I don't have Microsoft Access. Instead I am using Microsoft Works to create a dBASE IV .dbf file.
This is the code i have attempted to use but it doesnt work. Code:
View Replies
View Related
I have a some code:
Rs.Open "[TableName]", Conn, 1,3,2
RS.AddNew
RS.Fields("Account_Name").Value = request.Form("Account_Name")
my question is does conn, 1,3,2 only write to the database not making the data readable? if i change it to conn, 0,1 i get page can't be displayed. I'm using access DB, with conn 1,3,2 it inserts fine, but when i go to query it i get no records found, but i see the data in the database, anybody have any ideas?
View Replies
View Related
I am creating ASP pages which call for information from a database, however when I have completed the page in FP, exit, and go to Access to modify a Query, I am told the Database is still in use and that only "Shared access " is available.This does not happen if I reboot the computer.The page was generated by Access "HTML Wizard.I am using FP98 and W98.
View Replies
View Related
How can you insert a quote ' or " into a database from a forum without getting an sql error due to the quotes closing, or opening a new field in the sql string.
View Replies
View Related
I have a Parks Database where anyone can see a complete list of parks we have. What I would like is for people to be able to sort this list by certain parameters, one of them being a "District" parameter, but could conceivably be parameters such as Sort By "Playground" to see a list of Parks with Playgrounds.
Is there a way for me to do this via some sort of hyperlink to the "District", that if it's clicked on, does a new form (Maybe a form named sortViaDistrict) within the same page? I'm not too sure how to do something like this. Code:
View Replies
View Related
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open application("dtat_motor_connectionstring")
set rs = new adodb.recordset
'Set RS = Conn.Execute(' "exec spcn_update_transactions &
customer_number, customer_name, customer_address, customer_city,
customer_state, customer_zip, customer_phone, vin,
acct_number, tag, title_number, tag_type_number, branch_number,
institution_number, yr_make, state_from, type_number)
response.write rs
%>
I'm I connecting them correctly. Is there and easier way to execute a stored procedure. I'm trying to insert data into a SQL page. I have to have the customer number returned to me asap for the next page.
View Replies
View Related
I use this code all the time, but what does the ",,129" mean? Are there other parameters that one might use (I only do fairly simple SQL commands).
conn.execute strSQL,,129
View Replies
View Related
I've got a little user poll system and I'm trying to create an 'edit' form. The form relates to 2 database tables, one holds the poll details (title, start date, end date, etc) and the other holds the answers/options (answer_id, answer, etc). I've successfully setup the form so it updates the poll details but I can't work out how to update the answers? Code:
View Replies
View Related
It will export a database (Access) table to an Excel sheet.
Set rsC = Server.CreateObject("ADODB.Recordset")
rsC.Open "select * from CFL WHERE Emp_no = '"&empno&"'",myConn,1,3
'**** create excel file
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "Content-Disposition", "attachment; filename=CFL.xls" .......
my script is working properly but i want to create another sheet of the Excel file because i will export multiple tables from the dtabase to an Excel file with multiple sheets. it only creates one sheet?
View Replies
View Related
I've got to learn how to read/write dBase IV files fast. Please provide a good quick start / tutorial and / or some good links here.
View Replies
View Related
The scenario is that the user enters a description of a special offer into a text box and then can add that record to a database field using the insert method of asp. However, an error occurs if the description has any apostrophes in. For example,
special offer 1: andy's prize plums
could cause an error because the insert looks something like this
"insert into offersTable(offerDescription) values (' " & request.form("description") & "'"
is there some way to escape all naughty characters so they don't cause a problem. Any suggestions very welcome.
View Replies
View Related
Is there any way to modify the locktype when updating a database via a connection object's execute method? I have a game which worked completely fine when only ten or so people were playing, but as it grew into the hundreds, many people started getting errors and I'm 99% sure that they occur when the database tries to update when it's locked, which means that my connection execute statements are defaulting to pessimistic locking, which I don't want them to. Does anyone know how I can fix this?
View Replies
View Related
what is the best way to protect the connection strings keeping an effective, low overheaded access to them ?
View Replies
View Related
I have a dbase containing login details for 21,000 members. I also have a
forum that I am about to implement.
When the user gets to the main site, he has to login (this is done by
checking his credentials against DB1) When he is logged in, all his details
are stored in session variables. Clicking on the forum link will take him to
the forum where he has to log-in or register. Currently, the forum checks
cookies to see if there is a valid name and password and then checks these
against it's own DB (herein called DB2) or requires the user to
login/register
I plan to modify the forum so that the login is bypassed and the forum
accepts the current session name and password as the login. (This is so that
all names on the site main site, chat, forum etc are uniform, i.e Dave47 in
a chat room, is Dave47 in the forum, is Dave47 in the members area etc)
so...what I need to do (if you're still with me) is.
When a new user registers on the main site, his details are put into DB1
*and* DB2. , can I have two data sources open at once?
The reason I need two DBs is that the information in DB1 is a lot less than
is needed by the forum in DB2.
Also how can I copy selected fields from DB1 (name, password for existing
users) into DB2? like I said..there's 21,000 and to do it manually would
take forever.
View Replies
View Related
I have a problem utilising my connection string to open more than one recordset in one ASP page.
The following code runs absolutley fine on a server running ASP 3, but falls over when run on a server running ASP 2 (the error says:
Microsoft JET Database Engine error '80004005'
Could not use ''; file already in use.
The code I am trying to run is: Code:
View Replies
View Related
I searched the forum but I am still a little confused regarding the global.asa file. I created a global.asa file and it is in the root of the virdual directory. I then created a sub to initially connect to a datase such as: Code:
View Replies
View Related
I have 3 db connections, 2 of which are dsnless connections to access db's. Any of my previous existing pages that have recordsets from these db's work fine. I can add a new recordset to them and it works fine as well.
If I create a new page and add the same recordset in the same directory, I get the error msg saying something like "unable to open registry key" which from my understanding, means the page cant find the db.
Now I am using Dreamweaver 2004, and using their way to create connections where it creates a file, and then just adds an include statement an asp page if you use that connection.
Any good way to test this connection on the page or any ideas on how to troubleshoot where the path its pointing to is incorrect...im pretty much stuck at this point.
View Replies
View Related
I've been tasked with integrating an older management system based on
DBF files with my snappy new ASP application to provide users of the
ASP application with real-time data from the management system.
I figure with DBF files, I should use either the DBase drivers or the
FoxPro drivers to connect to the database. Code:
View Replies
View Related
What is the best way to control is a transaction? I've done a little test and both of the examples below seem to do the job, but I was wondering which is the better method, this:
If err.number <> 0 Then
conn.RollbackTrans
Else
conn.CommitTrans
End If
Or this:
If conn.Errors.Count <> 0 Then
conn.RollbackTrans
Else
conn.CommitTrans
End If
View Replies
View Related