Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

is it possible to query MS Exchnage DB?

Posted on 2007-11-18
8
Medium Priority
?
225 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 104

Accepted Solution

by:
Sembee earned 2000 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
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 
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
 
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

What we learned in Webroot's webinar on multi-vector protection.
If something goes wrong with Exchange, your IT resources are in trouble.All Exchange server migration processes are not designed to be identical and though migrating email from on-premises Exchange mailbox to Cloud’s Office 365 is relatively simple…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Suggested Courses

604 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