Slow MDB Acess In Global.asa

The following code runs in less than one second when used in an ASP page but when used in Session_onStart() in global.asa, the first page in a new session is delayed by more than thirty seconds. The code seems to work - its just slooow. Why is this so and how do I fix it?

Dim cnComDoc
Set cnComDoc = Server.CreateObject("ADODB.Connection")
cnComDoc.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:comdoc.mdb;Persist Security Info=False"
cnComDoc.execute "Insert into SessionInfo
(SessionID,BeginDateTime,IPAddress) values ('" & Session.SessionID & "','" &
FormatDateTime(now(), vbGeneralDate) & "','" &
Request.ServerVariables("REMOTE_ADDR") & "')",,adCmdText +
adExecuteNoRecords
Set cnComDoc = Nothing

View Replies


ADVERTISEMENT

ASP And Acess And IIS

I am testing an app on my own development machine. I am using IIS 5 with ASP and MS Access. I have the Access database in a directory called Private located one level down from the Web App. When I run the app from the browser everything works just fine.

When I try to debug the app from within Visual Studio .net 2003, it can't connect to the database. If I run the app from within studio without debugging, it works. When trying to debug, I gave it the name and password of the administrator as prompted but it just can't connect. I have set up debugging in IIS.

View Replies View Related

ASP Acess Error

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Not a valid password.
/MyWeb/DBConnection.asp, line 11

The password is correct in DSN and DSN works from vb Component but this asp page is giving this error.

Once this problem solved by restarting WWW service of IIS 5.0 in Windows 2000, but i have restarted it many times but the problem is there, I have also tried restarting my PC.

View Replies View Related

Restrict Acess

I'm trying to restrict access to a page based on a session variable called MemberUserID, so the way I thought of doing it was to say if MemberUserID is not equal to this value, then you would get an error page, but the operator I'm trying to use is giving me an error:

<%
If Session("MemberUserID") != Name Then
Response.Redirect "error.asp"
End If
%>

is there a better way to do this?

View Replies View Related

Database Connection With Acess In ASP?

Can someone please help me with this ASp script?

What i am tryiong to do ? Trying to connect to access database
Is DSN set ? Yes
Operationg System ? XP Prof
DSN Name ? NW

<%set cnn = server.createobject("ADODB.Connection")
cnn.open "DSN=NW"%>

<%
cnn.close
set cnn= nothing
%>

View Replies View Related

Carriage Return Before Inserting Text Into Acess Database File. How To Do It?

how to replace carriage return upon extracting text from Access file.

However I think it will be smarter to do it before (during) inserting text into acess file.

It might be primitive question, but I started my ASP learning just last week and many things are confusing me on this stage.

QUESTION:

What should I change in my ASP file code (file inserted data from the HTML form file into database file) to replace all carriage returns and line brakes during inserting text into field GuestSory? Code:

View Replies View Related

Global.asa :: Assign Diffrent Global.asa To Each Application

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

View Replies View Related

Global.asa :: Combine Many Global.asa Files

I have added a db driven marquee to my site and need to combine the global asa's to 1 global asa file. Code: ......

View Replies View Related

Slow Site

I'm working on a site that is just *extremely slow* on certain pages that are very database intensive. Now... I've worked quite a bit with databases before - and this is different. It's ridiculously slow.
I've looked through the long ASP script (it's a calendar listings page, with some more db stuff under the calendar).
There's not really anything else I can do to fix up the code. I've consolodated SQL statements, converted everything to GetRows... closed my objects immediately... etc. I've also added indexes to the db fields in my WHERE clause of SQL.
The page isn't *that* complicated that it should take so long. Sometime it even time-outs.
I've tried so much, and nothing is working.
Could it be that I need a dedicated server? Something I'm missing in the code? (It's really long so I'd prefer not to post it if possible but I might).
MySQL

View Replies View Related

Tooo Slow

I need help with a database problem in asp. When the page runs is is timing out.
THere are 18000 records.

Is there something I can do to make it faster or run on the server side before display?
I have set the timeout to 2400 and it is still timing out

View Replies View Related

Localhost Slow

I'm trying to surf on a website on winXP, but IIS response is very slow. It doesn't load a lot of images (red x). Besides, it alerts always there's no connection (from each page to the following), asking whether I want to connect. The browser keeps waiting for images then it fails. What can I do?

View Replies View Related

The Page Is Too Slow

I developed a page that takes from the database based on a select information and displays that on the screen. My problem is that the display proces is very slow, it takes time to display the results. Code:

View Replies View Related

Loading Too Slow

in what condition will lead the the ASP page run too slowing.

View Replies View Related

Slow With Authentication

I've set up a form which sends info to my email address usind CDO 2000 w/ authentication which takes about 10 seconds for the message to get sent.

View Replies View Related

Getstring Really Slow

I'm connecting to an Access table with 100+ rows of data of approx 20 columns wide. I'm using getstring to "Quickly" display it in a table, but it's un-useably slow.

View Replies View Related

IIS Is Really Slow After IE6 Upgrade

I have a development box running Windows NT Server 4 SP6a with all the
latest hot fixes and patches. Up until a couple of days ago, it was
running IE5.0 without problems. I upgraded to IE6 SP1 and ever since,
whenever I access the default ASP web site, it takes ages for the first
page to appear. After that subsequent pages load fine. Code:

View Replies View Related

Slow ASP Pages On IIS 7

I have migrated to Vista Business and installed IIS 7.0. I moved some
classic ASP pages from my old XP box running IIS to the new box. I've
made no changes to the code, which worked fine on the old machine.

They also run fine on a remote server. On the new machine, the ASP
pages are running extremely slow and timing out with the error "cannot
display the web page." I've verified that I'm making connections to my
Access database (which is fine for my low-volume site) and closing the
connections. I've checked the IIS log and seen no issues. I turned off
my firewall briefly, which didn't help. I watched perfmon and didn't
see that unusual amounts of resources were being used. Code:

View Replies View Related

ASP Site Slow Performance

I have an asp site that of late is having a very very slow response at the production environment and it is taking 6-7 minutes to do the basic operations that are needed. We have come to know that the performance has deterirated after the recent release.

Going through this thread IIS 6.0 slowing down one of the suggestions listed was to make sure one destroys objects the code creates which I have taken care in all the pages. Actually all the new changes that were to be done involved working with session or local variables and so no com objects were touched.

We are using Windows 2000 server with SP4 at all the environments. Could someone tell me some suggestions on how to identify the problem? This is a problem faced by many at the clients end and this occurs even on server restart. Please let me know if there are any additional details that are needed.

View Replies View Related

Slow Image Serving.

I've got a client that has a site that seems to be serving images up slowly.
win2k, xeon, 1gig ram, the box is inhouse. HTML generation and viewing is
blazingly fast. The page size runs around 165k, but is taking 7-10 seconds
to download all the images.

I ran a netstat -an on the box, and see a load of time_wait messages.

The guy who does the networking for them insists that since the images
reside on the same box as the web server, the slowness has nothing to do
with the internal network. hhhmmmm.....

I know there are a hundred reasons for the slowdown, but does the logic of
images on same box not having anything to do with a slowdown make any sense?

View Replies View Related

Slow ASP Page Need GIF To Show

I have a basic asp page running that is very slow it has to crunch some info
and when a user hits submit it can take a minute or more for a response. So
what I did was call a second page that should show a gif that is asking them
to be patient.

Unfortunately this never shows (See below). I have tried
other ways as well, but I have been unsuccessful in getting the gif to show.
This has to be simple but I'm not a skilled asp developer so I don;t know
how to do it. Anybody have any ideas?

View Replies View Related

Slow ASP On Server 2003

I just migrated an NT4.0 website (all ASP) to Windows Server 2003 (small business server - deluxe edition) and some pages are very slow to render on client.

Seems to be pages with tables. I can stop the browser by clicking "X" and the table will be partly rendered. The table only has 26 rows and very little content.

Any ideas why this is happening would be appreciated. I have read of others with the same problem but no solutions.

View Replies View Related

Page Loading Very Slow

I am running a query from MS FoxPro and displaying a table after the query is ompleted. I assume the query of the criteria takes longer than displaying the table...but in this case it's reversed.

After the Query is complete, it takes about 10-20 seconds to display the table, which consists of just information from the database. i.e. customer name, number, vehicle make and model, date it was purchased. Those simple items. Is there a way to make it load/display faster? I am using ASP and MS FoxPro.

View Replies View Related

SLOW Response Time

Anyone know what might cause my ASP to start running slow? It's been running fine until today. Today when I pull a repost, it takes forever to for the code to create the page.

When I go into the Access database itself and run the individual queries, they run just fine. It only takes a fraction of a second for the data to apprear. When I run the ASP code to see it on the webpage,it takes around 30 seconds!

Anyone got any recommandations on what I need to check? It just doesn't make any sense that all the sudden it runs flat out SLOW.

View Replies View Related

Slow ASP-SQL Database Connection

My ASP pages have very slow connections with SQL Server database, although eventually it will reach the page and get the results. The SQL Server database and IIS are in the same machine, I have no idea why it will cause the problem.

I just put this connection string as SSI:

strConnect="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=MYDATABASE;Data Source=MYCOMPUTER"

View Replies View Related

Slow Loading Of An XML File

I'm reading an XML file in my ASP script which then uses XSL to format the output. However, the script takes a long time to load the script, almost 30 seconds. Code:

set xml = Server.CreateObject("Msxml2.DOMDocument.4.0")
xml.async = false
xml.load(Server.MapPath("XMLTestfile.xml"))

Does anyone know why the webserver will all of the sudden take so long to load the file when it used to work almost instantly?

View Replies View Related

Asp.net *very* Slow Initial Load.

where I can find information regarding a problem I am having with w2003 ii6 and asp.net. The first page load each morning can run to 1/2hr, which as you can imagine is not exactly making anyone happy. There doesn't appear to be a newsgroup dedicated to asp.net, though I may have been looking in all the wrong places.. so many groups.

I've found some info on the web related to the problem but nothing which discusses what may be going on, nor how to diagnose it.

View Replies View Related

What Causes An Asp Script To Run Slow/hang?

I have a piece of form processing software that basically saves the form content to an Access database and then sends the data in the form of an email to the specified email address.

I had it running perfectly. Everything worked as it should.

But then strange things started to happen, it would start to slow down in the admin backend when adding new form processors (contains info like required fields, recipents email etc). Code:

View Replies View Related

Slow Connection Cause IE Crash

I have an application written in ASP. It only uses JavaScript (.js) on
client side. If the browser is accessing the web site through fast
connections, like intranet or broadband, everything is fine; but if the
browser accesses the web site through slow connections like dial-up, IE
continuously crash when you click on buttons or images in the web page. The
crash is always in MSHTML.DLL.

The server is Windows 2000 Advanced Server with SP4 and all updates. The
client machine is Windows 2000 Pro with SP4 and all updates. The browser is
IE6 SP1. The same client machine, if I am visiting the application through
local network, it's ok; if I disabled LAN and use built-in modem to use
dial-up to connect to the web server, the IE always crash. We already
disabled all firewall when testing dial-up. We also tested XP Pro with IE6
SP1 and all the updates, the same result.

View Replies View Related

Page Loading Slow

I have a stored procedure that is large and accesses the database a lot which slows down the loading of the home page. Is there anyway to load the whole HTML page and then load the stored procedure inside the page?

View Replies View Related

Reason For Slow Processing?

I have developed an application in asp which is available over intranet. the first page of the site is a login page and allows the users to enter their credentials and login.

The login page is a simple html page. The site works fine , but after quitting if it is left idle for about 30 mins, the next user who tries to login it takes about a minute to process to finally enter the site. after which it again becomes fast.

what can be the reason for the site being slow only when it is accessed after being left idle for some time?

View Replies View Related

Response.BinaryWrite For One JPEG Is Very Slow

I am using Response.BinaryWrite to display JPEG's to the browser. The
problem is that in IE, one particular JPEG is loading very slow. Normal
JPEG's take a few seconds, but this one sometimes takes up to 30 seconds.
THe weird thing is that if I refresh really quick, the JPEG appears for quick
second, and then the new Response.BinaryWrite kicks in. So, it looks like
the browser has the image, but for some reason it is not finishing loading it
into the browser. Code:

View Replies View Related

File Upload Over A Slow Network

I'm facing problem with file upload over a slow network. Whenever I tried uploading a file that exceeds 3Kb, the browser will freeze for a few minutes before I get the "page over found" error.

I've tried different ASP upload solutions, including 1 from ABCupload, Smartupload and ASPupload from Microsoft, and the result is the same. Does anyone have a solution for this?

View Replies View Related

Website Very Slow – Looking For Solutions

website is experiencing extremely slow reaction times. Web pages are taking a long time to load. The site is designed with ASP pages coded with VB Script and run on an MSQL 2000 Server. We are looking for help / tips on how to debug and troubleshoot the problems.

View Replies View Related







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