Solved

ASP Unspecified Error 80004005

Posted on 2006-11-17
15
349 Views
Last Modified: 2012-06-27
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

0
Comment
Question by:brownlb
15 Comments
 
LVL 6

Expert Comment

by:iscode
Comment Utility
0
 

Author Comment

by:brownlb
Comment Utility
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
 

Author Comment

by:brownlb
Comment Utility
There is no Environment tab in 2003.
0
 
LVL 25

Expert Comment

by:kevp75
Comment Utility
try using the physical path to the mdb file, rather than using a server.mappath
0
 

Author Comment

by:brownlb
Comment Utility
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
 
LVL 25

Expert Comment

by:kevp75
Comment Utility
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
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 

Author Comment

by:brownlb
Comment Utility
Thank you.

Alas, that didn't make any difference.
0
 
LVL 4

Expert Comment

by:carlmahon
Comment Utility
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
 
LVL 25

Expert Comment

by:kevp75
Comment Utility
yeah....on the file, and the containing folder.....   (but, questioner stated they already tried that..)
0
 

Author Comment

by:brownlb
Comment Utility
Yep, I've already tried the permissions to no avail.
0
 
LVL 25

Expert Comment

by:kevp75
Comment Utility
0
 

Author Comment

by:brownlb
Comment Utility
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
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
Comment Utility
PAQed with points refunded (250)

Computer101
EE Admin
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now