Re: OdbcConnection failed when using Windows authentication and impersonation.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Miha Markic [MVP C#] (miha)
Date: 10/13/04 

Date: Wed, 13 Oct 2004 14:58:17 +0200

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. 

-- 
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com
"Marlon" <mreid@exhibitworks.com> wrote in message 
news:uM9vaBSsEHA.904@TK2MSFTNGP11.phx.gbl...
>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.
>
>
>
>
>

Relevant Pages