|
|
Hello,
yes you can use SQL (sort of :-) )
First thing you must do is to select your access method. SQL queries are
available with the ExOleDB provider and WebDAV. Latter is more suited for
managed code (.NET) and the only option in your scenario when you want to
connect to the Exchange Server remotely.
Other options to connect to the Exchange server are MAPI (low level),
Outlook Object model or CDO.
It really depends on the programming language you are using.
With WebDAV, you can issue a SEARCH command on the mailbox and retrieve
items based on a SQL-like query (see
http://msdn.microsoft.com/library/en-us/e2k3/e2k3/_webdav_search.asp and
msdn.microsoft.com/library/en-us/e2k3/e2k3/_esdk_key_tasks_search.asp">http://msdn.microsoft.com/library/en-us/e2k3/e2k3/_esdk_key_tasks_search.asp).
With ExOleDB (which works only locally on the Exchange server), you'll use
ADO (See last link above).
I hope, you are not to confused now.. :-)
Best regards,
Henning Krause
"Samuel" <spayet@xxxxxxxxxx> wrote in message
news:OSPU77O8GHA.3740@xxxxxxxxxxxxxxxxxxxxxxx
Hello,
I'm quite new in mail domain and need some help. I have to develop an
application. A part of it have to be link with a mailbox.
I want to know if it's possible to query an Exchange Server like we can
query a SQL server. Or is there a way to bring back the different data
from
mailbox.
For information, I work on a Windows Server 2003 with an Exchange server
2003.
PAYET Samuel
|
|