Database connection issues

I intermittently get this error on pages using Access and SQL. The errors happen at the same time for both then stop at the same time for both.




Microsoft VBScript runtime error '800a01fb'


An exception occurred: 'Open'


/locations/locations.asp, line 20

 

This error continues to show up. It happens on unrelated pages, some have SQL databases some have Access.I realize that Access is less robust so I use an OLEDBconnection object that is destroyed at the bottom of every page (just to be sure I'm freeing up the resources). For the SQL pages, I'm using a regular connection string provided by discountasp.net. That being said, I'm reasonably surethe bottleneck is not db connections.

I can't figure out why these errors show up on both types of pages at the same time and why they stop together too. It seems to be something other than the db connections, right?

Thanks.

 

Yeah, I have seen those postings and have taken a lot of time going back to check my pages, but it has not solved the problem...


Yes, I am getting this error on Access and SQL. Usually at the same time, but not always.


I know that I am closing the connections and destroying the objects on every page that uses Access. I even use a connection object and destroy that too. On the SQL pages... I'm not 100% sure but I have gone over the pages several times.


These pages are relatively low volume. The Access pages probably get around 50 page views per day total. Since I use a connection object for each page and reuse it, that's a max of 50 db connections per day (which are being destroyed). The SQL pages probably get less than 500. Can that kind of volume really kill both Access and SQL?

 

Here are a couple of other errors I've been getting. Like the 'Open' error, these are intermittent.Could theyall be caused by the same bug?





Microsoft VBScript runtime error '800a01fb'


An exception occurred: 'Execute'


/intranet/issues/issue_detail.asp, line 111</BLOCKQUOTE>
-----------------------------------------------



Active Server Pages error 'ASP 0241'


CreateObject Exception


/intranet/issues/issue_detail.asp


The CreateObject of '(null)' caused exception C0000005.


Active Server Pages error 'ASP 0241'


CreateObject Exception


/intranet/issues/issue_detail.asp


The CreateObject of '(null)' caused exception C0000005.


Server object error 'ASP 0177 : c0000005'


Server.CreateObject Failed


E:\WEB\QUICKSELLIT\HTDOCS\INTRANET\ISSUES\../../Connections/issues.asp, line 16


c0000005 </BLOCKQUOTE>
---------------------------------------