Exchange OLE DB Provider

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Exchange OLE DB Provider

Exchange OLE DB Provider

Rate Topic

Display Mode

Topic Options

Author

Message

jamesnt

Posted Saturday, November 8, 2008 11:44 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 6:53 PM
Points: 19, Visits: 89

Hello Everyone,

We need to access an Exchange Server public folder store to get a list of public folders, and their contents, to put up on a report.

Our setup:

Small Business Server 2003 R2 Premium Edition - all service packs and updates installed.

NOTE: We did NOT install SQL 2005 Workgroup - we purchased and installed SQL 2005 Standard to get the BI tools.

Unfortunatley, I can't seem to get the cooperation of the Exchange OLE DB provider.

The settings I'm using for the connection manager are as follows:

Server or file name: http://myserver/exchange

Use a specific user name and password: username = Administrator Password = ********

Allow saving password = TRUE

When I test the connection, I get the following error:

Test Connection failed because of an error in initializing provider. No error message available, result code: DB_E_NOTFOUND(0x80040E19).

Thank you all,
JamesNT

Post #599468

Elisabeth Rédei

Posted Saturday, November 8, 2008 12:24 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 30, 2014 8:52 AM
Points: 177, Visits: 758

Hi James,

Can you try to set it up in SQL Server Management Studio by following the steps (there are not many) in "OLE DB Provider for Exchange" http://msdn.microsoft.com/en-us/library/ms191461(SQL.90).aspx?

/Elisabeth

elisabeth@sqlserverland.com
MCITP | MCT
http://sqlblog.com/blogs/elisabeth_redei/
http://linkedin.com/in/elisabethredei

Post #599473

jamesnt

Posted Saturday, November 8, 2008 1:27 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 6:53 PM
Points: 19, Visits: 89

Thank you for the response. I just figured out that my connection string is completely wrong. It should be

file:\\.\backofficestorage\mydomain.com\public folders

Looking at the folder view from Outlook, directly under All Public Folders I have a public folder called PDM Fax. Under that folder are almost 50 sub folders, each representing a person we get a fax from (our fax server automatically routes the faxes as PDF files to the right folder).

I need to loop through each folder and get the name and created date of each PDF file in that folder.

If I can get that information into a sql table, I can show a report as to which folder has how many faxes remaining and when those faxes where entered (aka how long they've been there).

JamesNT

Post #599475

jamesnt

Posted Saturday, November 8, 2008 1:39 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 6:53 PM
Points: 19, Visits: 89

I just created the linked server. Under the SQL Server Management Studio, I can see all the folders under the PDM fax folder as tables.

Now I just have to get the data I want out of them.

JamesNT

Post #599477

jamesnt

Posted Sunday, November 9, 2008 2:44 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 6:53 PM
Points: 19, Visits: 89

I think I've got it. I'll post details as soon as I get a few free minutes as this may prove useful to others.

JamesNT

Post #599598

« Prev Topic | Next Topic »

Permissions