Hey,
I'm running a localhost web server...W2K with IIS 5.0, and I'm trying to use
ASP/ADO to access my Access database. When I first load the page, everything
works, but if i hit refresh (F5 or even Ctrl-F5), I get "page cannot be
displayed" with the problem line of code being the database Open command
(the starred line in the snippet below). If I press Refresh repeatedly, that
doesn't help. After a minute or two, refreshing the page does access the
database, but then the problem begins again with the very next refresh. I'm
not sure where the problem is...in Access, ASP, ADO, IIS, or something
important I left out of the HTML. Has anyone experienced this?
Thanks,
Dave
<snip>
<%@ Language="JScript" %>
<html>
<head>
<title>DataBase Fun!</title>
</head>
<body>
<%
Session.Timeout = 15;
conn = Server.CreateObject("ADODB.Connection");
**********conn.Open("obdc_exmp");
%>
<%
strSQLQuery = "SELECT * FROM names";
rs = Server.CreateObject("ADODB.Recordset");
rs.Open(strSQLQuery, conn, 3, 3);
%>
<%
while (!rs.EOF)
{
Response.Write(rs("last_name") + ", " + rs("first_name") + "<br>");
rs.MoveNext();
}
%>
<%
rs.Close();
rs = null;
conn.Close();
conn = null;
%>
</body>
</html>
</snip>
3  4030 
Could be Access. Access has very limited strength when it comes to dishing
out data online.
Access would is best suited for sharing data online if you set it up to
generate a basic html page around midnight (every night if needed). (Look
into using the OS Task Scheduler to automatically call the database file and
to close the file.) Then during the day people only be pulling the html page
and not putting any demand on Access.
You could then set up a Data Access Page (Access 2000 and above) to update
the database from within the office. (Data Access Pages are really useful on
an intranet basis. You can use them on the internet provided the user is
known. (You could update the database from home.))
Dave
"Dave" <ne*****@yahoo.com> wrote in message
news:Mj********************@comcast.com... Hey,
I'm running a localhost web server...W2K with IIS 5.0, and I'm trying to
use ASP/ADO to access my Access database. When I first load the page,
everything works, but if i hit refresh (F5 or even Ctrl-F5), I get "page cannot be
displayed" with the problem line of code being the database Open command
(the starred line in the snippet below). If I press Refresh repeatedly,
that doesn't help. After a minute or two, refreshing the page does access the
database, but then the problem begins again with the very next refresh.
I'm not sure where the problem is...in Access, ASP, ADO, IIS, or something
important I left out of the HTML. Has anyone experienced this?
Thanks,
Dave
<snip>
<%@ Language="JScript" %>
<html>
<head>
<title>DataBase Fun!</title>
</head>
<body>
<%
Session.Timeout = 15;
conn = Server.CreateObject("ADODB.Connection");
**********conn.Open("obdc_exmp");
%>
<%
strSQLQuery = "SELECT * FROM names";
rs = Server.CreateObject("ADODB.Recordset");
rs.Open(strSQLQuery, conn, 3, 3);
%>
<%
while (!rs.EOF)
{
Response.Write(rs("last_name") + ", " + rs("first_name") + "<br>");
rs.MoveNext();
}
%>
<%
rs.Close();
rs = null;
conn.Close();
conn = null;
%>
</body>
</html>
</snip>
I need more of a database that can be added to and read from on the fly,
online. Like for example I want to take form data and insert into the
database dynamically. Multiple users might even be doing this
simultaneously. Am I using the wrong database solution?
Thanks,
Dave
"Dave" <dg******@sewanee.edu> wrote in message
news:u%****************@TK2MSFTNGP12.phx.gbl... Could be Access. Access has very limited strength when it comes to dishing
out data online.
Access would is best suited for sharing data online if you set it up to
generate a basic html page around midnight (every night if needed). (Look
into using the OS Task Scheduler to automatically call the database file
and to close the file.) Then during the day people only be pulling the html
page and not putting any demand on Access.
You could then set up a Data Access Page (Access 2000 and above) to update
the database from within the office. (Data Access Pages are really useful
on an intranet basis. You can use them on the internet provided the user is
known. (You could update the database from home.))
Dave
"Dave" <ne*****@yahoo.com> wrote in message
news:Mj********************@comcast.com... Hey,
I'm running a localhost web server...W2K with IIS 5.0, and I'm trying to
use ASP/ADO to access my Access database. When I first load the page,
everything works, but if i hit refresh (F5 or even Ctrl-F5), I get "page cannot be
displayed" with the problem line of code being the database Open command
(the starred line in the snippet below). If I press Refresh repeatedly,
that doesn't help. After a minute or two, refreshing the page does access
the database, but then the problem begins again with the very next refresh.
I'm not sure where the problem is...in Access, ASP, ADO, IIS, or something
important I left out of the HTML. Has anyone experienced this?
Thanks,
Dave
<snip>
<%@ Language="JScript" %>
<html>
<head>
<title>DataBase Fun!</title>
</head>
<body>
<%
Session.Timeout = 15;
conn = Server.CreateObject("ADODB.Connection");
**********conn.Open("obdc_exmp");
%>
<%
strSQLQuery = "SELECT * FROM names";
rs = Server.CreateObject("ADODB.Recordset");
rs.Open(strSQLQuery, conn, 3, 3);
%>
<%
while (!rs.EOF)
{
Response.Write(rs("last_name") + ", " + rs("first_name") + "<br>");
rs.MoveNext();
}
%>
<%
rs.Close();
rs = null;
conn.Close();
conn = null;
%>
</body>
</html>
</snip>
Don't recall if I emailed directly.
Look into using SQL (in place of Access). SQL can support many simultaneous
users in real time.
Dave
"Dave" <ne*****@yahoo.com> wrote in message
news:92********************@comcast.com... I need more of a database that can be added to and read from on the fly,
online. Like for example I want to take form data and insert into the
database dynamically. Multiple users might even be doing this
simultaneously. Am I using the wrong database solution?
Thanks,
Dave
"Dave" <dg******@sewanee.edu> wrote in message
news:u%****************@TK2MSFTNGP12.phx.gbl... Could be Access. Access has very limited strength when it comes to
dishing out data online.
Access would is best suited for sharing data online if you set it up to
generate a basic html page around midnight (every night if needed).
(Look into using the OS Task Scheduler to automatically call the database file and to close the file.) Then during the day people only be pulling the html
page and not putting any demand on Access.
You could then set up a Data Access Page (Access 2000 and above) to
update the database from within the office. (Data Access Pages are really
useful on an intranet basis. You can use them on the internet provided the user is
known. (You could update the database from home.))
Dave
"Dave" <ne*****@yahoo.com> wrote in message
news:Mj********************@comcast.com... Hey,
I'm running a localhost web server...W2K with IIS 5.0, and I'm trying
to use ASP/ADO to access my Access database. When I first load the page,
everything works, but if i hit refresh (F5 or even Ctrl-F5), I get "page cannot
be displayed" with the problem line of code being the database Open
command (the starred line in the snippet below). If I press Refresh
repeatedly, that doesn't help. After a minute or two, refreshing the page does access the database, but then the problem begins again with the very next
refresh. I'm not sure where the problem is...in Access, ASP, ADO, IIS, or something
important I left out of the HTML. Has anyone experienced this?
Thanks,
Dave
<snip>
<%@ Language="JScript" %>
<html>
<head>
<title>DataBase Fun!</title>
</head>
<body>
<%
Session.Timeout = 15;
conn = Server.CreateObject("ADODB.Connection");
**********conn.Open("obdc_exmp");
%>
<%
strSQLQuery = "SELECT * FROM names";
rs = Server.CreateObject("ADODB.Recordset");
rs.Open(strSQLQuery, conn, 3, 3);
%>
<%
while (!rs.EOF)
{
Response.Write(rs("last_name") + ", " + rs("first_name") + "<br>");
rs.MoveNext();
}
%>
<%
rs.Close();
rs = null;
conn.Close();
conn = null;
%>
</body>
</html>
</snip>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Mark |
last post by:
I have a working PHP/MySQL application used for data entry. The data
entry screen includes a "Save" button. The PHP code for this button
looks like this:
if (isset($_POST))
{
if ($_POST ==...
|
by: Noel Wood |
last post by:
Hello,
I have a problem that I'm sure is simple but I have searched the newsgroup
and have not found it posted before so I apologize if it has been asked
heaps of times before.
I have a page that...
|
by: Scott |
last post by:
I have a clickable graph that resides on page 1. If user clicks a data point
on the graph, the page runs again yeilding a 2nd graph that shows a more
detailed graph.
Problem is, I have a...
|
by: Steve |
last post by:
Hi,
I have a private website for 20 people that is similar to a web email client
like hotmail.
There are two frames, one on the left with links for "New", "History",
"Todays" and a frame on the...
|
by: Tarken |
last post by:
Hi,
I am trying to do some refactoring of a web site to ensure that it displays in
the most web clients possible. One of the pages requires to be redirected to
another automatically, for one...
|
by: tasmisr |
last post by:
This is an old problem,, but I never had it so bad like this before,,
the events are refiring when clicking the Browser refresh button.
In the Submit button in my webform, I capture the server side...
|
by: ppatel |
last post by:
Problem
I have a problem with web image button control click event. The click event does not get trigger until it has not been clicked once or page refresh occures(which is fine).
When click...
|
by: martin1 |
last post by:
All,
is there window form refresh property? I try to set up window form refresh
per minute. Thanks
|
by: kartheek |
last post by:
hi friends,
can any one out here help me by giving me the code to connect to an MSACCESS database using javascript.
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |
