OdbcConnection failed when using Windows authentication and impersonation.

[Marlon]

I got the error message below when I try to open a connection with code:

Dim connection As New OdbcConnection("Driver={Microsoft Text Driver (*.txt;
*.csv)};DBQ=C:\Inetpub\aesd")
connection.Open()

I am developing an asp.net application on Windows XP SP2 using Windows
authentication and impersonation. Can anyone help?
Personal I think it is because of a permissions/security problem

ERROR [HY000] [Microsoft][ODBC Text Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0xc8c Thread 0xb44
DBC 0x86ca004 Text'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed ERROR [HY000] [Microsoft][ODBC Text Driver]General
error Unable to open registry key 'Temporary (volatile) Jet DSN for process
0xc8c Thread 0xb44 DBC 0x86ca004 Text'. ERROR [HY000] [Microsoft][ODBC Text
Driver] Disk or network error. ERROR [HY000] [Microsoft][ODBC Text
Driver]General error Unable to open registry key 'Temporary (volatile) Jet
DSN for process 0xc8c Thread 0xb44 DBC 0x86ca004 Text'. ERROR [HY000]
[Microsoft][ODBC Text Driver]General error Unable to open registry key
'Temporary (volatile) Jet DSN for process 0xc8c Thread 0xb44 DBC 0x86ca004
Text'. ERROR [HY000] [Microsoft][ODBC Text Driver] Disk or network error.

 

[Miha Markic [MVP C#]]

Hi,

asp.net application is using asp.net local windows account, so make sure the
account has necessary privileges (it has minimum privileges by default).
Or, make asp.net application run under other account.
Or, don't use integrated security.