Too many sessions already active

[bill]

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.OleDb.OleDbException: Could not start
session. Too many sessions already active

[George Ter-Saakov]

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.comwrote 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.OleDb.OleDbException: Could not start
session. Too many sessions already active

[bill]

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("myConnectionString"))
Dim mySQL As String = "SELECT * FROM myTable WHERE ID=" & myID
Dim cmd As New OleDbCommand(mySQL, myConn)
Dim da As New OleDbDataAdapter
Dim ds As New DataSet
da.SelectCommand = cmd
da.Fill(ds, "myTable")
myConn.Close()

note that myConnectionString is set to
"PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=D:\data\myDatabase.mdb" />

"George Ter-Saakov" <gt****@cardone.comwrote in message
news:%2****************@TK2MSFTNGP04.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.comwrote 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.OleDb.OleDbException: Could not start
session. Too many sessions already active

[George Ter-Saakov]

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.comwrote 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("myConnectionString"))
Dim mySQL As String = "SELECT * FROM myTable WHERE ID=" & myID
Dim cmd As New OleDbCommand(mySQL, myConn)
Dim da As New OleDbDataAdapter
Dim ds As New DataSet
da.SelectCommand = cmd
da.Fill(ds, "myTable")
myConn.Close()

note that myConnectionString is set to
"PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=D:\data\myDatabase.mdb" />

"George Ter-Saakov" <gt****@cardone.comwrote in message
news:%2****************@TK2MSFTNGP04.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.comwrote 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.OleDb.OleDbException: Could not start
session. Too many sessions already active

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

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.OleDb.OleDbException: Could not start
session. Too many sessions already active

[LVP]

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**************@TK2MSFTNGP02.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.comwrote 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("myConnectionString") )
Dim mySQL As String = "SELECT * FROM myTable WHERE ID=" & myID
Dim cmd As New OleDbCommand(mySQL, myConn)
Dim da As New OleDbDataAdapter
Dim ds As New DataSet
da.SelectCommand = cmd
da.Fill(ds, "myTable")
myConn.Close()

note that myConnectionString is set to
"PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=D:\data\myDatabase.mdb" />

"George Ter-Saakov" <gt****@cardone.comwrote in message
news:%2****************@TK2MSFTNGP04.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.comwrote 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.OleDb.OleDbException: Could not start
session. Too many sessions already active

[bill]

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
programmatically being closed... it just doesn't make sense to me...

"LVP" <lv**********@hotmail.comwrote in message
news:%2****************@TK2MSFTNGP06.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**************@TK2MSFTNGP02.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.comwrote 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("myConnectionString" ))
Dim mySQL As String = "SELECT * FROM myTable WHERE ID=" & myID
Dim cmd As New OleDbCommand(mySQL, myConn)
Dim da As New OleDbDataAdapter
Dim ds As New DataSet
da.SelectCommand = cmd
da.Fill(ds, "myTable")
myConn.Close()

note that myConnectionString is set to
"PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=D:\data\myDatabase.mdb" />

"George Ter-Saakov" <gt****@cardone.comwrote in message
news:%2****************@TK2MSFTNGP04.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.comwrote 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.OleDb.OleDbException: Could not start
session. Too many sessions already active
>
>