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

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

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