By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,727 Members | 768 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,727 IT Pros & Developers. It's quick & easy.

Authentication Failed - HELP

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.