Re: Can't Use Oledb functionality (missing System.Data.Oledb.dll)

From: Erland Sommarskog (esquel_at_sommarskog.se)
Date: 09/05/04


Date: Sun, 5 Sep 2004 17:21:05 +0000 (UTC)

Lynn Lahman (LynnLahman@discussions.microsoft.com) writes:
> I cannot use the Oledb functionality on my system because the
> System.Data.Oledb namespace is not included in my available "references"
> (the dll is not anywhere on my system). How do I acquire this dll?

It appears that you need to install the .Net framework. OLE DB as such
has nothing to do with .Net, but comes with the MDAC. The System.Data.Oledb
namespace is a component of the .Net Framework that uses OLE DB.

If you have more questions about the .Net Framework, try
microsoft.public.dotnet.framework.dotnet.
 
> I have tried downloading MDAC 2.8, however when doing so the install
> procedure tells me that the install is not compatible with my version of
> Windows (XP Pro) and that the functionality is already on my system
> (except it's not).
 
MDAC 2.8 comes with SQL 2003. Windows XP has MDAC 2.7.

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp


Relevant Pages

  • Re: System.Runtime.InteropServices.COMException: Error
    ... after i registered the dll on sever, ... > Is there any other setting I need to do on Win2K3 to make the old dll work> on .Net framework? ... > Exception Details: System.Runtime.InteropServices.COMException: COM object> with CLSID is either not valid or not> registered. ...
    (microsoft.public.dotnet.general)
  • Re: VCL.NET revisited...
    ... Ever noticed the size of the .NET Framework directory? ... Back to DLL Hell deployment? ... Delphi apps were/are mostly single exe only and any ... DevCo spinoff: Unmanaged Delphi W32. ...
    (borland.public.delphi.non-technical)
  • Re: .tmp is not a valid win32 resource file
    ... Please suggest some ways to resolve ... I replaced the dll as suggested in the mentioned post. ... dll present in the framework folder and the system 32 folder are ... I got the problem when i reinstalled the .Net framework 1.1. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Redirecting Assembly Binding
    ... the fusion.dll which is component of .NET framework ... the strongnamed DLL is an evidence to prove its unique ... So the bindingredirect element is used in this scenario to instruct the CLR ... Because .NET will probe multiple places for an assembly binding. ...
    (microsoft.public.dotnet.framework)
  • Re: No OLE DB providers listed when creating a Linked Server
    ... dll was OLEDB32.dll - the core services dll for OLEDB. ... An additional note; reinstalling mdac 2.8 ... > component checker from: ...
    (microsoft.public.sqlserver.security)