Server.CreateObject Failed message

Discussion in 'Databases' started by 6toejam, Apr 5, 2011.

Thread Status:
Not open for further replies.
  1. 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!
  2. Ray

    Ray WinHost Staff

    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
  3. FredC

    FredC WinHost Staff

    6toejam,

    i recommend you consider updating your applicatioin to use SQL
Thread Status:
Not open for further replies.

Share This Page