BizWorld
12/7/2005 11:09:00 PM
My ASP.net application reads data from access 2000 db and write data in
SQL server.
Access Db application is on Network share folder. network share folder
permission is set to fullControl for Everyone. when i try to connect
with Access DB using OleDBConnection, it fails with the
message..................................................................
'H:\prodDB\prodData.mdb' is not a valid path. Make sure that the path
name is spelled correctly and that you are connected to the server on
which the file
resides.....................................................................
While H is a mapped drive to network share. I run the same code in
Windows application, it worked fine. but when i Put this in ASP.net, it
fails with above error. I changed ProcessModel tag in Machine.config to
run under "system" user. and added identity tag in web.config file but
it work only on Dev machine. when i access dev URL from other machine
then this code fails.
I am stuck in this since last two days, it is very URGENT.