0

I use Windows Server 2008 R2 and ASP.NET 4.6.1.

How can I check if Microsoft OLE DB Provider for Index Server (Provider=MSIDXS) is installed ?

Maybe get a list the OLEDB providers available in the system.

Kiquenet
  • 14,494
  • 35
  • 148
  • 243

1 Answers1

0

I try this code.

I don't know now if applies to all 32bit and 64bit providers.

Guid for CLSID OLEDB is C8B522D0-5CF3-11ce-ADE5-00AA0044773D

internal static Guid IID_IUnknown = new Guid("00000000-0000-0000-c000-000000000046");
internal static Guid CLSID_DataLinks = new Guid("2206CDB2-19C1-11d1-89E0-00C04FD7A829");
internal static Guid CLSID_OLEDB_ENUMERATOR = new Guid("C8B522D0-5CF3-11ce-ADE5-00AA0044773D");
internal static Guid CLSID_MSDASQL_ENUMERATOR = new Guid("C8B522CD-5CF3-11ce-ADE5-00AA0044773D");


private string GetOLEDBProvidersRegistered()
{
    var res = "";
    try
    {
        Guid guidOleDbEnum = new Guid("{C8B522D0-5CF3-11ce-ADE5-00AA0044773D}");

        Type type = Type.GetTypeFromCLSID(guidOleDbEnum);

        using (OleDbDataReader rdr = OleDbEnumerator.GetEnumerator(type))
        {
            while (rdr.Read())
                //Console.WriteLine("{0} - {1}", rdr["SOURCES_NAME"], rdr["SOURCES_DESCRIPTION"]);
                res += string.Format("{0} - {1}\r\n", rdr["SOURCES_NAME"], rdr["SOURCES_DESCRIPTION"]);

        }
    }
    catch (Exception ex)
    {
        res = ex.Message;
    }
    return res;
}
Kiquenet
  • 14,494
  • 35
  • 148
  • 243