Microsoft JET Database Engine error "80004005" on a New Server

Please help! I've been scouring the newsgroups and been through
Microsoft's troubleshooting page, but can't find anything to fix this,
so far. It sounds like a lot of people have been having a similar
problem, though.

We just copied an ASP website and MS Access 2000 database to a new
server, in order to test it before moving it, and I'm getting this
error:

Microsoft JET Database Engine error '80004005'

Unspecified error

/script/dbConn.asp, line 16

Line 16 says:

objConn.Open = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Websites\database\intranet_v5.mdb"


Previously, line 16 said:

objConn.Open = "DSN=intranet_v5"

But then I got this error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
engine cannot open the file '(unknown)'. It is already opened
exclusively by another user, or you need permission to view its data.

/script/dbConn.asp, line 16

The old server was Windows 2000 Server with IIS 5 and the new one is
Windows 2003 Server with IIS 6.

IUSR_ seems to have all the appropriate permissions, in fact, for
testing, it has full control over the database and it's folder.

I've compared the IIS settings for the site and they match as exact as
is possible for the two versions of IIS.

The 2003 Server hosts another ASP website, but it uses an SQL database.

Any help would be appreciated!

Thanks,

K. De

Re: Microsoft JET Database Engine error "80004005" on a New Server

bluerose_0@hotmail.com wrote:
> Please help! I've been scouring the newsgroups and been through
> Microsoft's troubleshooting page, but can't find anything to fix this,
> so far. It sounds like a lot of people have been having a similar
> problem, though.
>
> We just copied an ASP website and MS Access 2000 database to a new
> server, in order to test it before moving it, and I'm getting this
> error:
>
> Microsoft JET Database Engine error '80004005'

So you've been here?
http://www.aspfaq.com/show.asp?id=2009

>
> Unspecified error
>
> /script/dbConn.asp, line 16
>
> Line 16 says:
>
> objConn.Open = "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=C:\Websites\database\intranet_v5.mdb"
>

Good

>
> Previously, line 16 said:
>
> objConn.Open = "DSN=intranet_v5"
>
> But then I got this error:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
> engine cannot open the file '(unknown)'. It is already opened
> exclusively by another user, or you need permission to view its data.
>
> /script/dbConn.asp, line 16
>
> The old server was Windows 2000 Server with IIS 5 and the new one is
> Windows 2003 Server with IIS 6.
>
> IUSR_ seems to have all the appropriate permissions, in fact, for
> testing, it has full control over the database and it's folder.

What about IWAM_ ?
Depending on where the code is running, or what isolation configuration
you've chosen for the website in IIS Mgr, the IWAM account may be the one
doing the work.




--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: Microsoft JET Database Engine error "80004005" on a New Server

It turned out that IUSR didn't have sufficient NTFS permissions for the
Temp directory. It's working now, but I'd like to get it working with
the DSN, so any suggestions along those lines would be greatly
appreciated!

Thanks!

K De

Re: Microsoft JET Database Engine error "80004005" on a New Server

bluerose_0@hotmail.com wrote:
> It turned out that IUSR didn't have sufficient NTFS permissions for the
> Temp directory. It's working now, but I'd like to get it working with
> the DSN, so any suggestions along those lines would be greatly
> appreciated!

Yes. Don't.

http://www.aspfaq.com/show.asp?id=2126

--
Mike Brind