| View previous topic :: View next topic |
| Author |
Message |
SunsetTowers
-
Joined: 25 Apr 2008
Posts: 6
|
 Posted: Fri Apr 25, 2008 1:53 pm Post subject: Abyss keeping SQL Express Databases Attached. |
 |
|
Server Version 2.5
ASP.NET Version 2.0
.NET Version 3.5
Development Platform - Visual Studio 2008
Database - SQL Express 2005(With advanced Text Services)
Problem
Abyss is keeping the database attached.
Once the page has been served abyss keeps the database attached and it can no longer be connected to from VS until I stop the server.
I get an error in VS similar to this after the server has been allowed to access the database. It is the same error I get if I try to run the program from the server, but have the database connection open in VS. However as soon as I close the connection in VS, the program works fine from the server. However as stated above, the only way to get abyss to release the connect is to stop the server.
Cannot open user default database. Login failed.
Login failed for user 'UserName'.
VS opens the database with a different user name.
This is a problem I never had with IIS. |
|
| Back to top |
  |
 |
rrinc
-
Joined: 24 Feb 2006
Posts: 725
Location: Arkansas, USA
|
| Posted: Fri Apr 25, 2008 11:50 pm Post subject: |
|
|
Abyss Web Server doesn't directly access any databases. It is done by whatever script or application you are visiting. Abyss executes the script (the script accesses the DB), grabs the output and gives it to you. Generally the script or application will then terminate.
_________________
-Blake | New Server :D
SaveTheInternet
Soy hispanohablante. Puedes contactarme por mensajes privados. |
|
| Back to top |
   |
|
aprelium
-
Joined: 22 Mar 2002
Posts: 6800
|
| Posted: Wed Apr 30, 2008 2:44 pm Post subject: Re: Abyss keeping SQL Express Databases Attached. |
|
|
SunsetTowers,
For performance reasons, Abyss Web Server will not unload your ASP.NET application after it has been accessed. This probably why the connection is kept open since your application does not explicitly close it.
_________________
Support Team
Aprelium - http://www.aprelium.com |
|
| Back to top |
 |
|
SunsetTowers
-
Joined: 25 Apr 2008
Posts: 6
|
| Posted: Wed Apr 30, 2008 8:31 pm Post subject: |
|
|
I'm not keeping any connections open. I use only SqlDataSources and use the select, insert, etc statements from there.
What is happening is the database is remaining attached after the page has completed it loading cycle. This means that VS 2008, can not attached the database for editing, nor can I edit the SqlDataSources using the query builder.
On a production server, I would agree with not unloading the application.
Is there a possiblity of getting a development switch so that the application is unloaded after the page has loaded. I mean I am developing locally so the extra time it takes reload the application would be negligeble. |
|
| Back to top |
|
|
aprelium
-
Joined: 22 Mar 2002
Posts: 6800
|
| Posted: Thu May 15, 2008 4:15 pm Post subject: |
|
|
| SunsetTowers wrote: | | Is there a possiblity of getting a development switch so that the application is unloaded after the page has loaded. I mean I am developing locally so the extra time it takes reload the application would be negligeble. |
We suggest setting "FastCGI timeout" to a low value (it is by default 240 seconds, but in your situation, a 10 second value would be fine).
_________________
Support Team
Aprelium - http://www.aprelium.com |
|
| Back to top |
|
|
|
