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

One Application Object

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

Application Object ?

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

Application Object Links

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

Can I Get To The Application Object In A Class

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

Application Object Or Variable!

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

Caching In The Application Object

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

Application Object Lost?

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

Application Object And Close Connection

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

Application Object :: How Many Users Logged In?

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

Application Object :: Trying To Detect Multiple Logins

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

X-Post: Cannot Set Application Object In IIS6.0, But Could In IIS5

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

Application Object :: Allow Only One User To Access Form

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

Application Object :: Existence Of Variables, Resources And Locks

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

Re-writting For DBASE IV

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

Conn, 1,3,2

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

Dbase Remains Open

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

Insterting Quotes Into A Dbase

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

Dbase And HTML Sorting

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

Conn.execute

<%
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

SQL Conn.execute

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

ASP: Update Multiple Dbase Rows?

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

Export Dbase To An Excel File

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

Read/write DBase IV Files

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

Inserting Strings Into An Mssql Dbase

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

Conn.Execute LockType

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

Protect Conn.strings

what is the best way to protect the connection strings keeping an effective, low overheaded access to them ?

View Replies View Related

Duplicating Dbase Entries In Seperate Dbases

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

Problems Using Same Conn String Twice In 1 Page...

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

Understand Global.asa And Conn String

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

Troubleshooting Access Conn. In Dreamweaver

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

Querying More Than 255 Characters From FoxPro/DBase Database Field

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

Conn.Errors.Count Or Err.Number For Transactions?

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







Copyrights 2005-15 www.BigResource.com, All rights reserved