Solved

is it possible to query MS Exchnage DB?

Posted on 2007-11-18
8
210 Views
Last Modified: 2010-03-06
is it possible to query MS Exchnage DB? if so can it be done with sql/CFML

basically i want to query the exchnage db and display the results on a web page. is this possible? if so and pointers on where to start would be great
0
Comment
Question by:bede123
8 Comments
 
LVL 104

Accepted Solution

by:
Sembee earned 500 total points
ID: 20308262
Not that I am aware of. It is a propriety database that only has access via MAPI.

Simon.
0
 
LVL 1

Author Comment

by:bede123
ID: 20308313
ahh well, thanks
0
 
LVL 18

Expert Comment

by:Plucka
ID: 20309077
You may have closed this a bit quickly, you should wait for more responses.

Using ColdFusion you can query certian info using CFLDAP and in CF8 there are new Exchange tags for doing this.
0
 
LVL 104

Expert Comment

by:Sembee
ID: 20309213
LDAP isn't exactly Exchange. That is the domain and is easily queried.
There are no interfaces for Exchange - ODBC or anything like that. The only interfaces are MAPI and the backup API.

Simon.
0
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
LVL 18

Expert Comment

by:Plucka
ID: 20309515
That is not correct, exchange works of AD, LDAP will allow you to query that, so if you wanted user info you can do it.

Also, there are a lot of direct Exchange intergration in CF8, see
http://www.adobe.com/devnet/coldfusion/articles/cfexchange.html
0
 
LVL 104

Expert Comment

by:Sembee
ID: 20309658
Sorry to be picky, but Exchange is NOT LDAP. Exchange is a database which uses information stored in Active Directory. You can query AD via LDAP without Exchange. However as the user hasn't said what they wanted to do it is a moot point.

Simon.
0
 
LVL 18

Expert Comment

by:Plucka
ID: 20309709
Simon,

I agree that the user hasn't specified what they want to get, and it may well be that what they want to get is not possible. But I wanted to let them know that you can get some of this information using ColdFusion which was one of the posted topic areas so I assume they have this.
0
 
LVL 6

Expert Comment

by:Spot_The_Cat
ID: 20323735
Hi,

As far as I'm aware there is an OLEDB provider for Exchange. It's slightly different in it's syntax and I've never tried programming anything with it but it may be worth looking at.

Do a google search for "exchange" and "OLEDB" - pretty good place to start.

Hope that helps
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We are happy to announce a brand new addition to our line of acclaimed email signature management products – CodeTwo Email Signatures for Office 365.
Exchange server is not supported in any cloud-hosted platform (other than Azure with Azure Premium Storage).
To show how to generate a certificate request in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.:  First we need to log into the Exchange Admin Center. Navigate to the Servers >> Certificates…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now