Re: How do I registry the OLE provider for a Exchange 2003 database

I don't think you can, directly. Exchange databases are messaging
databases, and not vuilt on the SQL engine.

What are you tring to accomplish? There may be some data here
http://www.outlookcode.com/d/database.htm


"Dave" <DaveTichenor@xxxxxxxxxxx> wrote in message
news:%235tVaVRPFHA.3076@xxxxxxxxxxxxxxxxxxxxxxx
>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")')
>
>
>


.