470,619 Members | 1,860 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,619 developers. It's quick & easy.

Authentication Failed - HELP

Hi,

I'm trying to set up my home pc with 2000 pro IIS 5 installed. After
writing a simple asp page to open a database and pull back the records
of a table to test, I am getting an error :-

c:\inetpub\wwwroot\adotest\backup\myhols.mdb
Provider error '80040e4d'

Authentication failed.

I have checked all the usual errors:-
set up iusr guest account for full rights
set up anomonous authentication
even followed tech nets advise to give iusr 'act as part as os' within
user rights assignment

Microsoft script debugger says it gets the Authentication error on the
following line:-

conn.Open localpath

within

localpth = Server.MapPath("/adotest/backup/myhols.mdb")
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open localpath

Thanks for any help anybody can give me.

Greg C
Jul 19 '05 #1
2 5783
Is the .mdb password protected?

Ray at work

"Teggaman" <gr**********@yahoo.co.uk> wrote in message
news:46**************************@posting.google.c om...
Hi,

I'm trying to set up my home pc with 2000 pro IIS 5 installed. After
writing a simple asp page to open a database and pull back the records
of a table to test, I am getting an error :-

c:\inetpub\wwwroot\adotest\backup\myhols.mdb
Provider error '80040e4d'

Authentication failed.

I have checked all the usual errors:-
set up iusr guest account for full rights
set up anomonous authentication
even followed tech nets advise to give iusr 'act as part as os' within
user rights assignment

Microsoft script debugger says it gets the Authentication error on the
following line:-

conn.Open localpath

within

localpth = Server.MapPath("/adotest/backup/myhols.mdb")
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open localpath

Thanks for any help anybody can give me.

Greg C

Jul 19 '05 #2
Hi Ray,

The Access DB is not protected and I have tried to connect to the
microsoft database shipped with Access to no avail. The problem seems
to lie local with my machine or with IIS 5

Thanks

Greg


Ray at <%=sLocation%>" <myFirstNameATlane34dotKOMM> wrote in message news:<eV**************@tk2msftngp13.phx.gbl>...
Is the .mdb password protected?

Ray at work

"Teggaman" <gr**********@yahoo.co.uk> wrote in message
news:46**************************@posting.google.c om...
Hi,

I'm trying to set up my home pc with 2000 pro IIS 5 installed. After
writing a simple asp page to open a database and pull back the records
of a table to test, I am getting an error :-

c:\inetpub\wwwroot\adotest\backup\myhols.mdb
Provider error '80040e4d'

Authentication failed.

I have checked all the usual errors:-
set up iusr guest account for full rights
set up anomonous authentication
even followed tech nets advise to give iusr 'act as part as os' within
user rights assignment

Microsoft script debugger says it gets the Authentication error on the
following line:-

conn.Open localpath

within

localpth = Server.MapPath("/adotest/backup/myhols.mdb")
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open localpath

Thanks for any help anybody can give me.

Greg C

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Michael Foord | last post: by
4 posts views Thread by Bogdan Chytrek | last post: by
10 posts views Thread by SAL | last post: by
3 posts views Thread by =?Utf-8?B?Um9iZQ==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.