Skip to main content
Participant
May 30, 2006
Question

Linking Exchange Contacts through Access

  • May 30, 2006
  • 1 reply
  • 623 views
I have been trying to access exchange contact information by:

1) Linking Outlook Data to an Access MDB
2) Setting up the MDB as a Coldfusion datasource

The problem is, once I move the mdb to the exchange server, the mapi folder 'no longer exists'. I believe this is because they are relative to where the mdb file was set up (unfortunately if you set it up on the exchange server it still screws up since outlook and exchange are finiky together on the same machine. If I run the cfm it comes back with an error telling me that no mapi client is installed even though Outlook 2003 is on the server).

Has anyone successfully accessed exchange contact data through access? I was thinking about setting it up locally and then using an odbc on the server to access a remote shared file. The key is for Coldfusion to use a truly remote mdb so that it is not manipulated by the server However, i'm not sure if there's a better way. Any ideas?
This topic has been closed for replies.

1 reply

Inspiring
May 31, 2006
why dont you try using cfldap instead...

<cfldap server = "server_name"
port = "port_number"
username = "name"
password = "password"
action = "action"
name = "name"
timeout = "seconds"
maxRows = "number"
start = "distinguished_name"
scope = "scope"
attributes = "attribute, attribute"
filter = "filter"
sort = "attribute[, attribute]..."
sortControl = "nocase" and/or "desc" or "asc"
dn = "distinguished_name"
startRow = "row_number"
modifyType = "replace" or "add" or "delete"
rebind = "Yes" or "No"
referral = "number_of_allowed_hops"
secure = "multi_field_security_string"
separator = "separator_character"
delimiter = "delimiter_character">



http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p69.htm
DenonSixAuthor
Participant
May 31, 2006
Will that work? All I have on this machine is Exchange 2k3 and all these contacts are external contacts (in a public folder in outlook - not in AD)
Inspiring
May 31, 2006
well, i guess it really isnt that possible as of right now... http://www.forta.com/blog/index.cfm/2005/12/9/ColdFusion-Exchange-Integration here is a discussion thread on the subject started by forta...
but, if you can manage to access it from

http://www.ldapbrowser.com/download/index.php

that, you should be able to query it like any other datasource...