 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Contacts / March 2005Link Contacts to SQL Server tables?
Can Outlook 2003 be set up to link to Contacts data stored in SQL Server tables? Why would I want to do that? We have reports written in Crystal Reports 6 that use custom fields in an Outlook Contacts application. CR 6 in incompatible with XP; and CR 10 cannot access custom fields. If we moved our Contacts data from Exchange to SQL Server, then we could use CR 10, and point the CR reports over there. But... would our custom Contact forms (which we open from Outlook, of course) be able to load the data from the SQL table(s)? http://www.geniusatwork.nl/geniusconnect_ms.asp > Can Outlook 2003 be set up to link to Contacts data stored in SQL Server > tables? [quoted text clipped - 9 lines] > open from Outlook, of course) be able to load the data from the SQL > table(s)? Thanks to Radek for the suggestion. I spent some time reading the FAQ on the GeniusConnect product, and discovered that it does not handle custom (i.e. user-defined fields) - so it will not work. I neglected to mention in my original post that the Contacts I am interested in are not personal contacts, rather they are Public Contacts (i.e. the Contacts folder is under the Public folders, so it exists on Exchange.) What I need is some advice on how point that folder away from Exchange and toward SQL Server. > http://www.geniusatwork.nl/geniusconnect_ms.asp > [quoted text clipped - 11 lines] > > open from Outlook, of course) be able to load the data from the SQL > > table(s)? No storage in Outlook can point to a SQL server database. You'd have to synch the two somehow. That would require custom code if you can't find some utility somewhere that will do that for you.  SignatureKen Slovak [MVP - Outlook] http://www.slovaktech.com Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm > Thanks to Radek for the suggestion. I spent some time reading the FAQ on > the [quoted text clipped - 8 lines] > toward > SQL Server.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.