Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2009
    Posts
    8

    Unanswered: OLE DB Provider Information Stored in Registry

    Hi,
    Does someone know where the information about an OLE DB provider is stored in the Windows Registry?

    The context of the question is OPENROWSET argument "provider_name".

    Excerpt from SQL Server 2005 Online Help:
    OPENROWSET
    ( { 'provider_name'

    Arguments
    ' provider_name '
    Is a character string that represents the friendly name (or PROGID) of the OLE DB provider as specified in the registry.

    Thanks

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Provider info is stored in HKEY_CLASSES_ROOT\CLSID, but you can find it yourself if you issue master.dbo.xp_enum_oledb_providers which will return not only provider names, but also provider parsed keys and description.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Feb 2009
    Posts
    8
    Thank you for the information

    Can you share some insight on how valuable the "Parse Name" information is?

    Thanks

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    It's as valuable as Provider Name, you can search the registry by it...not sure what you mean by "how valuable...
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •