INF: ????? xp_enum_oledb_providers ?????? OLE DB

?????? ????????? ?????? ?????????
???? ???????: 216575 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

?? xp_enum_oledb_providers ???? ????? ????? ???? ???? ?????? ???? ????? OLE DB ????? SQL Server.

???? ?????? ???? ?????? ?? ??? xp_enum_oledb_providers:
EXEC xp_enum_oledb_providers

??????? ????

????? xp_enum_oledb_providers ????? ????? ??? ???:
  • ??? ??????: ?????????? ???? ????? CLSID.
  • Parsename: CLSID (GUID).
  • ???: ??? ????? ??????.
???????? ??? ???????, ????? ????? ?????? ??? ?? ????? ?????? ?? ????? ???? ????? ??? ???? ??????? ???.

-- sp_valid_oledb_provider
-- A test to see if you pass in a legal provider name.
use master
go
if exists (select * from sysobjects where type = 'P' and name = 'sp_valid_oledb_provider')<BR/>
drop proc sp_valid_oledb_provider<BR/>
go
create proc sp_valid_oledb_provider @p nvarchar(255) as
set nocount on
create table #t([Provider Name] nvarchar(255) not null,[Parse Name] nvarchar(255) not null,[Provider Description] nvarchar(255) not null)
insert into #t exec xp_enum_oledb_providers
if exists (select * from #t where [Provider Name] = @p)
begin
   -- print 'OK'
   return 1
end
else
begin
   raiserror('Invalid OLE-DB provider "%s"',-1, -1, @p)
   return 0<BR/>
end
go
exec sp_valid_oledb_provider N'SQLOLEDB'
exec sp_valid_oledb_provider N'MSDASQL'
exec sp_valid_oledb_provider N'Microsoft.Jet.OLEDB.4.0'
exec sp_valid_oledb_provider N'Illegal Provider'


???? ??????? ??? ??????? ????? ??? ??? ?? ?? ????? ???? OLE DB ????? ??? ????? ??????? SQL Server 7.0 ????? ?? sp_addlinkedserver.

?????

?????? ??? ?????? ?? ???????? ??? ????? ????? ????? ??????? ????????? ??????? ???????? ?????? OLE DB ???? ??? "sp_addlinkedserver" ? "?????OpenQuery" ???????? "OpenRowset ??" ?? SQL Server 7.0 ????????.

?????? ??? ???? ?? ?????????? ???? "?????? ?????" ?? ?????? ??????:
http://support.microsoft.com/servicedesks/webcasts/wc102699/WC102699.asp

???????

???? ???????: 216575 - ????? ??? ??????: 20/?????/1424 - ??????: 3.3
????? ???
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
????? ??????: 
kbmt kbinfo KB216575 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????216575

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com