asp calling access database

[Horhayson]

We have an intranet running. asp page making a call to an access 2k
database. When running, we get the following error.

Any ideas on where and what to do to troubleshoot and repair it?

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Disk or network error.
/default.asp, line 20


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)

Page:
GET /default.asp

-----
Code is as follows (line 20 is ConnObj.Open "DBQ="
:
Set ConnObj = Server.CreateObject("ADODB.Connection")
ConnObj.ConnectionTimeout = 15
ConnObj.CommandTimeout = 30

ConnObj.Open "DBQ=" & Server.MapPath("treasuries.mdb") &
";Driver={Microsoft Access Driver
(*.mdb)};DriverId=25;MaxBufferSize=8192;Threads=20 ;", "sa", "sa"

Set CmdObj = Server.CreateObject("ADODB.Command")
CmdObj.ActiveConnection = ConnObj


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Mark Schupp]

first put in

response.write Server.MapPath("treasuries.mdb")

before the attempt to open the db and verify that it is a valid path and
file.

--
Mark Schupp
--
Head of Development
Integrity eLearning
Online Learning Solutions Provider
[email]mschupp@ielearning.com[/email]
[url]http://www.ielearning.com[/url]
714.637.9480 x17


"Horhayson" <dgeorges.1@netzero.com> wrote in message
news:OHKxUf9eDHA.368@TK2MSFTNGP12.phx.gbl...

> We have an intranet running. asp page making a call to an access 2k
> database. When running, we get the following error.
>
> Any ideas on where and what to do to troubleshoot and repair it?
>
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC Microsoft Access Driver] Disk or network error.
> /default.asp, line 20
>
>
> Browser Type:
> Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
>
> Page:
> GET /default.asp
>
> -----
> Code is as follows (line 20 is ConnObj.Open "DBQ="
> :
> Set ConnObj = Server.CreateObject("ADODB.Connection")
> ConnObj.ConnectionTimeout = 15
> ConnObj.CommandTimeout = 30
>
> ConnObj.Open "DBQ=" & Server.MapPath("treasuries.mdb") &
> ";Driver={Microsoft Access Driver
> (*.mdb)};DriverId=25;MaxBufferSize=8192;Threads=20 ;", "sa", "sa"
>
> Set CmdObj = Server.CreateObject("ADODB.Command")
> CmdObj.ActiveConnection = ConnObj
>
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!

[Horhayson]

I put in the code as Mark suggested, and now get the following error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Could not find file
'(unknown)'.
/default.asp, line 21


I wonder if it is a permissions problem with IIS and/or the file
"treasuries.mdb"? To the best of my knowledge, nothing has changed
either code-wise or permissions-wise. I did change the "domain
administrator" password a week or two ago, but I honestly don't think
that that is the problem, or is it?


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Mark Schupp]

Was the path that was written out valid?

--
Mark Schupp
--
Head of Development
Integrity eLearning
Online Learning Solutions Provider
[email]mschupp@ielearning.com[/email]
[url]http://www.ielearning.com[/url]
714.637.9480 x17


"Horhayson" <dgeorges.1@netzero.com> wrote in message
news:eaQpd6EfDHA.1212@TK2MSFTNGP12.phx.gbl...

> I put in the code as Mark suggested, and now get the following error:
>
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC Microsoft Access Driver] Could not find file
> '(unknown)'.
> /default.asp, line 21
>
>
> I wonder if it is a permissions problem with IIS and/or the file
> "treasuries.mdb"? To the best of my knowledge, nothing has changed
> either code-wise or permissions-wise. I did change the "domain
> administrator" password a week or two ago, but I honestly don't think
> that that is the problem, or is it?
>
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!

[Horhayson]

I still got the same error but on a different line (line 21 instead of
line 20).

The files "default.asp" and "treasuries.mdb" are contained within the
same physical directory on a W2k server running IIS (if that helps)





*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Mark Schupp]

What does response.write server.mappath("treasuries.mdb") display?


--
Mark Schupp
--
Head of Development
Integrity eLearning
Online Learning Solutions Provider
[email]mschupp@ielearning.com[/email]
[url]http://www.ielearning.com[/url]
714.637.9480 x17


"Horhayson" <dgeorges.1@netzero.com> wrote in message
news:OqG9cqGfDHA.2184@TK2MSFTNGP10.phx.gbl...

> I still got the same error but on a different line (line 21 instead of
> line 20).
>
> The files "default.asp" and "treasuries.mdb" are contained within the
> same physical directory on a W2k server running IIS (if that helps)
>
>
>
>
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!

[Horhayson]

The path that it printed out was the valid path (i.e.
c:\somefolder\treasuries.mdb). The code seems to check out just fine.
The web page started working essentially without intervention from me (I
did everything I could think of). Just chalk this one up to a
"feature".

Thanks for the assistance, though.



*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!