Site Crashed - Need Help w/Error 800a01fb

Hello,
I have a site that was developed for me and the developer is no longer around. It's been working just fine but then all of a sudden I received an error out of nowhere and the site has crashed. I have probably done more damage trying to see if I could fix it because I don't even know if it is on my end or the hosts' server. I am totally lacking in knowledge (does it show yet?) although I have been studying this stuff for years but nothing sticks! Noone from the hosting service is around this weekend to help.
The site uses an access database which is uploaded a lot. The error code I am getting is --



Microsoft VBScript runtime error '800a01fb'
An exception occurred: 'server.CreateObject'
/conn.asp, line 3



The /con asp looks like this --

<%
password="xxx"
set con=server.CreateObject("ADODB.Connection")
con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath("..") & "\xxxx.mdb;Persist Security Info=False;Jet OLEDBatabase Password=" & password
%>

(xxx = correct password and xxxx = correct databse name)



Is the problem with coding or the server?

Can anyone explain to me what causes this?Thanks in advance for any help - leeann
(uhm.. i dont know where the green smiley came from in the word database)

It could be any number of reasons, though the first thing to check is whether the host has made any recent changes/upgrades/moves that would have affected your account.
The next, and most likely reason, is that you have exceeded the number of consecutive connections to the database. Check that your code has a line to close and empty the connection object each time it is finished with.

What would it look like?
And if it isn't there, where should it go?
Thanks again -- leeann

The green smiley comes from ..OLEDBatabase because the two characters; a colon : and a D make a smiley face - like this when you put them together. Take a look at http://forums.aspfree.com/misc.php?do=showsmilies to see the full list of smilies in this forum. All you have to do is type in the combination for the smiley you like and it will appear when you post the message.



P.s. You can disable smilies in Advanced edit mode if you wish. Tick the box 'Disable smilies in text'.

Hi,

The closing tags for the record set and database are below. You would put these after you have executed your SQL Statements against the database and retrieved the record set, and after you have printed out your results, or used them within your page.

Note: From personal experience, you have to close a record set before the database is closed for some reason. I'm not sure why it is, but you'll get an 'Object is already closed' message if you try to close the database first!

Closing record set:

Remember to replace the parts in Italics with whatever is used in your ASP application

Closing the database:

Remember to replace the parts in Italics with whatever is used in your ASP application. In your application, it would be Con, but I thought I'd better keep the code useable to everyone.

It might also be a good idea to set your database password variable to nothing after you have opened the connection with the password


Hope this helps