Accessing public folders with ExOLEDB via SQL-Server

• Previous message: Igor Shekalev: "Re: LIMIT"
• Messages sorted by: [ date ] [ thread ]

Date: Wed, 1 Dec 2004 20:55:42 +0100

Hi to all.

On a Win2000 Server running Exchange2K and SQL2K I've created a SQL View
with to following mechanism:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_0t5x.asp

EXEC sp_addlinkedserver 'exchange',
'Exchange OLE DB provider',
'exoledb.DataSource.1',
'file:\\.\backofficestorage\localhost\public folders'
andCREATE 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 (''.\contacts'')'
On the Server-machine everything is well and I've no problems to view the
data.But if I try to get the data by MS-Access from a client machine using
an ODBC connection to the SQL Server like:Adding the table as "external
data -> ODBC -> SQL Server" to MS Access. I can see the table, but if I try
to get data out of the table I get a message:"Could not create an instance
of OLE DB provider 'Exoledb.DataSource.1'"Does anybody know what kind of
problem I'm fighting here?Thanks for any hints Italo Anzioso

• Previous message: Igor Shekalev: "Re: LIMIT"
• Messages sorted by: [ date ] [ thread ]