|04-05-2011, 11:37 AM||#1|
Join Date: Apr 2011
Server.CreateObject Failed message
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")
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'
The CreateObject of '(null)' caused exception C0000005.
Server object error 'ASP 0177 : c0000005'
/index.asp, line 166
|04-05-2011, 11:45 AM||#2|
Join Date: Aug 2009
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
|access, database, failure, issue, problem|
|Thread Tools||Search this Thread|
|Thread||Thread Starter||Forum||Replies||Last Post|
|Validation of viewstate MAC failed||wlarimore||General troubleshooting||19||12-16-2011 01:27 PM|
|Failed to find or load the registered .Net Framework Data Provider.||Haroon||Databases||3||03-28-2011 09:24 PM|
|System.Security.SecurityException: Request failed||idanon29||Site Programming, Development and Design||4||03-25-2011 01:40 PM|
|Login failed for 'user\Guest'. in web application||shankbond||Site Programming, Development and Design||5||07-09-2010 03:46 PM|
|How can i make server send message to client||giorgos||Site Programming, Development and Design||6||01-29-2010 03:26 PM|