Hi,
I'm having my ASP.NET application hosted at a Windows 2003 server (IIS6).
This works almost all the time (I have uptimes of 100% on most days), but
then all of a sudden a few days in a row I have the following phenomenon:
..aspx still get processed, but as soon as any of them try to read/write to a
MsAccess database (using DSNLess OleDBConnection ) it's timing out.
This happens for a period of about 40 minutes and then all of a sudden
everything starts working again without any user intervention.
Has anyone had the same problems ?
Thanks,
Wim 4 1541
Access is not designed for Internet use. It is designed as a desktop/LAN
database. However, ANY OLE DB-compliant database can be used in an ASP.Net
application. The upside is cost; an .mdb database is free of licensing fees.
The downside is performance. You may have too many concurrent users for
Access to handle at times. Check your web server logs to see if there is a
correspondence of heavy traffic to these errors.
--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
"Annick Van Hoof" <me@here.nospam > wrote in message
news:Oc******** ******@TK2MSFTN GP09.phx.gbl... Hi,
I'm having my ASP.NET application hosted at a Windows 2003 server (IIS6). This works almost all the time (I have uptimes of 100% on most days), but then all of a sudden a few days in a row I have the following phenomenon:
.aspx still get processed, but as soon as any of them try to read/write to
a MsAccess database (using DSNLess OleDBConnection ) it's timing out.
This happens for a period of about 40 minutes and then all of a sudden everything starts working again without any user intervention.
Has anyone had the same problems ?
Thanks,
Wim
Hi Kevin,
Thanks for your reply: you are absolutely right that a (MS) SQL Server is a
lot beter.
However, the problem occurs on a server that is not really used by the
public. I have a Alertra (uptime checker) account running every 10 minutes
(and that's it).
So concurrent user would not be the problem.
Moreover, when a timeout occurs on one Access databases: all other ASP.NET
pages that are even using other MsAccess files are timing out.
It just seems as if there's a problem with the OleDbConnection .
Can OleDb do connectionpooli n on MsAccess connections ? If so: this might be
a problem ?
Thanks,
Wim
"Kevin Spencer" <ks******@takem pis.com> wrote in message
news:eD******** ******@TK2MSFTN GP10.phx.gbl... Access is not designed for Internet use. It is designed as a desktop/LAN database. However, ANY OLE DB-compliant database can be used in an ASP.Net application. The upside is cost; an .mdb database is free of licensing
fees. The downside is performance. You may have too many concurrent users for Access to handle at times. Check your web server logs to see if there is a correspondence of heavy traffic to these errors.
-- HTH, Kevin Spencer .Net Developer Microsoft MVP Big things are made up of lots of little things.
"Annick Van Hoof" <me@here.nospam > wrote in message news:Oc******** ******@TK2MSFTN GP09.phx.gbl... Hi,
I'm having my ASP.NET application hosted at a Windows 2003 server
(IIS6). This works almost all the time (I have uptimes of 100% on most days),
but then all of a sudden a few days in a row I have the following
phenomenon: .aspx still get processed, but as soon as any of them try to read/write
to a MsAccess database (using DSNLess OleDBConnection ) it's timing out.
This happens for a period of about 40 minutes and then all of a sudden everything starts working again without any user intervention.
Has anyone had the same problems ?
Thanks,
Wim
> Can OleDb do connectionpooli n on MsAccess connections ? If so: this might
be a problem ?
You got me there, WL. I haven't used Access in a web app in years. Have you
tried searching the Knowledge Base?
--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
"WL" <me@here.nospam > wrote in message
news:e$******** ******@TK2MSFTN GP09.phx.gbl... Hi Kevin,
Thanks for your reply: you are absolutely right that a (MS) SQL Server is
a lot beter. However, the problem occurs on a server that is not really used by the public. I have a Alertra (uptime checker) account running every 10 minutes (and that's it). So concurrent user would not be the problem.
Moreover, when a timeout occurs on one Access databases: all other ASP.NET pages that are even using other MsAccess files are timing out. It just seems as if there's a problem with the OleDbConnection .
Can OleDb do connectionpooli n on MsAccess connections ? If so: this might
be a problem ?
Thanks,
Wim
"Kevin Spencer" <ks******@takem pis.com> wrote in message news:eD******** ******@TK2MSFTN GP10.phx.gbl... Access is not designed for Internet use. It is designed as a desktop/LAN database. However, ANY OLE DB-compliant database can be used in an
ASP.Net application. The upside is cost; an .mdb database is free of licensing fees. The downside is performance. You may have too many concurrent users for Access to handle at times. Check your web server logs to see if there is
a correspondence of heavy traffic to these errors.
-- HTH, Kevin Spencer .Net Developer Microsoft MVP Big things are made up of lots of little things.
"Annick Van Hoof" <me@here.nospam > wrote in message news:Oc******** ******@TK2MSFTN GP09.phx.gbl... Hi,
I'm having my ASP.NET application hosted at a Windows 2003 server (IIS6). This works almost all the time (I have uptimes of 100% on most days), but then all of a sudden a few days in a row I have the following phenomenon: .aspx still get processed, but as soon as any of them try to
read/write to a MsAccess database (using DSNLess OleDBConnection ) it's timing out.
This happens for a period of about 40 minutes and then all of a sudden everything starts working again without any user intervention.
Has anyone had the same problems ?
Thanks,
Wim
Yep, not a big success though
I'll just have to try it I guess ...
Thanks,
Wim
"Kevin Spencer" <ks******@takem pis.com> wrote in message
news:en******** ******@tk2msftn gp13.phx.gbl... Can OleDb do connectionpooli n on MsAccess connections ? If so: this
might be a problem ? You got me there, WL. I haven't used Access in a web app in years. Have
you tried searching the Knowledge Base?
-- HTH, Kevin Spencer .Net Developer Microsoft MVP Big things are made up of lots of little things.
"WL" <me@here.nospam > wrote in message news:e$******** ******@TK2MSFTN GP09.phx.gbl... Hi Kevin,
Thanks for your reply: you are absolutely right that a (MS) SQL Server
is a lot beter. However, the problem occurs on a server that is not really used by the public. I have a Alertra (uptime checker) account running every 10
minutes (and that's it). So concurrent user would not be the problem.
Moreover, when a timeout occurs on one Access databases: all other
ASP.NET pages that are even using other MsAccess files are timing out. It just seems as if there's a problem with the OleDbConnection .
Can OleDb do connectionpooli n on MsAccess connections ? If so: this
might be a problem ?
Thanks,
Wim
"Kevin Spencer" <ks******@takem pis.com> wrote in message news:eD******** ******@TK2MSFTN GP10.phx.gbl... Access is not designed for Internet use. It is designed as a
desktop/LAN database. However, ANY OLE DB-compliant database can be used in an ASP.Net application. The upside is cost; an .mdb database is free of licensing fees. The downside is performance. You may have too many concurrent users
for Access to handle at times. Check your web server logs to see if there
is a correspondence of heavy traffic to these errors.
-- HTH, Kevin Spencer .Net Developer Microsoft MVP Big things are made up of lots of little things.
"Annick Van Hoof" <me@here.nospam > wrote in message news:Oc******** ******@TK2MSFTN GP09.phx.gbl... > Hi, > > I'm having my ASP.NET application hosted at a Windows 2003 server (IIS6). > This works almost all the time (I have uptimes of 100% on most
days), but > then all of a sudden a few days in a row I have the following phenomenon: > > .aspx still get processed, but as soon as any of them try to read/write to a > MsAccess database (using DSNLess OleDBConnection ) it's timing out. > > This happens for a period of about 40 minutes and then all of a
sudden > everything starts working again without any user intervention. > > Has anyone had the same problems ? > > Thanks, > > Wim > >
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Déian |
last post by:
Hello everyone,
I have many problems when try to connect MSAccess to an Oracle database, do
you know how to do this (which ODBC driver, what parameters)
Thanks
|
by: Phil Chetcuti |
last post by:
using mysql on linux
connecting tables to an msaccess front end via myodbc 3.51
all works well and has been for some time except mysql time fields
when viewing the linked tables in msaccess all time fields are showing up as
either empty/null or similar to a date format with the exact date of 5/31/21
in it.
has anyone run across this problem? I know its the msaccess side since all
fields including time work well with asp/php pages.
|
by: Brad Burke |
last post by:
From a windows .Net app, I need to 1) check if MSAccess is already open to a
certain Access application. If so, then open a form and find a certain
record. 2) If not open, then open MSAccess and open a secured Access
application and then open a form and find a record. (The Access App is
secured not with a database password but with full user name and password
security.)
I can open the form and find the record OK. I am having problems...
|
by: (Pete Cresswell) |
last post by:
I've got a .BAT file that I use for executing various MS Access apps that I
wrote way back in the days of 2.0.
It's evolved over time, but it still contains a number of possible paths to
MSACCESS.EXE, tries them all, takes the first one it finds, and dies if none is
found.
Seems to me like at some time or another I was able to clone this .BAT file and
implement it with no path. Something about MSACCESS being a registered
application.
|
by: Yelena Varshal via AccessMonster.com |
last post by:
Hello,
I have a problem with one of msaccess.exe API calls that work on my desctop
but does not work on the laptop from within MS ACCESS. There is a lot of
differences between 2 computers including one running Office 2000 and another
running Office 2003. This code was created by a previous developer. I need to
find the description and parameters of the API calls. I found the article
...
| |
by: rolandsk |
last post by:
I need help to schedule a MsAccess procedure I want the procedure to run in backgrund and not the MsAccess file to be open during the time when the procedure runs. The procedure in MsAccess picks data from an oracle database and then create excelfiles. It works good while using the scheduler in MsAccess, but when I do that the MsAccess opens first and I dont want that to happen. I would like to have a bat-file(procedure.bat) scheduled to run...
|
by: Kermit |
last post by:
Hi.
I looked through few pages of threads here, but didn't find the answer to my questions.
I'm writting a C# application (Windows Forms) that uses MSAccess database, and I have the following questions:
1. how can I check in what group the current user's is?
I created a login dialog box, and use the standard connection string to connect:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + database + ";Jet OLEDB:System Database=" + workgroup +...
|
by: bbrewder |
last post by:
I am struggling with some MSAccess automation issues. Basically, we
have a .Net application that uses MSAccess for reporting (legacy
code). We are able to launch MSAccess fine and even work with the
MSAccess COM objects to run our reports (using GetObject(<MDB Path>) -
see http://support.microsoft.com/default.aspx?scid=kb;en-us;317113&Product=vbNET
for info on how to do this).
The problem that we are running into is that if our Access...
|
by: jdaelhousen |
last post by:
I have a bit of a problem I'm hoping someone can shed some light on...
I have a VB.Net console application written in VS 2003 that produces a .exe file that now sits on a Windows 2000 server directory. This exe does the following 3 things:
1.) Using the VB Interaction SaveSetting() method, it programmatically updates the system registry under the HKEY_CURRENT_USER\SOFTWARE key and saves a directory location used by a PDF driver (so that...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |