Solved

is it possible to query MS Exchnage DB?

Posted on 2007-11-18
8
219 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
A list of top three free exchange EDB viewers that helps the user to extract a mailbox from an unmounted .edb file and get a clear preview of all emails & other items with just a single click on mailboxes.
In this video we show how to create a mailbox database 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 >> Data…
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…

856 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