Can't include Oledb32.dll into Deployment project

[KjartanM-S]

Hi

I've developed a program in VB.NET which i'm trying to
deploy to a different computer. I've used the Setup &
Deployment wizard project to generate the Deployment
files. It initially includes Oledb32.dll into the
application folder. When i try to build solution it
throws an error:
'oledb32.dll' should be excluded because its source
file 'C:\Program Files\Common Files\System\Ole
DB\oledb32.dll' is under Windows System File Protection.

When distributing my program (with Oledb32.dll excluded)
it crashes quite horribly (The comp has XP Pro and .NET
1.1 framework installed)
.. I suspect that the Oledb32.dll (or lack of) is the
cause of this as the first thing my application does is
to access a SQL database.

Any ideas of how to include it into the deployment
program?

Thanks

KjartanM-S

[David Browne]

"KjartanM-S" <kj**********************@chello.no> wrote in message
news:06****************************@phx.gbl...

Hi

I've developed a program in VB.NET which i'm trying to
deploy to a different computer. I've used the Setup &
Deployment wizard project to generate the Deployment
files. It initially includes Oledb32.dll into the
application folder. When i try to build solution it
throws an error:
'oledb32.dll' should be excluded because its source
file 'C:\Program Files\Common Files\System\Ole
DB\oledb32.dll' is under Windows System File Protection.

OleDB32.dll is part of the MDAC package, and as of Win2k is considered part
of the OS. To update this component you must install the entire MDAC
package. And although XP Pro should have everything you need already, you
can always install an MDAC update.

Why don't you just use the managed provider for SQLServer? It has no
unmanaged dependencies.

David