I have been "Googling" for about an hour and am turning up squat! I just
started receiving this error when trying to log into a MS Access database
from a vb .net web application. Recycling IIS seems to temporarily fix the
problem, but I am at a loss on how to view the total # of "active" sessions,
etc... any ideas or suggestions would be greatly appreciated!
Could not start session. Too many sessions already active.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.Data.Ole Db.OleDbExcepti on: Could not start
session. Too many sessions already active
6  3702 
You are not very descriptive.
What do you mean by "log into" MS Access.....
Most likely your application does not close DB Connections. hence the
message when too many are open
Show us your code where you retrieve data from MS Access.
George.
"bill" <bi**@nospam.co mwrote in message
news:Pb******** *****@newsfe05. lga...
>I have been "Googling" for about an hour and am turning up squat! I just
started receiving this error when trying to log into a MS Access database
from a vb .net web application. Recycling IIS seems to temporarily fix the
problem, but I am at a loss on how to view the total # of "active"
sessions, etc... any ideas or suggestions would be greatly appreciated!
Could not start session. Too many sessions already active.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.Data.Ole Db.OleDbExcepti on: Could not start
session. Too many sessions already active
Sorry about that.... here is a snip of sample code. We have Close
statements throughout the pages, so I am thinking it isn't that... but I
could be missing something?
Dim myConn As New OleDbConnection (AppSettings("m yConnectionStri ng"))
Dim mySQL As String = "SELECT * FROM myTable WHERE ID=" & myID
Dim cmd As New OleDbCommand(my SQL, myConn)
Dim da As New OleDbDataAdapte r
Dim ds As New DataSet
da.SelectComman d = cmd
da.Fill(ds, "myTable")
myConn.Close()
note that myConnectionStr ing is set to
"PROVIDER=Micro soft.Jet.OLEDB. 4.0;DATA SOURCE=D:\data\ myDatabase.mdb" />
"George Ter-Saakov" <gt****@cardone .comwrote in message
news:%2******** ********@TK2MSF TNGP04.phx.gbl. ..
You are not very descriptive.
What do you mean by "log into" MS Access.....
Most likely your application does not close DB Connections. hence the
message when too many are open
Show us your code where you retrieve data from MS Access.
George.
"bill" <bi**@nospam.co mwrote in message
news:Pb******** *****@newsfe05. lga...
>>I have been "Googling" for about an hour and am turning up squat! I just
started receiving this error when trying to log into a MS Access database
from a vb .net web application. Recycling IIS seems to temporarily fix
the problem, but I am at a loss on how to view the total # of "active"
sessions, etc... any ideas or suggestions would be greatly appreciated!
Could not start session. Too many sessions already active.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.Data.Ole Db.OleDbExcepti on: Could not start
session. Too many sessions already active
Your code has a problem in case there is an error thrown. Connection will
never be closed...
Proper way would be to enclose it with try... catch ( do not know how it is
in VB)
George
"bill" <bi**@nospam.co mwrote in message
news:Rs******** *****@newsfe05. lga...
Sorry about that.... here is a snip of sample code. We have Close
statements throughout the pages, so I am thinking it isn't that... but I
could be missing something?
Dim myConn As New
OleDbConnection (AppSettings("m yConnectionStri ng"))
Dim mySQL As String = "SELECT * FROM myTable WHERE ID=" & myID
Dim cmd As New OleDbCommand(my SQL, myConn)
Dim da As New OleDbDataAdapte r
Dim ds As New DataSet
da.SelectComman d = cmd
da.Fill(ds, "myTable")
myConn.Close()
note that myConnectionStr ing is set to
"PROVIDER=Micro soft.Jet.OLEDB. 4.0;DATA SOURCE=D:\data\ myDatabase.mdb" />
"George Ter-Saakov" <gt****@cardone .comwrote in message
news:%2******** ********@TK2MSF TNGP04.phx.gbl. ..
>You are not very descriptive.
What do you mean by "log into" MS Access.....
Most likely your application does not close DB Connections. hence the
message when too many are open
Show us your code where you retrieve data from MS Access.
George.
"bill" <bi**@nospam.co mwrote in message
news:Pb******* ******@newsfe05 .lga...
>>>I have been "Googling" for about an hour and am turning up squat! I just
started receiving this error when trying to log into a MS Access database
from a vb .net web application. Recycling IIS seems to temporarily fix
the problem, but I am at a loss on how to view the total # of "active"
sessions, etc... any ideas or suggestions would be greatly appreciated!
Could not start session. Too many sessions already active.
Description : An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.Data.Ole Db.OleDbExcepti on: Could not start
session. Too many sessions already active
What you have found out is that MS Access is not designed to handle a large
concurrent user load and is especially not advisable to use for a web
application. You can upgrade to SQLExpress, which is free and uses the SQL
Server 2005 engine.
-- Peter http://www.eggheadcafe.com
unBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder: http://www.blogmetafinder.com
"bill" wrote:
I have been "Googling" for about an hour and am turning up squat! I just
started receiving this error when trying to log into a MS Access database
from a vb .net web application. Recycling IIS seems to temporarily fix the
problem, but I am at a loss on how to view the total # of "active" sessions,
etc... any ideas or suggestions would be greatly appreciated!
Could not start session. Too many sessions already active.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.Data.Ole Db.OleDbExcepti on: Could not start
session. Too many sessions already active
close your connection in the "Finally" section of your try catch statement
provided it is not null or nothing.
Are you using XP as your web server for testing then it might have
limitations on the number of connections to it.
"George Ter-Saakov" <gt****@cardone .comwrote in message
news:Om******** ******@TK2MSFTN GP02.phx.gbl...
Your code has a problem in case there is an error thrown. Connection will
never be closed...
Proper way would be to enclose it with try... catch ( do not know how it
is in VB)
George
"bill" <bi**@nospam.co mwrote in message
news:Rs******** *****@newsfe05. lga...
>Sorry about that.... here is a snip of sample code. We have Close
statements throughout the pages, so I am thinking it isn't that... but I
could be missing something?
Dim myConn As New
OleDbConnectio n(AppSettings(" myConnectionStr ing"))
Dim mySQL As String = "SELECT * FROM myTable WHERE ID=" & myID
Dim cmd As New OleDbCommand(my SQL, myConn)
Dim da As New OleDbDataAdapte r
Dim ds As New DataSet
da.SelectComman d = cmd
da.Fill(ds, "myTable")
myConn.Close()
note that myConnectionStr ing is set to
"PROVIDER=Micr osoft.Jet.OLEDB .4.0;DATA SOURCE=D:\data\ myDatabase.mdb" />
"George Ter-Saakov" <gt****@cardone .comwrote in message
news:%2******* *********@TK2MS FTNGP04.phx.gbl ...
>>You are not very descriptive.
What do you mean by "log into" MS Access.....
Most likely your application does not close DB Connections. hence the
message when too many are open
Show us your code where you retrieve data from MS Access.
George.
"bill" <bi**@nospam.co mwrote in message
news:Pb****** *******@newsfe0 5.lga...
I have been "Googling" for about an hour and am turning up squat! I
just started receiving this error when trying to log into a MS Access
database from a vb .net web application. Recycling IIS seems to
temporari ly fix the problem, but I am at a loss on how to view the total
# of "active" sessions, etc... any ideas or suggestions would be greatly
appreciated !
Could not start session. Too many sessions already active.
Descriptio n: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
informatio n about the error and where it originated in the code.
Exception Details: System.Data.Ole Db.OleDbExcepti on: Could not start
session. Too many sessions already active
Here is what is strange... we never got those errors UNTIL I put in the
close statements. Prior to last week, the database connections were never
programmaticall y being closed... it just doesn't make sense to me...
"LVP" <lv**********@h otmail.comwrote in message
news:%2******** ********@TK2MSF TNGP06.phx.gbl. ..
close your connection in the "Finally" section of your try catch
statement provided it is not null or nothing.
Are you using XP as your web server for testing then it might have
limitations on the number of connections to it.
"George Ter-Saakov" <gt****@cardone .comwrote in message
news:Om******** ******@TK2MSFTN GP02.phx.gbl...
>Your code has a problem in case there is an error thrown. Connection will
never be closed...
Proper way would be to enclose it with try... catch ( do not know how it
is in VB)
George
"bill" <bi**@nospam.co mwrote in message
news:Rs******* ******@newsfe05 .lga...
>>Sorry about that.... here is a snip of sample code. We have Close
statements throughout the pages, so I am thinking it isn't that... but
I could be missing something?
Dim myConn As New
OleDbConnecti on(AppSettings( "myConnectionSt ring"))
Dim mySQL As String = "SELECT * FROM myTable WHERE ID=" & myID
Dim cmd As New OleDbCommand(my SQL, myConn)
Dim da As New OleDbDataAdapte r
Dim ds As New DataSet
da.SelectComman d = cmd
da.Fill(ds, "myTable")
myConn.Close()
note that myConnectionStr ing is set to
"PROVIDER=Mic rosoft.Jet.OLED B.4.0;DATA SOURCE=D:\data\ myDatabase.mdb" />
"George Ter-Saakov" <gt****@cardone .comwrote in message
news:%2****** **********@TK2M SFTNGP04.phx.gb l...
You are not very descriptive.
What do you mean by "log into" MS Access.....
Most likely your application does not close DB Connections. hence the
message when too many are open
Show us your code where you retrieve data from MS Access.
George.
"bill" <bi**@nospam.co mwrote in message
news:Pb***** ********@newsfe 05.lga...
>I have been "Googling" for about an hour and am turning up squat! I
>just started receiving this error when trying to log into a MS Access
>database from a vb .net web application. Recycling IIS seems to
>temporaril y fix the problem, but I am at a loss on how to view the
>total # of "active" sessions, etc... any ideas or suggestions would be
>greatly appreciated!
>
>
>
Could not start session. Too many sessions already active.
Description : An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
informati on about the error and where it originated in the code.
>
Exception Details: System.Data.Ole Db.OleDbExcepti on: Could not start
session. Too many sessions already active
>
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Maxime Ducharme |
last post by:
Hi group
We have a problem with sessions in one of our sites.
Sessions are used to store login info & some other infos
(no objects are stored in sessions).
We are using Windows 2000 Server (IIS 5.0) with
ASP 3.0 (no .NET on this site).
Sometime, data in session is emptied. I say "sometime"
|
by: Christina N |
last post by:
Can anyone give me a code example of how to use a global array to keep track
of
all active sessions (their sessionid, logontime, etc)?
I need a code example, not a prosa description of what to do..
Anyone..?
Best regards,
Christina
|
by: Lenn |
last post by:
Hello,
This requirement might seem strange to someone out there, but here it's
We need to make sure only certain number of users can be logged in the site
at the same time. Is there any way to do that in ASP.NET, in web config file
or otherwise. Thanks in advance for your help.
|
by: Laurent Bugnion |
last post by:
Hi,
I am wondering what is the best way to find out which ASP.NET sessions
are still active.
Here is the reason: I have a custom control which can upload files. It
saves the files in a folder named after the SessionID. At Session_End, I
do some cleanup and delete the "session folder". However, if the PC is
rebooted before the session times out, the clean up never happens. So
what I wanted to do isL: In my CleanUp method, check all...
|
by: tbone |
last post by:
In trying to improve the throughput of a classic ASP app I wrote last
year, I added monitoring to the application and session start and end
methods. For one, I'm counting the total number of sessions and the
high water mark. My monitoring has revealed a few interesting things.
1. The ASP application is being shutdown and restarted almost daily.
The hosting company swears that neither the machine (shared server)
nor IIS nor the...
| | |
by: kpg |
last post by:
Hi all,
Ah yes, the age old counting session question.
sessionstate
mode="InProc"
timeout="5"
Sub Application_Start()
Application("ConcurrentUsers") = 0
|
by: Atul |
last post by:
Hi,
I am running .NET Framework 2.0 on windows XP SP2. I am stuck in a situation
where I need to find out a list of all active sessions running in IIS for a
web application.
I know that .NET 2.0 has introduced a new class that facilitate this task
very easily, somehow couldnt recall its name.
Any help would be highly appreciated.
|
by: JoeSep |
last post by:
Hello,
I know that when the SessionState is set to SQL Server (ASP.NET 1.1) these
counters in PerfMon are not valued:
- Sessions Abandoned
- Sessions Active
- Sessions Timed Out
- Sessions Total
Is there another way to get these counters (especially "Sessions Active")
when the SessionState is set to SQL Server?
Thanks in advance!
|
by: Krish........... |
last post by:
Hi all,
How to find out no of active sessions (at a time) in the web
server.. I dont think handling Session_start and Session_end events
are useful for this. Is there any way to find all current active
sessions by using Application object ?
Thanx,
Krish....
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
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: 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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
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...
| |
