iis 5 and access db problem

[jim carney]

i am trying to publish a very simple access data page on
iis 5. i am getitng an error message though stating that
the path to the database is not valid.

i have been thru all the configuration steps i could find
on the ms kb, i edited the msdfmap ini file, changed the
remote data provider property of the dap to true, and
installed mdac on the virtual server. what am i missing?
thank you

[Jeff Cochran]

On Fri, 9 Jan 2004 07:14:41 -0800, "jim carney" <JCarney@agmins.com>
wrote:

>i am trying to publish a very simple access data page on
>iis 5. i am getitng an error message though stating that
>the path to the database is not valid.

Sow the complete error, and show us the connection string you're using
to attach to the database.

>i have been thru all the configuration steps i could find
>on the ms kb, i edited the msdfmap ini file, changed the
>remote data provider property of the dap to true, and
>installed mdac on the virtual server. what am i missing?

Give us some details to work off of and we may be able to help you
figure that out.

Jeff

[James Carney]

thank you for your reply.

the data access page was created in access 2000.
there is no particular connection string. i've been trying to follow ms
kb articles on deploying Access 2000 DAPs, and they did not state a
connection string was neccessary.

i installed a virtual director for mdac
i modified the msfmap ini file (spelling might be wrong now but i found
the file they wanted me to modify in my c:/winnt file)

the error i get states that the path is not valid, and it lists the
correct path, and to ensure that the db file is on the computer i am
trying to access. then a second error pops up and states "data provider
failed while executing a provider command" the page then displays, but
with #error in all the fields.

the only kb article i have seen that closely describes this is one for
netware computers, where it wants you to change the local account that
handles the login for anoyomous users. IUSer_computername
since i am using authentication to log onto the website i was not
allowing anoymous connections. Q271228

hopefully this helps a bit.

thank you
jim

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

[Jeff Cochran]

On Fri, 09 Jan 2004 08:19:39 -0800, James Carney <jcarney@agmins.com>
wrote:

>
>
>thank you for your reply.
>
>the data access page was created in access 2000.
>there is no particular connection string. i've been trying to follow ms
>kb articles on deploying Access 2000 DAPs, and they did not state a
>connection string was neccessary.
>
>i installed a virtual director for mdac
>i modified the msfmap ini file (spelling might be wrong now but i found
>the file they wanted me to modify in my c:/winnt file)
>
>the error i get states that the path is not valid, and it lists the
>correct path, and to ensure that the db file is on the computer i am
>trying to access. then a second error pops up and states "data provider
>failed while executing a provider command" the page then displays, but
>with #error in all the fields.

Show the full error. Also any event log entries that may be relevant.

>the only kb article i have seen that closely describes this is one for
>netware computers, where it wants you to change the local account that
>handles the login for anoyomous users. IUSer_computername
>since i am using authentication to log onto the website i was not
>allowing anoymous connections. Q271228

Does the user account authenticating have full access to the folder
where the Access MDB file is?

Jeff

[James Carney]

Jeff,

there are no entries in the event logs on either the server side, or the
workstation side.

i am logging in with my account which is an Admin account. the website
folder, and the access mdb file all have "everyone" as the group
permissions with full access. (i started off as wide as possible and
figured once i get it working i can roll it back a bit)

Internet Explorer Error
'F:\Fordhamweb\data\minisystem.mdb' is not a valid path. make sure the
path name is spelled correctly and that you are connected to the server
on which the file resides.

followed by

data provider failed while executing a provider command.



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

[Aaron Bertrand - MVP]

Is F:\ a mapped drive to another machine?

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]




"James Carney" <jcarney@agmins.com> wrote in message
news:uQjiapt1DHA.2396@TK2MSFTNGP09.phx.gbl...

> Jeff,
>
> there are no entries in the event logs on either the server side, or the
> workstation side.
>
> i am logging in with my account which is an Admin account. the website
> folder, and the access mdb file all have "everyone" as the group
> permissions with full access. (i started off as wide as possible and
> figured once i get it working i can roll it back a bit)
>
> Internet Explorer Error
> 'F:\Fordhamweb\data\minisystem.mdb' is not a valid path. make sure the
> path name is spelled correctly and that you are connected to the server
> on which the file resides.
>
> followed by
>
> data provider failed while executing a provider command.
>
>
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!

[James Carney]

f: is the file server drive as the client computers in the network see
it.

the file servers's(and in this case also its my web server) has one
drive split into C and E.

the actually website / and the mdb file resides on the E drive of the
file/web server.

sorry i never even thought about that letter.

i am attempting to test my access, from IE on one of the local network
clients. i am testing it by using the ip address of the website in the
address bar.



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

[James Carney]

that was exactly it! thank you so much, i should have wondered about
that!

i remapped it as //agmfs/c/etc etc and it seems to be working now. one
last off site test to do and i am home free!

thank you very much everyone who posted on this!
jim

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