ASP Unspecified Error 80004005

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'

Unspecified error

/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!

Thanks!
Blair

brownlbAsked:
Who is Participating?
 
Computer101Connect With a Mentor Commented:
PAQed with points refunded (250)

Computer101
EE Admin
0
 
iscodeCommented:
0
 
brownlbAuthor Commented:
I have, but that's for NT 4.0.  I'm basing that off of:
Environment variables are set under Windows NT 4.0 by going to the Control Panel and clicking System and then selecting the Environment tab.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
brownlbAuthor Commented:
There is no Environment tab in 2003.
0
 
kevp75Commented:
try using the physical path to the mdb file, rather than using a server.mappath
0
 
brownlbAuthor Commented:
Can you tell me what that code would be?  The physical path is C:\Inetpub\vhosts\domainname\rb.mdb.  I'm not familiar with the server.mappath anyway.
0
 
kevp75Commented:
change this line:
connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(mdbfile) & ";"

to:
connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\vhosts\domainname\rb.mdb;"
0
 
brownlbAuthor Commented:
Thank you.

Alas, that didn't make any difference.
0
 
carlmahonCommented:
I had the same error moving access db to a new 2003 server. It was resolved with permissions. The web user account needed permissions to access the file.

This post has some other good tips
http://www.experts-exchange.com/Web/Web_Languages/ASP/Q_20348344.html
0
 
kevp75Commented:
yeah....on the file, and the containing folder.....   (but, questioner stated they already tried that..)
0
 
brownlbAuthor Commented:
Yep, I've already tried the permissions to no avail.
0
 
kevp75Commented:
0
 
brownlbAuthor Commented:
Okay, it started working for absolutely no reason: on their old server and the new server it's on.  I love how things in MS world are cloaked in mystery....
0
All Courses

From novice to tech pro — start learning today.