IIS Server Security - ms odbc text driver error

This is Interesting: Free IT Magazines  
Home > Archive > IIS Server Security > February 2007 > ms odbc text driver error





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author ms odbc text driver error
JC

2007-02-01, 1:23 am

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


Daniel Crichton

2007-02-02, 7:25 am

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


Bernard Cheah [MVP]

2007-02-02, 7:25 am

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" <msnews@worldofspack.com> wrote in message
news:eTVnp3qRHHA.3948@TK2MSFTNGP05.phx.gbl...
> JC wrote on Wed, 31 Jan 2007 21:12:07 -0600:
>
>
> 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
>



Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com