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


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

    Server object error 'ASP 0177 : c0000005'

    Server.CreateObject Failed

    /index.asp, line 166


  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
    Last edited by a moderator: Oct 14, 2015
  3. FredC

    FredC WinHost Staff


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

Share This Page