Server.CreateObject Failed message

[6toejam]

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!

[Ray]

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

[frankc]

6toejam,

i recommend you consider updating your applicatioin to use SQL