ms odbc text driver error

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?

Thanks,
jc

Re: ms odbc text driver error

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

Re: ms odbc text driver error

Detail -

FP: Error: Unable to Open Jet Temporary Key Connecting to DB
http://support.microsoft.com/?id=315456
--
Regards,
Bernard Cheah
http://www.iis.net/
http://www.iis-resources.com/
http://msmvps.com/blogs/bernard/


"Daniel Crichton" 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
>