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
abcd wrote:
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'.
Steve C. Orr [MVP, MCSD] wrote: 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" <ab**@abcd.com> wrote in message
news:ea**************@TK2MSFTNGP15.phx.gbl... 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.