> Importing csv file using vs.net 2.0.
>
> I keep getting errors when I try and access a file using the odbc text
> driver. If I set the virtual directory to run under an admin account i can
> access the file. If I set the vd to run under the iuser account I get the
> following error.
>
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)[Microsoft][ODBC
> Microsoft Access Driver]General error Unable to open registry key
> 'Temporary (volatile) Jet DSN for process 0x614 Thread 0x6c0 DBC 0x21dd07c
> Jet'.
>
> I set the permissions to allow the iuser to access the odbc hive as stated
> in the kb. This doesn't help with the problem. I also tried to set the
> admin permissions on the directory holding the file to no avail. What do I
> need to do to access this file. Ideas?

"Daniel Crichton" <msnews@worldofspack.com> wrote in message
news:eTVnp3qRHHA.3948@TK2MSFTNGP05.phx.gbl...
> JC wrote on Wed, 31 Jan 2007 21:12:07 -0600:
>
>> Importing csv file using vs.net 2.0.
>>
>> I keep getting errors when I try and access a file using the odbc text
>> driver. If I set the virtual directory to run under an admin account i
>> can
>> access the file. If I set the vd to run under the iuser account I get the
>> following error.
>>
>> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)[Microsoft][ODBC
>> Microsoft Access Driver]General error Unable to open registry key
>> 'Temporary (volatile) Jet DSN for process 0x614 Thread 0x6c0 DBC
>> 0x21dd07c
>> Jet'.
>>
>> I set the permissions to allow the iuser to access the odbc hive as
>> stated
>> in the kb. This doesn't help with the problem. I also tried to set the
>> admin permissions on the directory holding the file to no avail. What do
>> I
>> need to do to access this file. Ideas?
>
> Make sure the IUSR account (or whichever account IIS is running under) has
> read/write access to the TEMP folder (normally c:\windows\temp).
>
> Dan
>