InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 07:36:43 GMT20http://www.sqlservercentral.com/Forums/Topic599468-148-1.aspxI 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.JamesNTSun, 09 Nov 2008 14:44:19 GMTjamesnthttp://www.sqlservercentral.com/Forums/Topic599468-148-1.aspxI 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.JamesNTSat, 08 Nov 2008 13:39:03 GMTjamesnthttp://www.sqlservercentral.com/Forums/Topic599468-148-1.aspxThank you for the response. I just figured out that my connection string is completely wrong. It should befile:\\.\backofficestorage\mydomain.com\public foldersLooking 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).JamesNTSat, 08 Nov 2008 13:27:19 GMTjamesnthttp://www.sqlservercentral.com/Forums/Topic599468-148-1.aspxHi 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?/ElisabethSat, 08 Nov 2008 12:24:14 GMTElisabeth Rédeihttp://www.sqlservercentral.com/Forums/Topic599468-148-1.aspxHello 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/exchangeUse a specific user name and password: username = Administrator Password = ********Allow saving password = TRUEWhen 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,JamesNTSat, 08 Nov 2008 11:44:54 GMTjamesnt