OdbcConnection failed when using Windows authentication and impersonation.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marlon - 13 Oct 2004 13:29 GMT

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.

Reply to this Message

Miha Markic [MVP C#] - 13 Oct 2004 13:58 GMT

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.

Signature

Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

>I got the error message below when I try to open a connection with code:
>
[quoted text clipped - 23 lines]
> 'Temporary (volatile) Jet DSN for process 0xc8c Thread 0xb44 DBC 0x86ca004
> Text'. ERROR [HY000] [Microsoft][ODBC Text Driver] Disk or network error.

Reply to this Message

OdbcConnection failed when using Windows authentication and impersonation.

Free Magazines