Linking Exchange Server to SQL server

I have SBS 2003 - Exchange and SQL Servers are on the same box.
I have managed to create linked database and can see Exchange Public Folders
in Linked database in Enterprise Manager.
Now the problem is how do a access / read the tables ?There are a couple of examples in MSDN:
http://msdn2.microsoft.com/en-us/library/ms191461.aspx
For a more comprehensive list of objects, please see this :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wss/wss/wss_references_oledb.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||Hello Paul,
When I try to run the sample query in Query Analyzer following error comes
up -
Server: Msg 7321, Level 16, State 2, Procedure Contacts, Line 3
An error occurred while preparing a query for execution against OLE DB
provider 'exoledb.DataSource.1'.
OLE DB error trace [OLE/DB Provider 'exoledb.DataSource.1'
ICommandPrepare::Prepare returned 0x80040e14].
--
Please advice if possible
Regards
Sudarshan Deshmukh
"Paul Ibison" wrote:
> There are a couple of examples in MSDN:
> http://msdn2.microsoft.com/en-us/library/ms191461.aspx
> For a more comprehensive list of objects, please see this :
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wss/wss/wss_references_oledb.asp
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>|||Hello Paul,
If i run the following -
SELECT Convert(nvarchar(30), "urn:schemas:contacts:sn") LastName
FROM OpenQuery(Exchange, 'SELECT "urn:schemas:contacts:sn"
FROM SCOPE(''shallow traversal of ".\Contacts"'')')
It comes up with last names...
I am trying to put emails in public folder and get them into SQL server
database.
Is their any simpler way of doing this or totally other way... ?
Please advice ?
Thanks for the showing the correct path in advance :-)
Sudarshan
"Paul Ibison" wrote:
> There are a couple of examples in MSDN:
> http://msdn2.microsoft.com/en-us/library/ms191461.aspx
> For a more comprehensive list of objects, please see this :
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wss/wss/wss_references_oledb.asp
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>|||If you want to avoid using the (fairly obscure :)) syntax, take a look at
Microsoft Access - there's a 'Link Exchange / Outlok' wizard which looks
like it might be the easiest way. I can certainly connect to my own mailbox
but unfortunately not the public folders - no doubt this is an Exchange
permission issue. Alternatively it must be possible on the Exchange console
to output the data in csv format. I don't know Exchange well enough for
this. Probably best at this point to try posting in the Exchange newsgroup
who'll know this type of level of detail. Probably also checking on the
legality of obtaining other people's email :)
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .sql