Exchange OLE DB provider

[todd.sh...@diversetechs.com]

I'm trying to setup an linked server to an Exchange server
both the SQL 2000 and Exchange 2000 server are on the same
server.

I believe I'm getting hang on the Data Source entry.
Looking at documentation on msdn it shows to create a
linked server with the following commands.

EXEC sp_addlinkedserver 'exchange',
'Exchange OLE DB provider',
'exoledb.DataSource.1',
'file:\\.\backofficestorage\localhost\public folders'

I can run this without errors. However when I click on
the Tables option under the linked server in the Console I
get an error 7304: Could not create a new session on OLE
DB Provider "exoledb.DataSource.1"

I have not be able to find a share name
backofficestorage. I have tried a couple of different
combinations for Data Source field. Include removing the
backofficestorage. Changeing localhost to myserver or
myserver.mydomain.com

Any held would be greatly appreciated. Thanks in advance
for your time.

Todd

[Dave Phillips]

There are some unexplained factors here. The 'localhost' needs to be
replaced by your email domain eg 'microsoft.com' to create a connection. I
have seen this work . The backofficestorage seems to be a virtual sharepint
but does work. I have not yet been able to update or insert into this
connection.
<todd.sh...@diversetechs.com> wrote in message
news:105601c1f5fc$8a117c50$19ef2ecf@tkmsftngxa01...

[Todd Shelbourn]

Thanks Dave that worked. I also used the following line
for the Data Source http://tempserver/public. Now the
problem is accessing the stores. I have followed the
following examples from MS but have not had much head
way. I modified this a little to be simple.

SELECT "urn:schemas:httpmail:to"
FROM "file:\\.\backofficestorage\domain\mbx\user\inbox"

Using the above example I would assume that you don't even
need a linked server. I get the following error.

Server: Msg 208, Level 16, State 1, Line 1
Invalid object
name 'file:\\.\backofficestorage\domain\mbx\user\inbox'.

I have also tried the following I changed the linked
server to the public folder. Making sure that I have a
contact folder and one contact in it.

CREATE VIEW Contacts
AS
SELECT convert(nvarchar(30),"urn:schemas:contacts:sn")
LastName,
Convert(nvarchar(30),"urn:schemas:contacts:givenname")
FirstName,
Convert(nvarchar(30), "urn:schemas:contacts:o")
Company,
Convert(nvarchar(50), "urn:schemas:contacts:email1")
Email,
"urn:schemas:contacts:bday" BirthDay
FROM OpenQuery(Exchange,
'SELECT "urn:schemas:contact:sn",
"urn:schema:contacts:givenname",
"urn:schemas:contacts:o",
"urn:schemas:contacts:email1"
"urn:schemas:contacts:bday"
FROM SCOPE(''.\contacts'')'

I get the following error

Server: Msg 170, Level 15, State 1, Procedure Contacts,
Line 10
Line 10: Incorrect syntax
near 'SELECT "urn:schemas:contact:sn",
"urn:schema:contacts:givenname",
"urn:schemas:contacts:o",
"u'.

with the following example I get this error.

Server: Msg 170, Level 15, State 1, Procedure Contacts,
Line 10
Line 10: Incorrect syntax
near 'SELECT "urn:schemas:contact:sn",
"urn:schema:contacts:givenname",
"urn:schemas:contacts:o",
"u'.

Thanks
Todd

>.
>