ASP Page Loads Slow When Getting Information From The Access Database
It all seems to work well, but takes a large amount of time for the entire page to load, I guess due to the amount of records that get displayed, or maybe its the repeat region. So, Is there anything I can do in my asp code to speed these things up. Code:
View Replies
ADVERTISEMENT
I am using a script for my site's songs,
Forexample Song is: ASP Song
And Artist is: SitePoint
It shows the songs data in the form of:
<td height="-1" bgcolor="<%=co%>" class="t">
<a href="player.asp?song=<%=rs("song")%>&artist=<%=rs("artist")%></a> by <%=rs("Artist")%>
</td>
It produces like : "ASP song by SitePoint" on songs.asp
But the problem is I have 62 songs, And they takes a lot of time to load,
Is there any other way to call the song details from the database and it will load fast ?
View Replies
View Related
I have seen a few articles with a javascript example but it is not working for me. The server side code is processed first and then the javascript so I basically get my page loading splash screen displayed for a split second and then my page I am navigating to.
How do I display the "Please Wait..." before the server side code kicks in ...
View Replies
View Related
I've got an asp page which scans a range of IP addresses and printes the
response to screen.
I've tried loads of methods and ended up with using javascript innerHTML to
try and fill the content
What I'd like is the value to return instantly rather than wait until the
routine has completed and return ALL the results.
if i'm pinging a big range of addresses the page usually times out......
I thought if I could build the page dynamically, one result at a time, the
timeout error wouldn't happen - and users would see that something is
actually happening!!! Code:
View Replies
View Related
I'm running win 2000, I downloaded a calender and put it into my root website folder. the calendar folder contained a file called adovbs.inc . After the insertion of this folder and creating links to it we noticed that when the web page loaded it's home page, another older page that has been deleted is displayed.
This page was located in the calendar folder. So now I've deleted the calendar folder, and restarted the server but this old page is still on display.
View Replies
View Related
is there a way in ASP to automatically submit a form and its values when a page loads ?
if not is there any way round this scenario. i want to have a drop down list of options depending on which is selected will depend on where the form is submitted to.
View Replies
View Related
I have an application, which simply consists of an Access database being queried by ASP code in a website, running on a Dell PowerEdge 1650 rack mount server (Pentium III 1.4 GHz) with 1024 MB ram. The server runs Windows 2000 5.00.2195 with Service Pack 4.
The application presents HTML tables to users, based on queries made by the user on the website.
Problem is: recently the construction of these tables has been very slow and the scripts time-out. The script timeout is set to about 3 minutes.
The application has been running for 2 years without any problems, well one. About 6 months ago the same thing was happening. I compacted and repaired the database - did not fix it. However on restarting the server it was back to normal, producing the tables immediately.
Now that the same problem is occuring again, neither a restart or a shutdown-restart fix the problem. The straight HTML part is served immediately, but it is evident that it chokes on the tables.
There are two other applications on the same server written in the same style, but much more simple. They are working fine. Code:
View Replies
View Related
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
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
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
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
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
I have built an app that takes some time to load some ASP pages, is there anyway i can display a loading icon or even some interesting pictures and text while this is loading?
View Replies
View Related
I've got a list of variables which have data. Most of them are empty at the time of testing, so it could only be worse if they had data....
Here's the code below. Basically what I want it to do is:
There are a list of variables with data in them (some blank, some not) There is a list of those variables' names that is created into theArray. I want each variable in that array to be run through DocClean in order to convert the JavaScript link. Code:
View Replies
View Related
I developed an ASP page which has 2 input fields- First Name and Last Name.I used Access 2002 as database. Once I click the Submit button,
it has to perform 3 tasks-----
1) It has to update the First Name and Last Name in the MS-Access database in their corresponding fields.
2) It has to go to the Home Page(which I already did)
3) It has to update the date/time in the "Time" field in the MS-Access database.
The following is the code I wrote to connect to the database and update the fields in the Access table---
<%
set MyConn = Server.CreateObject("ADODB.Connection")
set rs = Server.CreateObject("ADODB.RecordSet")
MyConn.Open "driver={Microsoft Access Driver
(*.mdb)};;DBQ=c:/documents and
settings/adcguest/desktop/webpage_html
ewsecurity.mdb;"
rs.Open sqlqry,MyConn,2,2
rs.AddNew
rs("firstname") = first name
rs("lastname") = last name
rs.update
rs.close
myconn.close
%>
Can somebody please help me in figuringout if I am missing something.
View Replies
View Related
I have created a asp project local.and have created a access database local. Iam trying to use the access database from the asp page. But It is not accessing the database file.
once i changed the rights of the access file and checked it.It inserted the records.And after some time, iam not able to access it.some times it accesses and some times it doesnt.
View Replies
View Related
I wrote a script to compact my access databases from my admin section. Everything is working except I get this error:
Provider error '80040e4d'
Authentication failed.
Is their some reason the JRO.JetEngine needs authentication? I don't have direct access to this server and was wondering how to get around this problem or how to fix it. It fails when this link is run:
objJetEngine.CompactDatabase strCon, "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = " & DBTempPath
None of the databases have a username or password. Would I have to have the host company setup an account for this action to take place? And why could I do everything except compact the database? Is their a vulnerability issue when accessing this function?
View Replies
View Related
Currently, I do the following in my ASP pages when making use of an MS
Access database:
Dim adoCon, rsSet, strSQL
Set AdoCon = server.CreateObject("ADODB.Connection")
Set RsSet = Server.CreateObject("ADODB.RecordSet")
adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.MapPath("MyDB.mdb")
strSQL="SELECT * FROM MyTable;"
rsSet.Open strSQL, adoCon
...do some stuff...
rsSet.Close
adoCon.Close
Set rsSet=Nothing
Set adoCon=Nothing
I have a couple queries stored in the database that I use when in MS Access.
Can I call these queries instead of using a string to specify the SQL
command?
The above seems kind of verbose for making use of a database. Can it be
simplified at all?
View Replies
View Related
Unless you declared those session variables earlier, they have no data in them. Assuming this information is coming from a form, try using request.form("fieldname") instead of the session variables.
If this doesn't address your problem, give more detail about what "isn't working"
View Replies
View Related
I have index.asp (Form) & process.asp (submit data from index.asp to Access Database), the Form is running Perfectly.
But, How can I create a login name and page for the applicants to edit the information they submitted?
Let say I have Email (username), Password (password) & lastname on index.asp, then I really have no clue!
View Replies
View Related
I've got a simple template based ASP page which pulls information in one of several different languages from an Access database.
The copy I have in the database is fine. All languages - including the Japanese are displaying correctly when I look at them in Access. However, when I pull the Japanese text from the database, each character renders in the browser as '???????'.
I've tried different HTML encoding, but nothing seems to make a difference.
View Replies
View Related
My client has various Access databases that they want to be able to access (using MS Access, not through ASP pages). I thought I'd be able to create the link from an HTML page but when I do that and click the link, the file is downloaded to the local temp folder. I want the database to open directly from the web server, and then changes must be saved.
View Replies
View Related
I am trying to better a process our dept. now uses. Currently a person updates a Word document throughout the day of of actions items, basically a list of issues with due dates, responsible parties, comments, etc..At the end of the day the file is converted to a PDF and posted on the intranet.
Seems a little stale. Is ASP and a MS access database a good approach to providing real-time reporting to ther client? i.e. a person could push a button labeled "action items" and be returned a printable, decently formatted page?
View Replies
View Related
I have an application which allow users to search our database. Quite a lot
of search fields pull data from other tables. I don't want to populate the
dropdowns (total 14 of them) from the database everytime as it slow the page
load.
Instead I would like to have a link next to the text field which a
user and click and the choices can be displayed and whatever the user click
in the pop up I want to transfer it to the text box and close the popup.
For example there is a Textbox called country. The user can either type in
the country name or click on the link which will pull all the countries from
table in the database and which ever country user selects, the textbox is
popluated with the country name and the pop up closes automatically. Code:
View Replies
View Related
how to export ms-access tables information to excel sheet using ASP....
View Replies
View Related
i need to pull the following info from my database and display it from the most to the least. User can choose between lets say 10 options. Now i want to generate a page which displays the order for the option most chosen to the option least chosen. Does that make any sense?
View Replies
View Related
If i have a combo box, automatically when the user changes the item, i want to display information from the database within a textbox, without having to go to the next page.
Currently i only know how to do this by going onto another page.
In VB it was a simple case of calling a procedure, how does it work in ASP? If i need to call a procedure, how would i do this in ASP. The example in w3schools passes the variables, can i do it without it?
View Replies
View Related
I am trying to setup a form in Dreamweaver where I have a list box (Car Batteries, Antifreeze, Paint, etc.)
How do I setup the page up so that when an item is selected and they hit the submit button it will send them to another page returns just the information from that item on the database and not the entire database?
View Replies
View Related
Usually when you post information from a form to another asp page like this:
<form method="post" action="someASPPage.asp">
It will redirect you to 'someASPPage.asp'.
I was wondering if there is a way of posting information from a form to another asp page, but not actually going to that asp page.
View Replies
View Related
I have an ASP page that contains an A HREF tag. This will load a new page and carry some variables to the new page. What I want is that, whenever a person click the item,the prompt box comes up and ask "why are you not working item." Whatever the person types as the response, I want it to be also carried over to the new page and stored as a variable.
I think that JAVASCRIPT could achieve this, but I do not know how. Can anyone tell me the script that willl accomplish this? The information I have in the page itself is as follows:
<a href="somepage.asp?repp=<%=avariablefromthepage%>&pot=<%=anothervariable%>&wantfix=n" value="no" onClick=''whyNotDone();''>Not Done</a>
View Replies
View Related
I am trying to search for clients contained within a database using multiple search criteria that the user is able to select using a front end form.
The user is able to select there criteria by selecting one or more check boxes and the results are thus retrieved based on what the user has selected. The search works fine until you try and select multiple client types Code:
View Replies
View Related
I have a user based service where each user has their own information, user settings, etc. I want to be able to add tables in my user settings and allow the users to enter in their IM Service (AIM, Yahoo, MSN, etc) and their screen name/user name.
That is the easy part.
What I do not understand or cannot figure out is how to link this information to the icons for each service they enter that will open up the appropriate service with their correct IM name, etc.
Basically I want to provide a way for my members to IM another member when they pull up that users information, or associated information, etc. Basically I need the script to make the Icon execute the correct IM service if the user clicking on it has the service installed as well. The majority of my members use AIM.
Where can I find information on how to install this kind of script and associate it with the users information and an icon?
View Replies
View Related
I've been putting all my old vinyl into a database for my friends to view. Main problem is, using css, html and asp, the page for displaying the database results loads almost completely before the data is fully received, the top menu is ok, but the next search button (which is actually placed after the recordset loops in the scripting) loads first, then the footer from css then the database results is mixed into the copyright bit at the bottom.
Is there a way to tell the page to wait for the data to be received before loading the page itself?
View Replies
View Related