IIS 7 Access and asp

[Julien ROUX]

Hello, sorry for my "bad english" !,

I have a problem with vista (iis 7), the line work good on iis XP pro :

conn.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" &
Server.MapPath("db/lang.mdb") & ";"

but not work on vista !this is the error :

Microsoft OLE DB Provider for ODBC Drivers erreur '80004005'
[Microsoft][Pilote ODBC Microsoft Access].
/accesBase.asp, line 6 --> the line with : "conn.open"

If i type response.write(Server.MapPath("db/lang.mdb")) I have the good file
(lang.asp)
Please help !!!

thanks

Julien ROUX

[Daniel Crichton]

The important part of the error to resolve this is missing from your post.
After the [Pilote ODBC Microsoft Access] there should be a description of
the error, such as those shown on this page:

http://support.microsoft.com/kb/306518

The error description will help determine what the problem actually is.

Dan

[Julien ROUX]

Sorry, the full error is :

in french :

Microsoft OLE DB Provider for ODBC Drivers erreur '80004005'

[Microsoft][Pilote ODBC Microsoft Access] Erreur réseau ou erreur
disque.
/accesBase.asp, ligne 5
in english :

Microsoft OLE DB Provider for ODBC Drivers erreur '80004005'

[Microsoft][Pilote ODBC Microsoft Access] Network error or disk error.
/accesBase.asp, line 5

my db has NetworkService right

thanks

"Daniel Crichton" <msn...@worldofspack.com> a écrit dans le message de
news:%23Q7LLce...@TK2MSFTNGP02.phx.gbl...

[Tray]

I like to use the following in XP, but don't know if it will work in Vista

set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/inetpub/directory/db/database.mdb"

The biggest security is keeping the smart people confused.

[Daniel Crichton]

Julien wrote on Tue, 6 Feb 2007 16:38:45 +0100:

> Sorry, the full error is :
>
> in french :
> Microsoft OLE DB Provider for ODBC Drivers erreur '80004005'
> [Microsoft][Pilote ODBC Microsoft Access] Erreur réseau ou erreur
> disque.
> /accesBase.asp, ligne 5
> in english :
> Microsoft OLE DB Provider for ODBC Drivers erreur '80004005'
> [Microsoft][Pilote ODBC Microsoft Access] Network error or disk error.
> /accesBase.asp, line 5
>
> my db has NetworkService right

Does your IIS user account have write access to the %TEMP% dir? Does it have
write access to the directory the mdb file is stored in? This error suggests
that there are insufficient permissions to allow writing of either the temp
files or the .ldb (lock file). It could also be due to lack of disk space,
or due to bad sectors on the hard drive. If your web files are themselves
located on a network share this could also be an issue - I've only ever seen
this error myself when working with Access databases on network shares and
there have been communication problems.

Dan