Solution for Unspecified Error on Windows 2000 using Jet

Hi There,

I just wanted to post this solution that we found to the common

"Unspecified Error" on Windows 2000 server.

when trying to access a database from ASP pages using the ODBC JEt
driver. For those of you that have tried all the other recommend fixes
such as checking the IUSER_ permissions on the Temp and Windows/Temp
folder, permissions on the database folder and file itself.

We tried all of the suggested fixed including permissions of TEMP
folders and it did not fix the problem.

We found the problem. This seems to have happened after the latest
batch of Microsoft Security patches or the Windows 2000 Roll up just
released.

If you have a FrontPage Sub web OR separate application folder in IIS
under your main Virtual Web, it CAN NOT have the Application protection
set to High (isolated) it must be set to Medium (pooled). Changing the
Main virtual web Application Protection will have no impact.

There may be another reason for this occurance but changing this solved
our problem.

Hope that helps someone.

Cheers

Re: Solution for Unspecified Error on Windows 2000 using Jet

Just curious but, have you tried not using ODBC and use OLEDB instead?

Otherwise try the resolutions mentioned here;

http://aspfaq.com/show.asp?id=2009
http://aspfaq.com/show.asp?id=2142

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

"johnner" wrote in message
news:1124218847.702089.36650@f14g2000cwb.googlegroups.com...
> Hi There,
>
> I just wanted to post this solution that we found to the common
>
> "Unspecified Error" on Windows 2000 server.
>
> when trying to access a database from ASP pages using the ODBC JEt
> driver. For those of you that have tried all the other recommend fixes
> such as checking the IUSER_ permissions on the Temp and Windows/Temp
> folder, permissions on the database folder and file itself.
>
> We tried all of the suggested fixed including permissions of TEMP
> folders and it did not fix the problem.
>
> We found the problem. This seems to have happened after the latest
> batch of Microsoft Security patches or the Windows 2000 Roll up just
> released.
>
> If you have a FrontPage Sub web OR separate application folder in IIS
> under your main Virtual Web, it CAN NOT have the Application protection
> set to High (isolated) it must be set to Medium (pooled). Changing the
> Main virtual web Application Protection will have no impact.
>
> There may be another reason for this occurance but changing this solved
> our problem.
>
> Hope that helps someone.
>
> Cheers
>

Re: Solution for Unspecified Error on Windows 2000 using Jet

Hi Steven,

Thanks for your reply. Sorry that was my bad (typo) i meant OLEDB, we
also tried using the Access driver as well but we also got errors with
that unti lwe made the change to the Process.

We went through all the things in that first article, IWAM, database
etc... I will look into the other article and report back when i get a
chance.

Thanks

john