Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Exchange OLE DB Provider Expand / Collapse
Author
Message
Posted Saturday, November 8, 2008 11:44 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Saturday, November 8, 2008 12:24 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 9:05 AM
Points: 177, Visits: 753
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
Posted Saturday, November 8, 2008 1:27 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Saturday, November 8, 2008 1:39 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Sunday, November 9, 2008 2:44 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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 »

Add to briefcase

Permissions Expand / Collapse