|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
August 21st 06, 03:39 AM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
Accessing Outlook Contacts via ODBC
We use a propriatary application at work that allows you to connect to an
ODBC source for your address book. I'm told by the developer that as long as it acts like any other ODBC source we'll be fine. Is there a way to expose the Outlook 2003 Address book as an "ODBC Table". Complete with (Pseudo?) SQL access to the data. For example, SELECT * FROM Contacts WHERE HomeAddressState = "NY" or... UPDATE Contacts SET CallBack = "8/31/06" WHERE Anniversary BETWEEN 9/1/06 AND 9/30/06. I have seen online where we could bring another ODBC source into Outlook but I fear that our users with mobile devices wouldn't be syncing to the right databases. Which is why we'd like to do this directly. Any advice would be appreciated! Thanks! Matt 
|
| Ads |
|
#2
August 21st 06, 02:09 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Accessing Outlook Contacts via ODBC
See http://msdn.microsoft.com/library/en...ml/sa00h12.asp. It might help.
-- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Matt Neimeyer" wrote in message ... We use a propriatary application at work that allows you to connect to an ODBC source for your address book. I'm told by the developer that as long as it acts like any other ODBC source we'll be fine. Is there a way to expose the Outlook 2003 Address book as an "ODBC Table". Complete with (Pseudo?) SQL access to the data. For example, SELECT * FROM Contacts WHERE HomeAddressState = "NY" or... UPDATE Contacts SET CallBack = "8/31/06" WHERE Anniversary BETWEEN 9/1/06 AND 9/30/06. I have seen online where we could bring another ODBC source into Outlook but I fear that our users with mobile devices wouldn't be syncing to the right databases. Which is why we'd like to do this directly. Any advice would be appreciated! Thanks! Matt
|
|
#3
August 21st 06, 07:15 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Accessing Outlook Contacts via ODBC
I'll pass it on. I don't understand it...
 Thanks "Sue Mosher [MVP-Outlook]" wrote: See http://msdn.microsoft.com/library/en...ml/sa00h12.asp. It might help. -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Matt Neimeyer" wrote in message ... We use a propriatary application at work that allows you to connect to an ODBC source for your address book. I'm told by the developer that as long as it acts like any other ODBC source we'll be fine. Is there a way to expose the Outlook 2003 Address book as an "ODBC Table". Complete with (Pseudo?) SQL access to the data. For example, SELECT * FROM Contacts WHERE HomeAddressState = "NY" or... UPDATE Contacts SET CallBack = "8/31/06" WHERE Anniversary BETWEEN 9/1/06 AND 9/30/06. I have seen online where we could bring another ODBC source into Outlook but I fear that our users with mobile devices wouldn't be syncing to the right databases. Which is why we'd like to do this directly. Any advice would be appreciated! Thanks! Matt
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Accessing all user contacts | La Pedrera | Outlook - Using Contacts | 1 | July 19th 06 11:54 PM |
| Error Accessing Outlook 2003 Contacts | joel20012000 | Outlook - Using Contacts | 0 | June 17th 06 01:45 PM |
| ODBC to outlook custom forms | [email protected] | Outlook - General Queries | 1 | May 16th 06 02:14 PM |
| import access odbc linked table to outlook | Jeff | Outlook - Using Contacts | 6 | May 12th 06 03:51 PM |
| Outlook 2003 crashes when accessing contacts | Taxus | Outlook - Using Contacts | 0 | January 27th 06 03:26 PM |
Linear Mode
