Access is denied: 'Interop.ADODB' error - almost ready to jump off the balcony!

[Dave E]

Hi folks,

I have a VB.Net application, currently being developed on my XP Pro 2002 SP2
box. It is pretty straightforward and accesses my local SQL2000 instance.

Randomly I get the above error (see subject line) and I am thus far unable
to google my way out of it. I have tried "iisreset" but this has no effect.
The error stops on line 258 below of machine.config:
Line 256: <add assembly="Syste m.EnterpriseSer vices,
Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b03f5f7f11d50a3 a"/>
Line 257: <add assembly="Syste m.Web.Mobile,
Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b03f5f7f11d50a3 a"/>
Line 258: <add assembly="*"/>
Line 259: </assemblies>
Line 260:

c:\windows\micr osoft.net\frame work\v1.1.4322\ Config\machine. config
If anyone can help me with this issue I will greatly appreciate it. My
balcony is on the 7th floor and I suspect this is not worth the jump but it
is driving me crazy!!

Cheers,
Dave E (Sydney)

[Mike Labosh]

> Randomly I get the above error (see subject line) and I am thus far unable

to google my way out of it. I have tried "iisreset" but this has no
effect. The error stops on line 258 below of machine.config:
Line 256: <add assembly="Syste m.EnterpriseSer vices,
Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b03f5f7f11d50a3 a"/>
Line 257: <add assembly="Syste m.Web.Mobile,
Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b03f5f7f11d50a3 a"/>
Line 258: <add assembly="*"/>
Line 259: </assemblies>
Line 260:

IIS gets bit-rot sometimes. Especially if you're using IIS on your
development workstation and it's maxed out.

1. Exit VS.NET
2. NET STOP IISADMIN
3. NET START W3SVC
4. Launch VS.NET and open your project
5. CONTROL+SHIFT+B

--
Peace & happy computing,

Mike Labosh, MCSD

"When you kill a man, you're a murderer.
Kill many, and you're a conqueror.
Kill them all and you're a god." -- Dave Mustane