Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    66

    Question Unanswered: How to retrieve system oledb Provider list

    In my app I have to list of "oledb provider" to let the user choose the connection method. As follow:
    1.Jet 4.0 OLE DB Provider
    2.OLE DB Provider for DTS Packages
    3.OLEDB Provider for Indexing Service
    4.OLEDB Provider for ODBC Drivers
    5.OLEDB Provider for OLAP Services
    6.OLEDB Provider for Olap Services 8.0
    7.OLEDB Provider for Oracle
    8.OLEDB Provider for SQL Server
    9.OLEDB Simple Provide
    Which doesn't not support must be disabled.
    Use which funciton can retrieve the Provider list of system or something like that.
    Thanks.
    --

  2. #2
    Join Date
    May 2003
    Location
    Parsippany NJ
    Posts
    36
    Master..xp_enum_oledb_providers

    If you want to keep the resule,Create a table with the column returned by the above query.And

    insert into OLEDB_Providers exec Master..xp_enum_oledb_providers

  3. #3
    Join Date
    Sep 2003
    Posts
    66
    en ... I still do not know how ..
    where is the master..xp_enum_oledb_providers
    is that a function?
    can show me a sample ?
    many thanks.
    Originally posted by ClaireHsu
    Master..xp_enum_oledb_providers

    If you want to keep the resule,Create a table with the column returned by the above query.And

    insert into OLEDB_Providers exec Master..xp_enum_oledb_providers

  4. #4
    Join Date
    Sep 2003
    Posts
    66
    Can show me a sample code to list the oledb providers of current system.
    Thanks.

  5. #5
    Join Date
    Sep 2003
    Posts
    66
    I really want to know does the system support:

    1.SQLOLEDB
    2.DTSPackageDSO
    3.SQLReplication.OLEDB
    4.MSDataShape
    5.VSEE Versioning Enlistment Manager Proxy Data Source
    6.ADsDSOObject
    7.MSOLAP
    8.MSDAIPP.DSO
    9.MSDASQL
    10.MSDASQL Enumerator
    11.Microsoft.Jet.OLEDB.4.0
    12.Microsoft.Jet.OLEDB.3.51
    13.SQLOLEDB Enumerator
    14.MSDAOSP
    15.MSDAORA
    ....
    How to perform this check/text of the user's system in my app.
    In my app the unsupport oledb provider must be visable.
    --
    Thanks.

Posting Permissions

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