ASP.Net ODBC Connection to local Access 2000 fails under impersonation

[stueyh]

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 ODBC 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. Tried accessing the database with OleDB but recieved an unspecified error message.

Anybody ever come across this problem before?

Already fixed a problem where the impersonation user didnt have access to the SOFTWARE/ODBC key and sub key in the registry.

 

[SteenBray]

Hi Stueyh,

The first thing that I would check is to make sure that impersonated account has read/write permissions to the directory that the Access DB is located. The Write permission is key because of the ldb file that Access creates.

HTH,

Steen Bray

------------------------------------------
Steen Bray
Kermode Computing Solutions