We've got a customer that hasn't changed anything about their website (supposedly) and the ASP stopped working sometime in the last week. It's currently being hosted hosted elsewhere. We moved the site to our server to hopefully help them out, and we get the same error:
Microsoft JET Database Engine error '80004005'
/manufacturers.asp, line 13
Unspecified error: That's quite helpful! This same thing happens on several of their ASP scripts, and the code is:
Dim objConn 'As ADODB.Connection
Dim objRS 'As ADODB.RecordSet
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRS = Server.CreateObject("ADODB.RecordSet")
mdbfile = "rb.mdb"
connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(mdbfile) & ";"
objConn.Open connstr <--------This is line 13
I've found from googling that it's usually a permissions issue. I've given their IUSER full permissions on the database itself and also the htdocs directory. I've also found some people mentioning that you need to give the IUSER permissions to WINNT and TEMP, but we're running Server 2003, so I can't tell that that's even a valid thing to do, since it's not NT. I tried it on Temp, but it didn't help. Please help!