security issue

[abcd]

When I use <identity impersonate="true"> I get following error. My goal is
to access Microsoft Access file from another machine on the domain from my
asp.net applicaiton....what could be the best way

ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Disk or network
error. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed ERROR [HY000] [Microsoft][ODBC Microsoft Access
Driver] Disk or network error.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.Odbc.OdbcException: ERROR [HY000]
[Microsoft][ODBC Microsoft Access Driver] Disk or network error. ERROR
[IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Disk or network
error.

 

[Steve C. Orr [MVP, MCSD]]

Assuming you have permission to access the file, have it impersonate you,
using your account name and password.
This is a good first debugging step just to get things working. Eventually
it should use a differen account.

 

[abcd]

I used my domain account and password too but the file an not be
accessed....

If I removed impersonation from web.config and try to access my MS access
file as \\machine104\shared\DBS\db3.mdb I get following error

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0x1224 Thread 0x110c
DBC 0x43739c Jet'.

Assuming you have permission to access the file, have it impersonate
you, using your account name and password.
This is a good first debugging step just to get things working. Eventually
it should use a differen account.

When I use <identity impersonate="true"> I get following error. My
goal is to access Microsoft Access file from another machine on the
domain from my asp.net applicaiton....what could be the best way

ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Disk or
network error. ERROR [IM006] [Microsoft][ODBC Driver Manager]
Driver's SQLSetConnectAttr failed ERROR [HY000] [Microsoft][ODBC
Microsoft Access Driver] Disk or network error.
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details: System.Data.Odbc.OdbcException: ERROR [HY000]
[Microsoft][ODBC Microsoft Access Driver] Disk or network error.
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed ERROR [HY000] [Microsoft][ODBC Microsoft
Access Driver] Disk or network error.

 

[abcd]

I mean if I access the MS access file using connection string

strConnection = "driver={microsoft access driver
(*.mdb)};dbq=\\msxp302\shared\DBS\db3.mdb; uid=;pwd="

I get the error

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0x1224 Thread
0x110c DBC 0x43739c Jet'.

I pass the connection string to COM componnet and which retrives the data
for me. so my architecture is like this

asp.net page --> accessing a COM component which uses ADO --> returning me
an array ---> asp.net page working on array

I used my domain account and password too but the file an not be
accessed....

If I removed impersonation from web.config and try to access my MS
access file as \\machine104\shared\DBS\db3.mdb I get following error

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0x1224 Thread
0x110c DBC 0x43739c Jet'.

Assuming you have permission to access the file, have it impersonate
you, using your account name and password.
This is a good first debugging step just to get things working.
Eventually it should use a differen account.

When I use <identity impersonate="true"> I get following error. My
goal is to access Microsoft Access file from another machine on the
domain from my asp.net applicaiton....what could be the best way

ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Disk or
network error. ERROR [IM006] [Microsoft][ODBC Driver Manager]
Driver's SQLSetConnectAttr failed ERROR [HY000] [Microsoft][ODBC
Microsoft Access Driver] Disk or network error.
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details: System.Data.Odbc.OdbcException: ERROR [HY000]
[Microsoft][ODBC Microsoft Access Driver] Disk or network error.
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed ERROR [HY000] [Microsoft][ODBC Microsoft
Access Driver] Disk or network error.