How do I registry the OLE provider for a Exchange 2003 database
- From: "Dave" <DaveTichenor@xxxxxxxxxxx>
- Date: Sat, 9 Apr 2005 08:03:55 -0700
I receive the following error when I try to query an Exchange database using
a SQL query.
Server: Msg 7403, Level 16, State 1, Line 1
Could not locate registry entry for OLE DB provider 'exoledb.DataSource.1'.
OLE DB error trace [Non-interface error: Provider not registered.].
How do I registry the OLE provider for a Exchange 2003database.
thanks
Dave
Below is the code:
Add a link server
EXEC sp_addlinkedserver '1exch',
'Exchange OLE DB provider',
'exoledb.DataSource.1',
'file:\\.\backofficestorage\localhost\public folders'
Query database -
Select Convert(nvarchar(200),"urn:schemas:contacts:sn") LastName
FROM OpenQuery([1exch],'SELECT "urn:schemas:contacts:sn"
FROM SCOPE(".\contacts")')
.
- Follow-Ups:
- Prev by Date: Re: Outlook "trying to connect" to Exchange for 10 minutes
- Next by Date: Re: SMTP Virtual Server 'Quit' problem
- Previous by thread: Mail freezes in the smtp queue
- Next by thread: Re: How do I registry the OLE provider for a Exchange 2003 database
- Index(es):
Relevant Pages
|
|
