When attempting to connect to an Access 2000 DB using ADO.Net from within
ASP.Net running under an impersonated local user account receiving the
following error.

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

Oracle ODBC connection works fine under the same user so assuming this is
something to do with either Access specific registry permissions, or NTFS
file permissions.

Found own solution to this which may be of use to others.

Checked the system temp directory and this had the required permissions.
Then checked for any other profiles that may also contain a temp directory
that may be effecting this.

Discovered the C:\Documents and Settings\[MachineName]\ASPNET\Temp folder
for the ASPNET user profile. Added full permissions to the directory for the
impersonation user and this is now working fine. I have reversed the
registry changes I made to the SOFTWARE\ODBC key and still working Ok.

[quoted text, click to view]

¤ Found own solution to this which may be of use to others.
¤
¤ Checked the system temp directory and this had the required permissions.
¤ Then checked for any other profiles that may also contain a temp directory
¤ that may be effecting this.
¤
¤ Discovered the C:\Documents and Settings\[MachineName]\ASPNET\Temp folder
¤ for the ASPNET user profile. Added full permissions to the directory for the
¤ impersonation user and this is now working fine. I have reversed the
¤ registry changes I made to the SOFTWARE\ODBC key and still working Ok.

Just an FYI, it is recommend that you use of the Jet OLEDB provider with an Access database for both
feature support and stability.


Paul
~~~~