I coded all my pages to have a DSNless connection and all pages in my site were working fine. Suddenly, the database connection is failing on all pages. Here's an example of the code that was working great, and now is failing: Set oConn = Server.CreateObject("ADODB.Connection") ' DSNLess oConn.Open ("Provider= Microsoft.ACE.OLEDB.12.0;Data Source=" & Server.MapPath("\db\mydatabasename.mdb")) Set rsBands = oConn.Execute("Select * from BandVenueTable Where StartDate =#" & TodaysDate & " # ORDER by VenueName ASC, StartTime ASC") Here's the error it's throwing when invoked: Active Server Pages error 'ASP 0241' CreateObject Exception /index.asp The CreateObject of '(null)' caused exception C0000005. Server object error 'ASP 0177 : c0000005' Server.CreateObject Failed /index.asp, line 166 c0000005 Thanks!
Try logging into your Winhost control panel and go to Site Info Manager/Recycle App Tool and initiate a call to our account to have the application pool recycled. Let me know the results after you recycled your application pool
