Access files on Network Drive from ASP.NET Client

[Mike McIntyre [MVP]]

I am working on an issue where and ASP.NET web application on one computer
(A) needs to access files on a network mapped drive (B).

This application uses as DSN on (A) that maps a proprietory ODBC driver to
data on a (B). The DSN directory path points to mapped network drive
mounted on (A).

When the ASP.NET application reaches the point where the ODBC drive is
called to fill a DataSet it throws the following exeption:

ERROR [S0000] [ComputerEase][ODBC Driver][ISAM]Unable to load CEODBC33.DLL
ERROR [S0000] [ComputerEase][ODBC Driver][ISAM]Unable to load CEODBC33.DLL

(no indication of access permission issue)

If I put the data into a local folder on (A) and give aspnet_wp full
permissions on the folder, the application works.

(seems to indicate the problem when trying to use the network drive was a
permission issue?)

Is impersonation the way to allow the ASP.NET web application to access the
network drive?

Any other suggestions?

Thank you,
--
Mike

Mike McIntyre
Visual Basic MVP
www.getdotnetcode.com

[Sylvain Lafontaine]

Network mapped drives (Z:\ and the like) are defined for the current user
account only and as such, should be unknown (an unaccessible) to the the
aspnet_wp account.

You should try with an UNC (\\MachineName\....) pathway instead.

S. L.

"Mike McIntyre [MVP]" <mi****@getdotnetcode.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

I am working on an issue where and ASP.NET web application on one computer
(A) needs to access files on a network mapped drive (B).

This application uses as DSN on (A) that maps a proprietory ODBC driver to
data on a (B). The DSN directory path points to mapped network drive
mounted on (A).

When the ASP.NET application reaches the point where the ODBC drive is
called to fill a DataSet it throws the following exeption:

ERROR [S0000] [ComputerEase][ODBC Driver][ISAM]Unable to load CEODBC33.DLL
ERROR [S0000] [ComputerEase][ODBC Driver][ISAM]Unable to load CEODBC33.DLL

(no indication of access permission issue)

If I put the data into a local folder on (A) and give aspnet_wp full
permissions on the folder, the application works.

(seems to indicate the problem when trying to use the network drive was a
permission issue?)

Is impersonation the way to allow the ASP.NET web application to access
the network drive?

Any other suggestions?

Thank you,
--
Mike

Mike McIntyre
Visual Basic MVP
www.getdotnetcode.com

[Mike McIntyre [MVP]]

Use the \\MachineName\ pathway in the DSN?

"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:ep***************@tk2msftngp13.phx.gbl...

Network mapped drives (Z:\ and the like) are defined for the current user
account only and as such, should be unknown (an unaccessible) to the the
aspnet_wp account.

You should try with an UNC (\\MachineName\....) pathway instead.

S. L.

"Mike McIntyre [MVP]" <mi****@getdotnetcode.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

I am working on an issue where and ASP.NET web application on one computer
(A) needs to access files on a network mapped drive (B).

This application uses as DSN on (A) that maps a proprietory ODBC driver
to data on a (B). The DSN directory path points to mapped network drive
mounted on (A).

When the ASP.NET application reaches the point where the ODBC drive is
called to fill a DataSet it throws the following exeption:

ERROR [S0000] [ComputerEase][ODBC Driver][ISAM]Unable to load
CEODBC33.DLL ERROR [S0000] [ComputerEase][ODBC Driver][ISAM]Unable to
load CEODBC33.DLL

(no indication of access permission issue)

If I put the data into a local folder on (A) and give aspnet_wp full
permissions on the folder, the application works.

(seems to indicate the problem when trying to use the network drive was a
permission issue?)

Is impersonation the way to allow the ASP.NET web application to access
the network drive?

Any other suggestions?

Thank you,
--
Mike

Mike McIntyre
Visual Basic MVP
www.getdotnetcode.com

[bruce barker]

unless the asp.net account is a domain account it can not access UNC paths

-- bruce (sqlwork.com)
"Mike McIntyre [MVP]" <mi****@getdotnetcode.com> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...
| Use the \\MachineName\ pathway in the DSN?
|
| "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
| wrote in message news:ep***************@tk2msftngp13.phx.gbl...
| > Network mapped drives (Z:\ and the like) are defined for the current
user
| > account only and as such, should be unknown (an unaccessible) to the the
| > aspnet_wp account.
| >
| > You should try with an UNC (\\MachineName\....) pathway instead.
| >
| > S. L.
| >
| > "Mike McIntyre [MVP]" <mi****@getdotnetcode.com> wrote in message
| > news:%2****************@TK2MSFTNGP09.phx.gbl...
| >>I am working on an issue where and ASP.NET web application on one
computer
| >>(A) needs to access files on a network mapped drive (B).
| >>
| >> This application uses as DSN on (A) that maps a proprietory ODBC driver
| >> to data on a (B). The DSN directory path points to mapped network
drive
| >> mounted on (A).
| >>
| >> When the ASP.NET application reaches the point where the ODBC drive is
| >> called to fill a DataSet it throws the following exeption:
| >>
| >> ERROR [S0000] [ComputerEase][ODBC Driver][ISAM]Unable to load
| >> CEODBC33.DLL ERROR [S0000] [ComputerEase][ODBC Driver][ISAM]Unable to
| >> load CEODBC33.DLL
| >>
| >> (no indication of access permission issue)
| >>
| >> If I put the data into a local folder on (A) and give aspnet_wp full
| >> permissions on the folder, the application works.
| >>
| >> (seems to indicate the problem when trying to use the network drive was
a
| >> permission issue?)
| >>
| >> Is impersonation the way to allow the ASP.NET web application to access
| >> the network drive?
| >>
| >> Any other suggestions?
| >>
| >> Thank you,
| >>
| >>
| >> --
| >> Mike
| >>
| >> Mike McIntyre
| >> Visual Basic MVP
| >> www.getdotnetcode.com
| >>
| >
| >
|
|

[Sylvain Lafontaine]

Hum, good question, I don't remember if you have the right to use a UNC
directly into a DSN. Have-you tried it?

Another solution would be to use a DSN-less string connection or a File DSN.
The following article clearly state that UNC can be used in a File DSN:
http://support.microsoft.com/kb/q165866/ . However, I don't know if your
proprietary ODBC driver will support it.

Don't forget about the fact that you must use a Domain Account instead of a
System Account for accessing your UNC over the network (see the other post
from Bruce Baker).

S. L.

"Mike McIntyre [MVP]" <mi****@getdotnetcode.com> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...

Use the \\MachineName\ pathway in the DSN?

"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:ep***************@tk2msftngp13.phx.gbl...

Network mapped drives (Z:\ and the like) are defined for the current user
account only and as such, should be unknown (an unaccessible) to the the
aspnet_wp account.

You should try with an UNC (\\MachineName\....) pathway instead.

S. L.

"Mike McIntyre [MVP]" <mi****@getdotnetcode.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

I am working on an issue where and ASP.NET web application on one
computer (A) needs to access files on a network mapped drive (B).

This application uses as DSN on (A) that maps a proprietory ODBC driver
to data on a (B). The DSN directory path points to mapped network drive
mounted on (A).

When the ASP.NET application reaches the point where the ODBC drive is
called to fill a DataSet it throws the following exeption:

ERROR [S0000] [ComputerEase][ODBC Driver][ISAM]Unable to load
CEODBC33.DLL ERROR [S0000] [ComputerEase][ODBC Driver][ISAM]Unable to
load CEODBC33.DLL

(no indication of access permission issue)

If I put the data into a local folder on (A) and give aspnet_wp full
permissions on the folder, the application works.

(seems to indicate the problem when trying to use the network drive was
a permission issue?)

Is impersonation the way to allow the ASP.NET web application to access
the network drive?

Any other suggestions?

Thank you,
--
Mike

Mike McIntyre
Visual Basic MVP
www.getdotnetcode.com